how many facts&dimensions tables in project? it's very
urgent.........
Answers were Sorted based on User's Feedback
Answer / mow
Depending on the project it varies...
in general 3 - 4 facts and 15 - 20 dimensions can be there
in a medium scale project
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / palzkumar
NOT more than 16 Dimension.
cuz a Fact table can have maximum 16 foreign key only.
-palz-
Is This Answer Correct ? | 0 Yes | 1 No |
How many fact tables and dimension tables in your project?
What is limited local? and the uses?
What is the difference between Standard and Metrics folder?
What is a Query Subject?
Define the cognos reporting tool?
How to create a Ratio in Cognos Report studio Reports?
how to access the database directly from cognos reportnet
Hey Techies, Could you please tell me about query processing? and what is database only and what is Limited locale? brief plz..
--------------what is MemberCaption?
What are all the different types of prompt in cognos?
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
What is the complex report you faced in real time?