what is the difference between native sql and cognos sql?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
what is logs in cognos
1 Answers Target, Thomson Reuters,
suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?
15. If I select the current month and year how can we display previous 11 months data?
how to add a new dimension in the powerplay transformer.i.e already we have devbeloped one cube. in that we want to add one new dimension cn anybody plese tell me the step by step procedure.
I have 3 objects (list,cross tab and chart)in one page, when u run report display each object in each page. how can i do?
What are the steps to create DMR model in FM? Give me brienf discription as interview point of you?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
How to create a Left Outer Join in FM? Please explain.
what is differences between the group span and levelspan
example for generated prompt
Hi Friends, What is the Max no.of rows in a report & a page? If we have Master, Detail Reports, I have define drill through, Requirement is When i run Master Report it should run in HTML, when i drill through to detailed report it should get into PDF is it Possible in Cognos? Thank You Kumar