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 |
Can anyone explain the procedure for configuring cognos8 with oracle as Content Manager/Content Store? I know the configuration of cognos8 with SQL SERVER (Like how to create CM database in oracle and applying securities to access that Database from cognos8 (Cognos Configuration)
----------------What is Surrogate Key?
advantages of cascade prompt ???
I have tables like tableA&tableB,in tableB columns(sno,month,netrevenue,year),by using both the tables we hava to create list columns like(country,month,net revenue)when i run the report if my retrevenue'0'this plasa i want to display'NULL'
Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??
What are the differences between Cognos 8 and Cognos 7.x version?
Hi Techies, Need your help for achieving this requirement. We have got a requirement to display a report in a page which should diplay max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should display 20 (divisible by 5) and on other page it should display 3 rows. Please advice!
What is the model filter?
what is boxtype
What are the different type of securities can we apply in framework manager?
What is a business view? and what is the difference b/w business view and folder?in cognos report life cycle when it will be involved ?
What is the use of Tree Prompt? Where it is used?Pls give me a real time example?