what are typees of dimensions

Answers were Sorted based on User's Feedback



what are typees of dimensions..

Answer / ramesh

Conformed Dimension,Degenarated Dim,Junk dim those all are
concepts in DWH. But in Cognos we have some more dim like
Regular dims,Measure dim

Regular Dim Mainly it is used for drill up and drill down
purpose. It contains Hierarchial structure. It have three
propertise having Business key,member Caption,member
description.

Is This Answer Correct ?    5 Yes 0 No

what are typees of dimensions..

Answer / m m naidu

Types of dimensions:

1.Conformed dimension:A dimension which can be shared by
multiple fact table is known as conformed dimension

2.Junk dimension:A junk dimension is a collection of random
transactional codes, flags and/or text attributes that are
unrelated to any particular dimension.
simply to say a randomly used dimension is junk dimension

3.Degenerated dimension: It is a dimension which has only a
single attribute. This dimension is typically represented as
a single field in fact table. These dimensions are used when
fact tables represent transactional data.

Is This Answer Correct ?    2 Yes 0 No

what are typees of dimensions..

Answer / gowtham

there are 3 types
1. junk dimension:: junk dimension is nothing but unwanted data
ex: spam
2. conformed dimension:: a dimension which can reuse access the multiple facts table
3. degenerated dimension:: at the time of any
transaction it will give temporarily id
ex: self desk, invoice number,

Is This Answer Correct ?    0 Yes 0 No

what are typees of dimensions..

Answer / gopal

4 types

Conform Dimension
Junk Dimension
degenerated Dimension
Role play Dimension Ex-Date

Is This Answer Correct ?    0 Yes 0 No

what are typees of dimensions..

Answer / gopal

Conform Dimension
Junk dimension
degenerated Dimension
Slowly Changing Dimension
Role play Dimension.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

What is the difference between macro & Parameter

1 Answers   IBM,


actually my qus is i used some tables in my model,i published that to connection i use that one.at the same way my team member added some new tables and again he published how can i get my model in connection pls pls explain me..........

1 Answers  


difference between imprompt and reportnwt1.1

2 Answers   HSBC,


What is the complex report you faced in real time?

0 Answers  


what is exact catalog size?

4 Answers   IBM,






If anyone has COG-185 IBM Cognos 8 Migration Professional Certification Dump, please mail me at: sushma_biswas@yahoo.com

1 Answers   EDS,


Hi, In My Table i am having a Column Emp ASa Fullname In My Report I WAnt First name&Lastname?how I'll Get This One?Pls Ans Me

2 Answers  


wt is scope relationship?

2 Answers  


Can you define cognos decision stream?

0 Answers  


using of matric studio we can developed to scorecard ... what is the meaning by scorecords

1 Answers  


What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

0 Answers  


Hi Cognos Experts,I am Having DatePrompt In My Report.I want to display The Report Between Twodates Like jan-SEP How can We Achieve This one?PLS Expain Me With Ex:

3 Answers  


Categories