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 |
If there are two values at value prompt level and when selecting first value it have to go to date prompt and when selecting second value we have to get output without any prompting. How to solve this issue. if any plz mail me on this vasuattada@yahoo.co.in
What are the advantages of using cognos sql?
What do you understand by the term 'dynamic cube'?
what is sdibling function tell me the some functions
How can I disable the drill-down for the last level of my dimensional hierarchy ????
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
how to create measures and dimensions?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
What is the use of report studio?
What is the difference between Open Connection command ang Open Session Command?
1. Explain your project.
is there any possibility to hide items other than render variable?