Interested to Buy Any Domain ? << Click Here >> for more details...
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
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 difference between informatica power mart and power center?
What is the use of cognos decision stream?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
What is an olap designer?
how to create cubes in transformer ?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
Can you define cognos impromptu?
How do we drill through from a powerplay cube to reportnet?\
Mention the difference between ‘macros’ and ‘prompt’?
What actually a project contains?
What are the services provided in cognos 8?
How can we create a dynamic column name in cognos?
What are all the types of report?
What is defined as data mining?
