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 to join multiple db in catalog?
How many reports did you create in your project?
My report output is showing data as 1 11 111 2 22 222 3 33 333 How can I sort this to 1 2 3 11 22 33 111 222 333
What is the difference b/w macros and prompt?
what is Cognos Visualizer and Cognos Scripting?
3.User1 doveloped some report,user2 modify the same report and user 3 also updates in that same report? how to identify that report will be modified or not?
1 Answers IBM, Thomson Reuters,
why u need to publish the package?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
how u provide security in power play transformer???
3 Answers iFlex, ITC Infotech, TCS,
I have 3 objects (list,cross tab and chart)in one page, when u run report display each object in each page. how can i do?
What is metric studio?what is score cards and how to implement score cards what is the use of score card?
i was asked what are the caluclations done by you in your report? plz give reply