Interested to Buy Any Domain ? << Click Here >> for more details...
what is dimention?explain dimentable with example?
- 3 Answers
- 9485 Views
- Syntel, I also Faced
- E-Mail Answers
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 |
Can anyone tell me which automation tool is used in cognos,is it a testing tool or performance enhancing tool Thanks in advance
What's the differance between each studio in cognos 8?
In which type of report we can create school time table in cognos? [I want period numbers in rows like period 1, Period 2, period 3, period 4, period 5 and class numbers in columns like 8th class, 9th class, 10th class and subject names in cells] Genelally school time table is prepared in crosstab report, but subject names are not measures and a crosstab cell can not contain non-measures. This is my problem,,,,,
if there are list,crosstab,chart how can you apply a single filter to all object?
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 ?)
how do you test reports in reportnet? what do you record in unit testing documents? pls give answer in detail......
Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I have been asked this question twice..i think this feature is available in cognos 10 version..not very sure....Could anybody highlight?
What is meant by alternate drill down with ex?
what are the components having in the report studio using interface eg:insertable objects pan,properties pan
Can you define confirmed dimension?
Main Differnce between Cognos7 and Cognos8
How to create a Ratio in Cognos Report studio Reports?
Teradata 
