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 is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
What is cognos powerhouse?
Can we test the report other than manual testing?
Cleared COG-112 with 100% score today. What next certification should i go for?
What are the advantages of using cognos sql?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
can we insert all types of charts in a list report? what r the realtime prompts?
What is the use of powerplay web viewer in cognos?
What is difference between informatica power mart and power center?
What is a Query Subject?
What r the names of the reports that you prepared?
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
----------------Diff b/w Dimensional modeling and Relational modeling?
What is the difference between Open Connection command ang Open Session Command?
Can you define report item?