Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mfgf
  • Order by date
  1. mfgf

    no multi-select prompt (base is DMR)

    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.
  2. mfgf

    Cognos 8.2 Analysis Studio - Context Filters

    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...
  3. mfgf

    Decision Stream 7.1 Command Line argument to run Decision Stream Build

    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...
  4. mfgf

    Correalted Query in Report Studio

    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...
  5. mfgf

    Decision Stream 7.1 Command Line argument to run Decision Stream Build

    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...
  6. mfgf

    Cognos Sql Server Error

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

    Cognos Sql Server Error

    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.
  8. mfgf

    Simulating full outer join

    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.
  9. mfgf

    Impromptu 6.0 in XP

    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.
  10. mfgf

    Need help of Cognos 8.0

    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.
  11. mfgf

    Upgrade from 7to 8BI. Report of 5 charts only 4 show data

    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.
  12. mfgf

    Need help of Cognos 8.0

    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...
  13. mfgf

    Sorting values in Analysis Studio

    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.
  14. mfgf

    SDK question: How to send a "range" parameter to a report?

    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.
  15. mfgf

    Cognos Cube Data level security

    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.
  16. mfgf

    Report Studio - Nulls Suppressed

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

    Report Studio - Nulls Suppressed

    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...
  18. mfgf

    How to use _age() function

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

    Column Header Question

    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.
  20. mfgf

    COGNOS 8.2 Analysis URI Gateway error

    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...

Part and Inventory Search

Back
Top