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 difference between informatica power mart and power center?
Explain what is the difference between microstrategy and cognos reporting tool?
whats the difference between previous version of cognos and cognos 8 BI?
How to test a cube?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
What is the deployment requirements used in cognos?
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.....
7. What is performance tuning?
What is meant by Reportstudio shortcut?
Give the advantages of cognos?
-----------------What is Direct and Conventional loading?
What is the enterprise class platform architecture of cognos 8?
How to deploy from one server to another server?
what is stitch query in reportnet?
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?