How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
Answer / madhu
One way of bringing the Aggregate Tables into the BMM layer is by bringing them as Logical Table sources for the corresponding Fact table.
This is done by dragging and dropping the aggregate table into the corresponding fact table. After doing that establish the column mappings and the set the aggregation levels in the content tab of the LTS.
| Is This Answer Correct ? | 1 Yes | 0 No |
Can you use physical join in BMM layer?
What is connection pool and how many connection pools did you have in your last project?
What is time series wizard? When and how do you use it?
What is complex join, and where it is used?
If you have 2 fact and you want to do report on one with quarter level and the other with month level how do you do that with just one time dimension?
What are global filter and how they differ from column filter?
What is a table alias in obiee? And where and how will you create it.
What you will do when your report is not fetching right data?
What are the challenges you faced while making of reports?
What is clusterservices in obiee ? Why its used?
What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
How will you go about adding additional column to the repository in the presentation layer?