Do you know about Initialization Blocks? Can you give me an example where you used them?
Answer / madhu
Initialization blocks are used for instantiating the value of a variable.
To create dynamic variable you have to create IB to write SQL statement. The result of the query would be assigned as value to the variable.
| Is This Answer Correct ? | 3 Yes | 0 No |
What are the key configuration files in obiee?
We have 4 dimension tables, in that 2 tables need to have hierarchies then in such a case is it mandatory to create hierarchies for all the dimension tables?
What you will do when your report is not fetching right data?
How online/offline mode impact development and delpoyment?
Can you use physical join in BMM layer?
What is clusterservices in obiee ? Why its used?
What is a table alias in obiee? And where and how will you create it.
What are the different layers of obiee repository?
What is query repository tool?
What is a table alias in obiee 11g? Where and how will you create it?
Did you create any new logical column in BMM layer, how?
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?