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
- 20646 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 a datastore in cognos?
what is the difference between native sql and cognos sql?
Explain the difference between powerplay transformer and power play reports?
What are products of cognos?
How create measures and dimensions?
What is defined as catalog and types of catalogs in Cognos?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
What are various types of gateways in cognos?
What are initial page components of Cognos connection?
How do you improve the performance of the Cognos Analytics report
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?
tell me two or three issues from client side and how to solve those issues?
What is a Datastore in Cognos?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
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.
