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
- 20836 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
-----------------What is Determination Model?
Explain the difference between native sql and cognos sql?
what is stitch query in reportnet?
What are shortcuts? Where it can be used? What are the advantages?
What is model filter?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
--------------Diff b/w ODS and OLAP?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
Can we test the report other than manual testing?
Define query studio?
What are the types of studio?
What is defined as Query studio?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
What is the use of powerhouse?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
