Answer Posted / satyanand86.m
To prevent double counting on multi fact/multi grain queries we need determinants on query subjects that have multiple level of granularity used to aggregate facts.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
-------------How you design DWH?
How to Reset Pagenumbers in one report.
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
What are all the types of indexes in Cognos?
What is cognos reporting tool?
How Metrics Studio is better than Report Studio?
how to perform single sign in cognos by using url?
can you tell me what are the dimension tables are used in project
Explain informatica architecture?
What is cognos connection?
What are the advantages of shortcuts?
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 errors and types of errors you faced in Cognos ReportNet?
What are the components of the report studio?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
