What is the basic relationship between measures and
dimensions in transformer modelling
Answer Posted / ushasree
In transformer we need at least one defined measure to
build a powercube.Dimensions represent the high level of
data.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
-----------Diff b/w OLAP and RDBMS?
2. What functional area you worked on.
Define report item?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
What is difference between primary key and unique key constraints?
what is log in cognos?
What are products of cognos?
What are the types of hierarchies?
What are the types of studio present in Cognos?
how you create security to reports?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
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 cognos connection?
How can I test reports in cagonos?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)