A repository variable has a single value at any point in time. These variables also called as Oracle BI Server variables. Repository variable values will be updated whenever server is restarted or started and based on schedule. Syntax VALUEOF(Variablename)
Repository variables are 2 types.
Static Repository Variables:
1. If you want to use a constant value in ‘n’ no. of places then we will go for static
1. These variables will be associated with initialization block.
Scenario: Handling partitions & fragmentation content condition dynamically.
i. Static.
ii. Dynamic.
Eg: Database name, username of connection pools
2. A SQL query is called as initialization block.
3. These initialization blocks will be executed with oracle BI server refresh and
based on the schedule of initialization block.
4. Schedule option is available only for dynamic repository variable initialization
blocks.
No comments:
Post a Comment