Answer Posted / sivakumar.v
Confirm dimension;
Confirm Dimension which is used to link more then 0ne fact
table or data mart.
For ex;
In our project, we have created five data mart of different
subject area ,our client requirements is to create a report
by linking all the data mart or subject area .To achieve
that report we linked all the data mart through Person
confirmed dimension .
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
Explain how many universes can be created in a project?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
Difference between zabo and webi?
What sort of existing documents should business analysts refer to when starting on a new project?
What is a bo repository?
Can more than 1 metric be applied on an analytic in business objects?
How would you format some text using css to be verdana and bold?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Did you face any problems while creating reports? Name? Solutions?
What is the difference between condition & filter?
how to create metric universe ?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?