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 |
How do you define the relationship between facts and dimensions in BMM layer?
What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
What is level based metrics.how will you create it?
Define pipeline. Did you use it in your projects?
What is a table alias in obiee 11g? Where and how will you create it?
What is data level security?
What is connection pool and how many connection pools did you have in your last project?
How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
what is guided navigation?
What is query repository tool?
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 the different types of variables in obiee? Explain