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 are the different types of reports present in cognos?

0 Answers  

write the sql query to display 5th and 10th row in a table?

5 Answers   CTS, IBM,

can you apply grouping on crosstab?

1 Answers   CTS,

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

0 Answers  

how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?

6 Answers   HCL,

what are slowly changing dimensions? Why we are used scd?

0 Answers   IBM,

How to crate cubes in transformer ?

3 Answers  

which difficult you faced in your project?

1 Answers   IBM,

difference between join and union in reportstudio?

2 Answers   IBM,

What are the services provided in cognos 8?

0 Answers  

How to do Performence Tunning in Cognos Reports?

0 Answers  

what are the types of facts ? explain them?

2 Answers   Business Objects, Informatica, Syntel, Teradata,

For more Cognos Interview Questions Click Here
Categories