what is dimention?explain dimentable with example?
Answers were Sorted based on User's Feedback
Answer / sunitha
Dimensions are categories by which summarized data can be
viewed.
A dimension table is a table that contain summarized
data and historical data.The dimension table has foreign key
- primary key relation with fact table.
Is This Answer Correct ? | 6 Yes | 2 No |
Answer / palzkumar
Dimension Table is a table which contains categories and
hierarchies with lowest granule.
Data stored in dimension are nothing but the masters.
Its doesn't store any numeric value or summerised data.
eg.
Product dimension
Customer dimension
Channel dimension
Time dimension
etc..
Time dimension will have the foll records..
Year > Quarter > Month > Week > Day
-------------------------------------
2009 > Qtr-02 > Aug > 35 > 04-sep-08
2009 > Qtr-02 > Aug > 35 > 05-sep-08
2009 > Qtr-02 > Aug > 35 > 06-sep-08
rgds
palz
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / palzkumar
sorry...
pls read date aug i/o sept
Time dimension will have the foll records..
Year > Quarter > Month > Week > Day
-------------------------------------
2009 > Qtr-02 > Aug > 35 > 04-aug-08
2009 > Qtr-02 > Aug > 35 > 05-aug-08
2009 > Qtr-02 > Aug > 35 > 06-aug-08
Is This Answer Correct ? | 1 Yes | 4 No |
------------- How to identify the Revenue Column in Report?
What do you understand by the term 'aggregate advisor?'
Define catalog in cognos and write its various types?
I have two date promts which optional. by defalt it will be checked.i want to unchek that date prompts.How to uncheck the date prompts in cognos
give me scenario on cascading prompts&master-detail relation
Define report item?
What is set to be Cognos configuration?
---------------Describe OLAP Reporting and RDBMS Reporting?
After generating value prompt,when we run the report... then we will get the prompt in the output.. Along with that prompt we will get diff types of symbols highlited......How can we hide those symbols?
What are products of cognos?
1.Can we use 2 packages in report studio at a time is there any alternative for this? 2. What are Star Dimensions and Star Facts? 3.What are dimensions and facts in project ? 4.What is difference between 3 NF and Star Schema ? 5. What Is Data Modelling? 6. How much time do u need to create a report ,if u have four dimensions and 1 fact ? 7. How do u create a Model ? 8. How do u connect a Parameter in a list ,such a way it has to show relative objects in Cross tab ? 9. To display region list in separate pages ,how do u do ?
What is meant by grouped star schema