Answer Posted / vsandhyana
To create the relationship between fact and dimension you
need to have calendar_date also in your fact table and than
only you can make the relationship with that.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is the role of cognos comsultant?what actually it means?pls reply
how to create measures and dimensions?
Define report item?
can you tell me what are the dimension tables are used in project
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 components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
What are all the components of Report Studio?
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
how you migrate reports to cognos 8 from previous versions?
Can you define metrics designer?
How we check the errors before running the report?
What are all the types of hierarchies?
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
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 the difference between filter and condition?