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 |
what is the use of lock and unlock
how to test reports in cognos?
if report performance is low how can check 3 areas in framework manager?.what are the 3 areas concentrate?
how can i provide security to my reports in report studio?
Tell me about Schemas?
-----------Diff b/W Aggregate Function and Rollup Aggrigate Function?
how u provide security to reports??how u provide security to packages ?
What is the difference between drill through, drill across?
how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?
What is the concept of using Dimension allocation "By Measure"? How Transformer use when computing the Base measue?
What are the steps to import the two data sources in framework manager?
What is cognos reporting tool?