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 advantages of Cognos?
What are the components used in web tier?
What is the size of database for you project?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
what is the difference between querystudio in reportnet and cognos8
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
9. What was the most complex type of report you dealt with?
What are the methods by which it non-durable model could be changed into the durable model?
What is the difference between drill through, drill across?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
What is difference between content store and content manager?
Write types of folders present in cognos?
What is the difference between the standard and metrics folder?
Define olap designer?
dumps needed ASAP for - C2020-180 Cognos IBM Certification