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 types of batch available in cognos?
what is hints in cognos and where we use it.
What is the use of cognos decision stream?
Can you define slice?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
What is looping and how to avoid it in framework manager?
Why is auto-regression used in forecasting used on cognos platform?
2. What functional area you worked on.
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
1. Explain your project.
What is a Transformer?
Diff b/w Crossproduct and Outerjoin?
What are the types of security?
how you create security to reports?
What are the types of folder present in cognos?