how many facts&dimensions tables in a sales project?can any
body name those dimensions and fact tables please
Answer Posted / vijay kalyan.v
Hi Pinky....
To identify dimensions and fact tables we no need to have
real time exp. Just Assume few dimensions and think for
proper justifications according to ur Project.” But Stick
to Basic Concepts".
My Assumptions
Dimensions are Products, Location(Area),Time, Employees,
Retailers or Dealers, Inventory, Logistics.....etc
Fact (Measures)
Sales target, Returned Sales, Purchase Returns
Revenue, Quantity, gross profit, net income, losses,
margin, Fright, operational cost
unit cost, unit price...etc.
Good Luck
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the advantages of using cognos sql?
how you create security to reports?
what is catalog and types of catalogs in cagnos and which is better?
What are the advantages of shortcuts?
What is looping and how to avoid it in framework manager?
What is called a slice?
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
Define metrics studio?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
What is the metric store database?
What do you understand by the cognos?
What is the difference between the content store and content manager?
What is difference between primary key and unique key constraints?
what are the dimensions that you have in your current project?list them?
Write some methods to apply securities in framework manager model?