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
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
How can create users and permissions in cognos?
What are the types of folder present in cognos?
What are the components used in web tier?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
When we save a report in report studio with what extn it save?
hi my name is siraj i want to know cognos queriy language
What is the use of powerhouse?
Can you explain the advantage of using shortcuts?
What is the difference between a cascading report and drill through the report?
Define metrics studio?
What are types of batch available in cognos?
difference between impromptu and cognos8
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com
What are slice and dice?