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
Can you define set to be cardinality?
What are types of batch available in cognos?
How create measures and dimensions?
Can you explain dynamic query mode?
what is degenerate key in oracle ?whare do we use it?
------------- How to identify the Revenue Column in Report?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
Cleared COG-112 with 100% score today. What next certification should i go for?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate Can you define metrics designer? 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 stitch query in reportnet? Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest. Explain the different types of views used in cognos.