Search results for query: *

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.

Glad you got it sorted out. Thanks for the star! :-)

Hi, Do you have access to Framework Manager? If so, select the items in Framework Manager, then use the Test option to view the results. Look at the generated query and make sure that you are seeing a left outer join in the SQL - if not, go back and check the relationship(s). Once you have...

Hi, You could try using the extract() function to extract the year from your result. Does this give you what you need? Regards, MF.

Hi, For C8 Report Studio, select the column heading, set the source type property to be text, then enter the relevant text in the text field property. Regards, MF.

Hi, You should also see it in the following places: C:\Program Files\cognos\c8\templates\ps\portal C:\Program Files\cognos\c8\templates\ps\ags (if you have Event Studio) C:\Program Files\cognos\c8\templates\ps\qs (if you have Query Studio) C:\Program Files\cognos\c8\templates\ps The fact...