What is the basic relationship between measures and
dimensions in transformer modelling
Answers were Sorted based on User's Feedback
Answer / ushasree
In transformer we need at least one defined measure to
build a powercube.Dimensions represent the high level of
data.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / neelima
dimensions are nothing but the key characters with witch
we link the tables and measures are the values in the table
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / palzkumar
I think, Dimension Table is linked with Measures(Fact
Table) as foregn key.
So its, 1:n relationship...
rgds,
-palz-
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / laxmi
relation ship is like a star schema fact has the foreignkeys and dimension primary keys so the foreign keys in the fact table act as a primary so there is one fact and 'n' no.of dimensions there is 1:n relation up to my knowledge
| Is This Answer Correct ? | 0 Yes | 1 No |
How many fact tables you have in your project?
What is snapshot thumbnail
What is difference between data mart and data warehouse?
After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate<fromdate its an error. How can we generate the user defined error message for this type of error
Can we install cognos on windows 7?
Hai frnds, Any body tell to What is Granularuty in cognos Please help me.i can search in so many browsers but i canot get the answer
What are the types of hierarchies?
What is the function of model design accelerator?
What is defined as data mining?
Define query items?
What is Cardinality b/w Fact to Fact?
2. What is With Clause In Cognos?