how many facts&dimensions tables in a sales project?can any
body name those dimensions and fact tables please
Answer Posted / ark chowdary
There is no mandatory for maintain Dimension and Facts.
We cant specify.why bcz its depends on clent requirement
itself they will tell everything.
Normally u can say like this
Dimensions------> we have Product Dimension,
Time Dimesion,
Country Dimension,
Customer Dimension,
Order Deimension,
Shippers Dimension,
Order Details Dimension,
Inventory Dimension,
Facts------------> We have Sales
Fact,Revenue,Discounts,Quantity,Price etc................
I hope now its clear for u.
If still any thing else pls letme know.
Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is the report studio?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
----------------Diff b/w Dimensional modeling and Relational modeling?
i have one file i saved in csv how can i take these file into framework manager
What is the difference between the content store and content manager?
Define datastores in cognos?
How to do Performence Tunning in Cognos Reports?
what is log in cognos?
9. What was the most complex type of report you dealt with?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
What is the deployment requirements used in cognos?
How we check the errors before running the report?
Explain what is the difference between microstrategy and cognos reporting tool?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........