How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
- 1 Answers
- 2070 Views
- I also Faced
- E-Mail Answers
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 |
How will you enable or disable caching in the system level and table level?
How do you split a table in the rpd given the condition. ( the condition given was Broker and customer in the same table) Split Broker and customer.
Did you create any new logical column in BMM layer, how?
What is object level security?
can you change the location of the obiee repository?
What is scd type 1 and 2.
Can you have multiple data sources in OBIEE?
What is the purpose of Alias Tables?
If you want to create new logical column where will you create (in repository or dashboard) why?
From where u get the logical query of your request?
Can you use outer join in BMM layer?
How will you go about adding additional column to the repository in the presentation layer?
Teradata 
