Did you create any new logical column in BMM layer, how?
Answer / madhu
Yes. We can create new logical column in BMM layer.
Example: Right click on fact table> select new logical column>give name for new logical column like Total cost.
|Is This Answer Correct ?||0 Yes||0 No|
What is complex join, and where it is used?
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.
If you want to limit the users by the certain region to access only certain data, what would you do?
What is logging level? Where can you set logging levels?
If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no than what is the option? Why you won’t join fact to fact?
How do you define the relationship between facts and dimensions in BMM layer?
Suppose I have report which is running for about 3 minutes typically. What is the first step you take to improve the performance of the query?
Why do we have multiple LTS in BMM layer? What is the purpose?
If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?
Can you migrate the presentation layer to a different server.
What is data level security?
How do you work in a multi user environment? What are the steps?