Interested to Buy Any Domain ? << Click Here >> for more details...
how many facts&dimensions tables in a sales project?can any
body name those dimensions and fact tables please
- 6 Answers
- 20477 Views
- TCS, I also Faced
- E-Mail Answers
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 is model and say about process how to create model and how to test model?
What are all the types of hierarchies?
What are all the types of gateway used in Cognos?
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
Define olap designer?
Can you explain cognos planning?
how to test reports in cognos?
What are the advantages of cognos?
How create measures and demensions?
What are the types of security?
What is Fullouterjoin?
write a query to display the departments with no employee?
difference between impromptu and cognos8
Tell me about Dnamic and Static Dashboards?
What is looping and how to avoid it in framework manager?
