What is the basic relationship between measures and
dimensions in transformer modelling
- 5 Answers
- 7944 Views
- I also Faced
- E-Mail Answers
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 you define drill down and drill up?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
how to perform back drill through in cognos 8 what is the use of it
How we check the errors before running the report?
How can you link a query to a data container manually in Report Studio?
what is the role of cognos comsultant?what actually it means?pls reply
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
What are all the different types of prompt in cognos?
what type of charts we create mostly in realtime? plz help
After installation of Cognos Reportnet how do i know how much of entire Cognos server is being utilised at any instatnt of time?
What's the differance between each studio in cognos 8?
what is field set? what is the query calculation and layout calculation?
Teradata 
