what is dimention?explain dimentable with example?

Answers were Sorted based on User's Feedback



what is dimention?explain dimentable with example?..

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

what is dimention?explain dimentable with example?..

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

what is dimention?explain dimentable with example?..

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

Post New Answer

More Cognos Interview Questions

Due Date (Highlight Issues in Blue where Due Dates are less than Todays Date),I have only Due Date column then how to over come the problem.How to find out which Due Date are less than Today Date...Kindly provide the detail steps to my mail ID-->asimcognos10@gmail.com

2 Answers   IBM,


How we check the errors before running the report,plz let me know the answer

4 Answers   TCS,


How to create a dynamic header in a crosstab report using cognos 8.1 report studio?please suggest me.

1 Answers  


how u migrate the reports from impromptu to reportnet???

3 Answers   Wipro,


-----------------What is Singleton?

1 Answers   BoA, Cap Gemini, TCS,






What are the types of studio?

0 Answers  


how can you set the image in the report

1 Answers   HSBC,


hi friends pls forward impropmtu interview question

0 Answers  


What are the services provided in cognos 8?

0 Answers  


What DB View and Bus View?

0 Answers  


Explain the characteristics of cognos?

0 Answers  


If anybody need certification dumps like COG-112 COG-122 COG-132 THEN MAIL ME ON kris.bi121@gmail.com.all are latest dumps test taken on july-09

42 Answers  


Categories