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 the difference b/w macros and prompt?

0 Answers  

How to Create users in cognos Access Manager from 1) front end 2) back end

1 Answers   TCS,

What is Outerjoin?

2 Answers  

What do you understand by the term 'aggregate cache'?

0 Answers  

How do add dynamic titles in PP?

3 Answers  

How can we create a dynamic column name in cognos?

0 Answers  

1. Explain your project.

0 Answers   IBM,

How to move reports one server to another server?

2 Answers   Wipro,

It is possible to give 2 query items has measures in cross tab?for ex:row as products,column as year and measure as revenue,sales year....like that.It is possible r not ?If it's possible pls tel me the process....

2 Answers  

whats the difference between previous version of cognos and cognos 8 BI?

1 Answers   IBM,

How to hide/unhide the prompts which are not used by unauthorized users?

3 Answers  

Why we take so long time to display date prompt before displaying a report? How can we reduce the time?

2 Answers  

For more Cognos Interview Questions Click Here
Categories