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

How do we convert from Numeric to be Words?

0 Answers  


i would like enter some empty space after every 3 rows how is it possible....?

1 Answers   IBM,


What are the problems you have faced recently while developing reports in report studio? And how did you solve those problems? This question is asking in many interviews,,,,so pls help me,,,,,

2 Answers  


Can you please tell me the limitation of Excel file when exporting from report to Excel? I can export to HTML and PDF but I can't export to Excel. The report is more than 13000 rows. When exporting to Excel, system can view it. After that, I save the report to an Excel file. The size of Excel file is more than 11 MB. But I can't view this file by Excel. Please help me to solve this problem. Thanks!

1 Answers  


---------------Describe OLAP Reporting and RDBMS Reporting?

0 Answers   Bank Of America,






can reportnet supports cubes???

4 Answers   IBM, Wipro,


Can anyone tell me which automation tool is used in cognos,is it a testing tool or performance enhancing tool Thanks in advance

2 Answers   SAP Labs,


what are summary filters? grouped filters?

3 Answers   IBM,


Hi, I am Searching on Cognos 8, I don't know how to explain the projects in cognos.Can anybody help me in this regard. My email id is hchereddy@gmail.com. Thanks in advance

0 Answers   IBM,


what is fact less fact give me proper example?

2 Answers  


How to use Cascade Macro in Report studio? Anybody know about Cascade Macro & and the procedure to use?

1 Answers   AIG, Niteo,


can anybody tell me when do use 'running total'...give an example for the usage of running total

2 Answers   EDS,


Categories