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
- 20395 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 are all the types of gateway used in Cognos?
What are the considerations regarding performance kept in mind while setting up cognos?
What is the difference between ‘macro’ and ‘prompt?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
What is the difference b/w macros and prompt?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
what is stitch query in reportnet?
whats the difference between previous version of cognos and cognos 8 BI?
What is the advantage of using shortcuts?
What do you mean by query studio?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
What are the components of report net?
What is the importance of having monitor service in cognos?
how to create measures and dimensions?
