What is the basic relationship between measures and
dimensions in transformer modelling

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are shortcuts? Where it can be used? What are the advantages?

547


1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.

1762


What do you understand by the term 'dynamic cube'?

562


Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

1595


What is a Transformer?

648






Can you define drill across?

560


can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr

1563


What are initial page components of Cognos connection?

608


Can you define materialized view?

617


What do you understand by the cognos?

540


I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.

1620


how to test reports in cognos?

582


5. Which type of report you build more, list, crosstab or chart and why?

1589


how can you get the errors in job? when loops are araised we get error?

1648


What is called a slice?

573