what are typees of dimensions
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Answer / gopal
4 types
Conform Dimension
Junk Dimension
degenerated Dimension
Role play Dimension Ex-Date
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gopal
Conform Dimension
Junk dimension
degenerated Dimension
Slowly Changing Dimension
Role play Dimension.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is mean by cognos powerhouse?
what is log in cognos?
what is a prompt value in report studio and variables ?
When You Import data into catalog You have complex columns names. How do you change the Name of those columns?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
what is the difference between aggregation and role up aggregation ?
How to hide/unhide the prompts which are not used by unauthorized users?
What is IQD?What is contained in IQD? How you create IQD In ReportNet FrameWork?
how many types of formats you can run a report using cognos?
How to do Performence Tunning in Cognos Reports?
what is filter?give me one example that you created a report in your project?
how to create average on totals of different departments employees salary...? consider we have 3 dept and in each dept 10-15 workers i need to get the totals separately for each dept and average of there totals..help me pls