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 create multilingual reorts?
what is power prompt in cognos ep7series?what is the use of this?
What is meant by Tabular SQL in Cognos Report net
What is an open session command in cognos connection?what is it meant for?
Why we take so long time to display date prompt before displaying a report? How can we reduce the time?
Interval Prompt's Usage? Example for usage in Project
what is report view?
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
difference between stored procedure and function?
cognos is holap or molap or rolap
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
-------What are the Adv of Star Schema and Snow Flake Schema?