Do you know about Initialization Blocks? Can you give me an example where you used them?
Answer Posted / 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 |
Post New Answer View All Answers
What are global filter and how they differ from column filter?
You come morning to the office. And all the users are complaining about the obiee reporting system is very slow(dasboards). What is your approach to resolve the issue?
What are the key configuration files in obiee?
How online/offline mode impact development and delpoyment?
How the users created differs from rpd/answers/dashboards level?
How will you enable or disable caching in the system level and table level?
How will you execute direct sql in obiee?
What is time series wizard? When and how do you use it?
What is authentication? How many types of authentication.
How we are going to decide which schema we are going to implement in the data warehouse?
How will you port changes for dashboards,reports,rpd from development to production?
What is clusterservices in obiee ? Why its used?
How will change port of obiee answers?
How will you do sort in reports in obiee.
What are the different types of variables in obiee 11g? Explain