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
- 20643 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
Explain the difference between powerplay transformer and power play reports?
What are the steps to import the two data sources in framework manager?
how to merge 2 crosstabs thans
-----------With out using DrillThrough how to do Reports?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
what is log in cognos?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
Please explain the different stages in creating a report in cognos report net?
Can you define pivot?
whats the difference between previous version of cognos and cognos 8 BI?
What is the use of powerplay web viewer in cognos?
how to explain health care project and which reports we can create in health care doain?
What are the components of the report studio?
What is a Query Subject?
Explain about scorecarding?
