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

Wht is difference between content store and content manager?

2 Answers   Satyam, Tech Mahindra,

Hi, I Want To Display The Report. From MOnday To Friday By Using Date Prompt.PLs Expain To Me...

1 Answers  

what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

0 Answers   IBM,

How to schedule the report twice in a day?

2 Answers   Cognizant,

tell me two or three issues from client side and how to solve those issues?

0 Answers   TCS,

What are the components of report net?

0 Answers  

What is Parametermap?

2 Answers  

How many fact tables and dimension tables in your project?

3 Answers   IBM,

how to convert crosstab into list?

4 Answers   TCS,

what r the names of the reports that u prepared???

9 Answers   Covansys, IBM, Wipro,

----------------------Diff b/w MOLAP and ROLAP?

4 Answers   Bank Of America,

Is it possible to apply access manager user rights in impromptu?

1 Answers  

For more Cognos Interview Questions Click Here
Categories