Answer Posted / varma
dimension are descriptive information. for example customer
name,address. where as regular dimensions are used to create
the hierarchies in dimensions. for example let us take
product dimension.
u can create hierarchies in product dimension using regular
dimension. u can create hierarchies as product
number,product name, product line code,product description.
the regular dimensions are used in analysis studio for drill
down and drill up methods
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what is catalog and types of catalogs in cagnos and which is better?
What is meant by Reportstudio shortcut?
what is model and say about process how to create model and how to test model?
how to create cubes in transformer ?
9. What was the most complex type of report you dealt with?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
which type of project we r going to snowflake schema
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
what are the features in cognos8ui
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
What are the steps to import the two data sources in framework manager?
what are slowly changing dimensions? Why we are used scd?
how to perform single sign in cognos by using url?
What are all the advantages of Cognos?
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 ?