how many facts&dimensions tables in a sales project?can any
body name those dimensions and fact tables please
- 6 Answers
- 18670 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / harry
facts and dimensions are considered according to the
project requirement ,we cant say particular number ,its
depend upon the project environment ,if you want to know
more about fact and dimensions ,Cognos provides default GO
sale package by using that you will be able to get your
answer.
here are some facts and dimensions:
Dimensions are time, products, retailer type, activity
desc, sale staff, and retailer type, return reson, order
method, order header, sales staff...Etc
Fact is sales target, closing inventory, expected volume,
activity, return quantity, revenue,
Quantity, gross profit, netincome, lossess, margin, product
cost, unit cost, unit price, unit sale pruce...etc.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Can you define fan trap?
How to do Performence Tunning in Cognos Reports?
When we save a report in report studio with what extn it save?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
What is the use of cognos decision stream?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
What are the advantages of shortcuts?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
What is the size of the cube?
What are all the types of gateway used in Cognos?
What is the difference between a data mart and a data warehouse?
Define query items?
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
