Obiee repository variable as column header we had a client with a business requirement to produce a columnar dataset with the column headers of a table for the measure to display the value of an essbase substitution variable which was being stored as a dynamic repository variable. How to update obiee 12c data sources when repository schema passwords are changed in the rcu database obiee 12c faq. To create a dynamic repository variable, perform the following steps. Then after some time, if the report is run again, some of the cell values start to show null where previously there were values present. Static repository variables dynamic repository variables static repository variables are defined in variable. When using microsoft active directory as the identity store and also using the virtualizetrue option as described in the bi security documentation, the patch for bug 20188679 must be. In addition to supporting regular session variables that are populated. Create a dynamic repository variable that obtains the latest time. Obiee repository contains all metadata of the bi server and is managed through the administration tool.
To keep things simple we will install both the database and obiee on a single machine. Presentation variable scope in obiee 11g oracle community. With the advent of 11g, you can now set a presentation. You can find an example of a dynamic essbase connection pool in this post of christian berg. Next part of this post will cover the repository creation.
How to install and configure obiee 12c peak indicators. Download and install oracle business intelligence 12c 12. Obiee where can i use a bi server variable session. Only in 10g, hosting multiple repositories on a single oracle bi server is not recommended for production systems. Download the obiee 11g versionfrom here or from oracle edelivery site and extract all the four disk into a single folder and click setup. This kind of variable can be initiate with the help of sql statement and can be use in the logical sql variables managed by the presentation service known as presentation variable. How to create a basic obiee 11g repository oracle bi 11g. Download the 10g sample sales data set on a server on which oracle bi 11g is installed. Syntax for repository variables in different places. In obiee, there are two types of variables that are commonly used. How to install oracle business intelligence enterprise. Sessionrepositorysession variablesa session variable is a variable that is. Repository variables can be used in place of constants in expression builder wizard.
Use repository variables instead of literals or constants in the administration tool expression builder. They persist in the memory when the bi server service is started and until its shutdown. Variables in the oracle bi server can be either repository or session variables, and are defined using the variable manager within the oracle bi administrator manage variables. There will be some differences if you are testing with. Session, repository and presentation variable in obiee 11g hindi urdu oracle buisness intellegnece tutorials 2020. This chapter describes how to use variables in the oracle bi repository to streamline administrative tasks and dynamically modify metadata content to adjust to a changing data environment. In 10g you can try as a workaround using more than 1 prompt. Obiee repository variables, filtering and conditional. Click manage variables to open the variable manager. Repository variables can be used in place of constants in expression.
The presentation service dashboard offers also a variable. Repository variables are defined using oracle bi administration tool. A repository variable has a single value at any point in time. When anyone uses this column in obiee, this is how it is referenced in the catalog. One of the most common uses of action links is to setup drilldowns to other bi content. Repository variable in obiee a repository variable is a variable that has a single value at any point in time. Obiee repository creation utility created required database schemas and tables required by obiee and web application server for example obiee scheduler tables. Unlike dynamic repository variables, however, the initialization of session variables is not scheduled. Values of repository variables are reset on a regularly scheduled basis, and cannot be changed by any user.
This brings up the variable manager, that divides variables out into repository and session variables, with a further subdivision into static and dynamic repository. At the end, there will be some references, but the idea here is to enable and guide the beginners in a smooth path to successfully install obiee, also this should be helpful as a quick guideline for experienced technician to consult some basic steps. Obiee 11g will introduce the ability to set presentation variables when using multi select prompts. Obiee how to set a server variable with the session type via a dashboard prompt with a request variable. Set up the tns for oracle client home in the path variable. Obiee obia onlineoffline training obiee 11g,obia 7963 contact info. It is used to store information about the application environment such as. Creating a repository using the oracle bi administration tool.
Session,repository and presentation variable in obiee 11g. Repository variables can be used instead of literals or constants in expression builders in the administration tool. Apart from this you can also define presentation and request variables. Repository variables repository variables the red cups are created and populated by the obiee administrator as part of the metadata repository. The difference is only that you dont need to create presentation variable, instead you will be using repository variable there. Business intelligence suite enterprise edition version 11. There are two types of variables that you can be created through rpd. At first i started with creating a dynamic repository variable which gave me the current datetime value in a customized format and i tried to call this variable in. Obiee dynamic session variables creating and using in an. Obiee common enterprise information model ceim the logical business model the threelayer metadata model obiee 11g biserverxmlexec rpd creation and patching in offline mode obiee 11g installation sample application version 825. Obiee 11g introduced several features in action frame work that makes it possible to link bi content to several other content types via action links.
Obiee 11g refresh repository variables failure as unable. In order to install obiee 11g you will need to download the files from oracle website. The oracle bi server substitutes the value of the repository. Initialization block repository variable not initialized obiee 11g 9864 jun 5, 2012 5. A repository variable has a single value at any point of time. Obiee building repository using initialization blocks and. In essence, a repository variable is the default value of a session variable. I would perform the following grep command that would spit out all reports including their path in the catalog that have that certain column or in your case, variable. Session variables and dynamic repository variables get their values from initialization blocks that can contain sql. Obiee repository can be accessed using the following path.
Dynamic column headers obiee 11g i have used presentation variable there, you can replace it with the repository variable. Im trying to understand the obiee repository and the relationship with the various repository variables and the filters in the obia dashboards. Obiee 10g11g repository rpd file gerardnico the data blog. Obiee 6 in todays competitive market, most successful companies respond quickly to market changes and opportunities. Repository variable when used in a dashboard prompts as a default selec. Obiee the difference between repository variable and.
When a user begins a session, the oracle bi server creates new instances of session variables and initializes them. This chapter describes how to use variables in the oracle bi repository to streamline. Presentation variable scope in obiee 11g ftisiot apr 19, 2017 1. Obiee 11g refresh repository variables failure as unable to acquire exclusive lock doc id 1959617. Using repository variables in conditional formatting in.
Note that oracle fusion middleware 12c requires oracle database 11g r211. Obiee all type of variables gerardnico the data blog. Obiee 12c default values from session variables in dashboard promptusing variables in obiee prompt 12c for default valuesql results from is subject area nameuse the syntax below for a session variable to be displayed in a dashboard prompt default value. Obiee building repository using initialization blocks and variables shad 16. In the repository the session variable in the administration tool. Since the data for analysis is based on argus mart schema and not the insight mart schema, the tns entry for the argus mart schema should be present in the obiee 11g home in the path. Obiee creating and using dynamic repository variable.
After jdk8 is installed export environment variables and add this to the profile if. Using variables in conditional formatting in obiee 11gyou can reference variables in several areas of oracle bi enterprise edition, including in analyses, dashboards, kpis, agents,filters and conditional formatting. Obiee 12c faq is it possible to upload a metadata repository rpd via em fusion middleware control. These hold values that apply to any user, for instance currency exchange rates. Much waited obiee 12c is released all new features, improvements. Session variables are similar to dynamic repository variables in that they obtain their values from initialization blocks. In 10g, the dashboard prompt is the only way to set a presentation variable. Multisource session variables in obiee11g rpd get values from multiple sources. Download the installation files using the below link. The presentation variable you can see their value and type in the session manager you can use them in bi presentation service, bi server and scheduler they are initialized with the help of an init block. The picture below show a repository variable call but you can use in the same way the session variable syntax. Metadata is maintained for the data model in a local proprietary file called the repository file rpd.
5 725 554 1415 1202 111 171 1153 1186 1334 1010 385 88 707 42 1519 150 1337 232 10 351 1248 814 821 288 877 408 78 1398 502 563 407