Recent content by mfgf

Hi, Quick question - what happens if you remove your tree prompt and its associated query, then change your expression to be: set([your hierarchy] -> ?p1?) Do you then get a multi-select tree prompt by default? MF.

Hi, There are currently no features in the User Interface of Analysis Studio that allow you to configure the number of members displayed in the Context dropdown. The Search option is there to make finding the required context easier. Again, there's no way to change the UI here. Probably not...

Hi, Within a jobstream, most of the nodes will run as part of the jobstream executable (rundsjob.exe). This applies to SQL nodes, procedure nodes etc. The exceptions are the build nodes, which each fire off separate executables (databuild.exe and dimbuild.exe). If you want your jobstream to...

Hi, The short answer is you would need to code this query yourself, but to be honest that's not really best practice in Report Studio. Why do you need a correlated query - a derived table (which you get by default) would probably be just as efficient, and could easily be modelled in Framework...

Hi, A jobstream is fired off using the rundsjob.exe command. Fact builds use databuild.exe, and dimension builds use dimbuild.exe. If you want to find out what the relevant command is to fire off a build, open the DecisionStream catalog in the designer, right-click on the relevant build, and...

Hi, Glad you managed to track it down. Thanks for letting us know the cause. Best regards, MF.

Hi, No, I don't think it will cause you a problem (unless one of the items or joins you are using somehow depends on your faulty catalog calculation). Regards, MF.

Hi, In Cognos 8 using the Query Explorer, you could extract your data using two separate queries, then add a join between the queries using 0..1 -> 0..n cardinality. This should give you the full outer join capabilities you are looking for. Best regards, MF.

Hi, This is a mode for running applications within XP - nothing to do with Impromptu directly. For details, see http://support.microsoft.com/kb/q292533/ Best regards, MF.

Hi, Sample questions are available at the back of the Student Handbook. All the docs you require (including the handbook) are available on the Cognos website above. Regards, MF.

Hi, It probably means that the query subject calling the stored procedure needs to be repaired in Framework Manager. You will probably need to open and save the query subject, or worst case - delete and recreate it, then republish your package. Regards, MF.

Hi, There's lots of good information about the Cognos 8 Certification Programme (Academy) on the Cognos website. The following link is a good place to start: http://support.cognos.com/en/training/certification/customer.html If you have any specific questions not answered by this, please feel...

Hi, Is is something of an issue with DMR at the moment. All I can suggest is that you log it with Cognos and see what response you get. Regards, MF.

Hi, Instead of using "ParamDisplayValue('param')" in your report, use "ParamValue('param')" to see the real parameter value (and not its nicely formatted display). Once you have a handle on what the real expected value is, you should be able to pass the relevant value yourself. Regards, MF.

Hi, Only if you are using a Series 7 Access Manager namespace as your authentication provider. If so, you will be able to point at the namespace from within Transformer, then set up user class views within your dimensions to control which user classes can see which data. Regards, MF.