What is the basic relationship between measures and
dimensions in transformer modelling
- 5 Answers
- 8007 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
how u will determine the performence tune will occur either in report or system
What is a Folder?
What are the main services provided by application tier?
What is meant by junk dimension?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
What is the difference between the content store and content manager?
What is a Transformer?
What are the themes in a data warehouse?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
can you tell me what are the dimension tables are used in project
Can you explain the advantage of using shortcuts?
What are initial page components of Cognos connection?
What is a Pivot?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
