how many facts&dimensions tables in a sales project?can any
body name those dimensions and fact tables please
Answer Posted / ark chowdary
There is no mandatory for maintain Dimension and Facts.
We cant specify.why bcz its depends on clent requirement
itself they will tell everything.
Normally u can say like this
Dimensions------> we have Product Dimension,
Time Dimesion,
Country Dimension,
Customer Dimension,
Order Deimension,
Shippers Dimension,
Order Details Dimension,
Inventory Dimension,
Facts------------> We have Sales
Fact,Revenue,Discounts,Quantity,Price etc................
I hope now its clear for u.
If still any thing else pls letme know.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What are all the components of Report Studio?
What is defined as catalog and types of catalogs in Cognos?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
Can you define a catalog and types of catalogs in cognos?
Can you explain dynamic query mode?
What is model filter?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
---------------Describe OLAP Reporting and RDBMS Reporting?
----------------Diff b/w Dimensional modeling and Relational modeling?
How is cognos model organization works?
New coloums are added in database, then how you know in report level
What are all the types of indexes in Cognos?
what are the features in cognos8ui
What are the advantages of using cognos sql?
What is the function of cognos dispatcher?