Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

what is dimention?explain dimentable with example?

Question Posted / mkreddy

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

what is filter?give me one example that you created a report in your project?

3 Answers   IBM,

What is Cognos Mashup Services .what is the use of Cognos Mashup Services and where to use.

1 Answers  

how to perform single sign in cognos by using url?

0 Answers   IBM,

what is the difference between rollup aggregation and aggregation ?

1 Answers  

If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.

0 Answers   Wipro,

What are all the advantages of Cognos?

0 Answers  

2. What is With Clause In Cognos?

2 Answers   Wipro,

What is portal page?

5 Answers   TCS,

What is a dashboard in Cognos Report Studio and how do we creae it

2 Answers  

what is mean of Meta data definistions?

4 Answers   IBM,

can anybody send me interview questions with answers on IBM cognos-FM and Report studio. My mail ID is: cskcognos@gmail.com

1 Answers  

drillthrough vs master detaild report,which one is the best by performance?

3 Answers   IBM,

For more Cognos Interview Questions Click Here
Categories