![how to use presentation variable in bi publisher Logo](https://www.clearpeaks.com/wp-content/uploads/2023/07/synvert-logo-web.png)
![](http://charunivedita.online/777/templates/cheerup2/res/banner1.gif)
14 Jul 2021 Navigating from OAC to BI Publisher with Parameters
Here at ClearPeaks , we are always trying to understand how tools work so that we can squeeze the best out of them to meet our customers’ needs. In this article we’re going to explain how to set up an action link from an OAC to a BI Publisher report with the special particularity of passing a set of parameters, including a date filter. Even though this article deals with OAC, the method can also be applied to OBIEE or OAS.
Our starting point is an OAC dashboard that depicts the hiring cost by gender and nationality for a specific date range:
![how to use presentation variable in bi publisher Hire Cost Analysis dashboard](https://www.clearpeaks.com/wp-content/uploads/2021/07/Figure-1-Hire-Cost-Analysis-dashboard-e1626182018938.png)
Figure 1: Hire Cost Analysis dashboard
When clicking on the Cost To Hire amount for any row, a navigation to BI Publisher is set in order to display the disaggregation of the hiring cost. In this case, the cost for French females will be broken down:
![how to use presentation variable in bi publisher Cost to Hire dashboard – French females.](https://www.clearpeaks.com/wp-content/uploads/2021/07/Figure-2-Cost-to-hire-dashboard-–-French-females.png)
Figure 2: Cost to Hire dashboard – French females
![how to use presentation variable in bi publisher BI Publisher – Hiring Cost Details Report](https://www.clearpeaks.com/wp-content/uploads/2021/07/Figure-3-BI-Publisher-–-Hiring-Cost-Details-report-1.png)
Figure 3: BI Publisher – Hiring Cost Details Report
How can we pass dates that are not even shown from a report through a navigation? This will be explained in the article, with the implementation process divided into several steps:
STEP 1: Create your OAC Report
In this case, the report granularity might need aggregated data, so a drilldown to BI Publisher makes sense. Since the report is filtered by a dashboard prompt, it needs a date filter as prompted:
![how to use presentation variable in bi publisher OAC report – Date filter](https://www.clearpeaks.com/wp-content/uploads/2021/07/Figure-4-OAC-report-–-Date-filter.png)
Figure 4: OAC report – Date filter
STEP 2: Create your BI Publisher Report
To create a BI Publisher report, you need to create a data model first, and then the report where the layout is defined. In this case, the query and the report parameters will be defined in the data model.
It is very important to set proper names to the parameters and use them in the query.
![how to use presentation variable in bi publisher BI Publisher Report – Parameter definitions](https://www.clearpeaks.com/wp-content/uploads/2021/07/Figure-5-BI-Publisher-report-–-Parameters-definition.png)
Figure 5: BI Publisher Report – Parameter definitions
![how to use presentation variable in bi publisher BI Publisher Report – Query filters using parameters](https://www.clearpeaks.com/wp-content/uploads/2021/07/Figure-6-BI-Publisher-report-–-Query-filters-using-parameters.png)
Figure 6: BI Publisher Report – Query filters using parameters
STEP 3: Create an Action Link Between OAC and BI Publisher
You can learn how to guide user navigation in OAC dashboards and analysis using action links. An action link will allow users to access external web content in the context of your BI analysis, to use conditions and agents to automate the initiation of business processes, or to invoke a Web Service.
To set up an action link, go to your OAC report and click on the column properties of the field that you want to use to navigate. In our example, Cost To Hire will be the selected column to navigate to BI Publisher.
![how to use presentation variable in bi publisher : Set up an action link – Column properties](https://www.clearpeaks.com/wp-content/uploads/2021/07/Figure-7-Set-up-action-link-–-column-properties.png)
Figure 7: Set up an action link – Column properties
![how to use presentation variable in bi publisher Set up an action link – Interaction tab](https://www.clearpeaks.com/wp-content/uploads/2021/07/Figure-8-Set-up-action-link-–-interaction-tab.png)
Figure 8: Set up an action link – Interaction tab
![how to use presentation variable in bi publisher Set up action link – create action link – Navigate to a Web Page](https://www.clearpeaks.com/wp-content/uploads/2021/07/Figure-9-Set-up-action-link-–-create-action-link-–-Navigate-to-a-Web-Page-1.png)
Figure 9: Set up an action link – Create action link – Navigate to a Web Page
The type of action link is crucial to determining the navigation possibilities. In this case, since BI Publisher has a different URL from OAC, it is important to set the action link as Navigate to a Web Page .
The first URL to enter is from BI Publisher, so navigate to your BI Publisher report and click on the settings icon to get the URL:
![how to use presentation variable in bi publisher Set up an action link – Get BI Publisher URL](https://www.clearpeaks.com/wp-content/uploads/2021/07/Figure-10-Set-up-action-link-–-get-BI-Publisher-URL.png)
Figure 10: Set up an action link – Get BI Publisher URL
In our example, the URL is:
https://url_to_oac/ui/analytics/saw.dll?bipublisherEntry&Action=open&itemType=.xdo&bipPath=%2FBIP%2FHiring%20Cost%20Details% 20Report.xdo&bipParams{“_xmode”:”2″,”_sTkn”:”242d733617993ae0f2b”,”_xiasynch”:””, “_xpf”:””,”_xpt”:”0″,”_dFlag”:”false”,”_edIndex”:”0″,”_dIndex”:”0″,”_rToken”:””, “_ranDiag”:”false”,”_xdo”:”%2FBIP%2FHiring%20Cost%20Details%20Report.xdo”, “_paramspSTART_DATE”:””,”_paramspEND_DATE”:””,”_paramspNATIONALITY”:””, “_paramspGENDER”:””,”_xt”:”Hiring%20Cost%20Details%20Report”,”_xf”:”analyze”, “_xana”:”view”}&_linkToReport=true
Enter the URL in the text box shown below, prompted after setting the action link as a Navigate to a Web Page (Figure 9):
![how to use presentation variable in bi publisher Set up an action link – Enter the BI Publisher URL here](https://www.clearpeaks.com/wp-content/uploads/2021/07/Figure-11-Set-up-action-link-–-place-BI-Publisher-URL-here.png)
Figure 11: Set up an action link – Enter the BI Publisher URL here
Click on OK to complete.
STEP 4: Define Date Columns to Pass Through Navigation
This step is often the key to making this navigation work, considering the difficulty of passing the filter set to BI Publisher by the dashboard prompt, and how to split that date range into 2 different values to filter the SQL explained in step 2.
First, let’s see what value is returned by the dashboard prompt: to do so, assign a presentation variable to the date prompt and use it in the OAC report to visualise the format. Navigate to OAC and edit the dashboard prompt:
![how to use presentation variable in bi publisher Edit dashboard prompt](https://www.clearpeaks.com/wp-content/uploads/2021/07/Figure-12-Edit-dashboard-prompt-1024x359.png)
Figure 12: Edit dashboard prompt
![how to use presentation variable in bi publisher Set up a Presentation Variable](https://www.clearpeaks.com/wp-content/uploads/2021/07/Figure-13-Set-up-a-presentation-variable.png)
Figure 13: Set up a Presentation Variable
Once the presentation variable has been set, add it to the report:
![how to use presentation variable in bi publisher Include the presentation variable to the report](https://www.clearpeaks.com/wp-content/uploads/2021/07/Figure-14-Include-the-presentation-variable-to-the-report.png)
Figure 14: Add the Presentation Variable to the report
![how to use presentation variable in bi publisher Presentation Variable to OAC report](https://www.clearpeaks.com/wp-content/uploads/2021/07/Figure-15-Presentation-variable-to-OAC-report.png)
Figure 15: Presentation Variable to OAC report
Remember to add single quotes once the presentation variable has been added to the report:
![how to use presentation variable in bi publisher Presentation Variable syntax](https://www.clearpeaks.com/wp-content/uploads/2021/07/Figure-16-Presentation-variable-syntax.png)
Figure 16: Presentation Variable syntax
Once added, we can see its value from a dashboard perspective:
![how to use presentation variable in bi publisher Presentation Variable Date format when displayed in the OAC dashboard](https://www.clearpeaks.com/wp-content/uploads/2021/07/Figure-17-Presentation-Variable-Date-format-when-displayed-in-the-OAC-dashboard.png)
Figure 17: Presentation Variable date format when displayed in OAC dashboard
As can be observed in Figure 17, the value shown in the dashboard is a string concatenation of the 2 dates selected in the prompt with a comma as a separator, so the idea is to apply string functions to extract both dates, the initial and the final.
For the former, apply the following formula:
CAST(to_datetime(SUBSTRING(‘@{PV_HIRE_DATE}’ FROM 0 FOR LENGTH(‘@{PV_HIRE_DATE}’) – LOCATE(‘,’,’@{PV_HIRE_DATE}’)) ,’YYYY-MM-DD’) AS DATE)
And for the latter:
CAST(to_datetime(SUBSTRING(‘@{PV_HIRE_DATE}’ FROM LOCATE(‘,’,’@{PV_HIRE_DATE}’)+1 FOR LENGTH(‘@{PV_HIRE_DATE}’) – LOCATE(‘,’,’@{PV_HIRE_DATE}’)+1),’YYYY-MM-DD’) AS DATE)
Bear in mind that both fields need to be casted to date as we want to pass these fields as date fields. In addition, as they are not relevant to the dashboard itself, they will be hidden from the OAC table. It is crucial not to hide the fields from the Criteria tab (column properties); go to the editing options and hide the fields from there.
![how to use presentation variable in bi publisher Hide unused fields in OAC table](https://www.clearpeaks.com/wp-content/uploads/2021/07/Figure-18-Hide-unused-fields-in-OAC-table.png)
Figure 18: Hide unused fields in OAC table
STEP 5: Parametrise the Action Link
Go back to the OAC report, click on Cost To Hire column properties and edit the action link as described in step 3.
![how to use presentation variable in bi publisher Edit the action link to include parameters](https://www.clearpeaks.com/wp-content/uploads/2021/07/Figure-19-Edit-the-action-link-to-include-parameters-1024x338.png)
Figure 19: Edit the action link to include parameters
Click on Define Parameters and the following window will appear:
![how to use presentation variable in bi publisher Defining parameters to use in the navigation](https://www.clearpeaks.com/wp-content/uploads/2021/07/Figure-20-Defining-parameters-to-use-in-the-navigation-1024x524.png)
Figure 20: Define parameters to use in the navigation
Now it’s time to parametrise the different variables that will be passed to BI Publisher. The first thing to note is that all parameters need to be hidden in order to avoid another window prompt once the user starts navigating.
The first 3 parameters will be kept by default, but the rest will be removed. Based on the image below, the following 4 parameters will be created:
![how to use presentation variable in bi publisher Set up parameters](https://www.clearpeaks.com/wp-content/uploads/2021/07/Figure-21-Set-up-parameters-1024x515.png)
Figure 21: Set up parameters
The key here is that the date filters have been included in the report in step 4 and so we can now select them.
The different options when defining a parameter are shown below:
![how to use presentation variable in bi publisher Options to set up a parameter in an action link](https://www.clearpeaks.com/wp-content/uploads/2021/07/Figure-22-Options-to-set-up-a-parameter-in-an-action-link.png)
Figure 22: Options to set up a parameter in an action link
By and large, Value will be used to filter a specific value like ‘Female’, and Column Value will be selected to filter the clicked value in the OAC report.
In our example, the user is not required to select any variable in the target BI Publisher report, so the number of parameters to be included in the navigation should match the number of parameters set in the BI Publisher.
Finally, once all the parameters have been set correctly, the URL needs to be modified according to the following logic:
https://url_to_oac/analytics/saw.dll?bipublisherEntry&Action=@{1}&itemType=@{2}&bipPath=@{3}&bipParams={“_xmode”:”2″,”_sTkn”:”78416170177d3ff717b”,”_xiasynch”:””,”_xpf”:””,”_xpt”:”0″, “_dFlag”:”false”,”_edIndex”:”0″,”_dIndex”:”0″,”_rToken”:””,”_ranDiag”:”false”, “_xdo”:”/BIP/Hiring Cost Details Report.xdo”,” _paramspSTART_DATE”:”@{4}”,”_paramspEND_DATE”:”@{5}”,”_paramspGENDER”: “@{6}”,”_paramspNATIONALITY”:”@{7} “,”_xf”:”analyze”,”_xana”:”view”}
As you can see, the number headed by ‘ @ ’ corresponds to the Name column in Figure 21.
STEP 6: Double-check your Navigation
Everything should work now, but since managing dates can be challenging sometimes, it is very important that we ensure that the date format matches the source field format in the database. In this case, since the date format in the OAC report is YYYY-MM-DD and the one required for the database is MM/DD/YYYY, the format of the date parameters in the BI Publisher data model needs to be changed.
![how to use presentation variable in bi publisher Specifying the date format to match with the database one](https://www.clearpeaks.com/wp-content/uploads/2021/07/Figure-23-Specifying-the-date-format-to-match-with-the-database-one-1024x615.png)
Figure 23: Specify the date format to match the database
Now you can have a go!
In this article we have customised a navigation from an OAC report to a BI Publisher report and filtered the target report properly.
ClearPeaks are experts in Oracle technologies, always up-to-date with market trends and the latest features. If you believe our expertise can be of use to you, please contact us – we’ll be happy to help!
![how to use presentation variable in bi publisher](https://www.clearpeaks.com/wp-content/uploads/2020/05/Article-Banner-Enterprise-BI.png)
- Essential Cookies
- Analytics Cookies
- Additional Cookies
- Cookie Policy
This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
You can adjust your preferences below.
We use these cookies to ensure that our website works correctly and meet your expectations. They cannot be switched off. You can find out more in our privacy policy and cookie policy.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.
This website uses Google Analytics to collect anonymous information such as the number of visitors to the site and the most popular pages. Keeping these cookies enabled helps us to improve our website and give you a great experience.
Please enable Strictly Necessary Cookies first so that we can save your preferences!
This website uses the following additional cookies:
More information about our Cookie Policy
![how to use presentation variable in bi publisher Oracle Documentation](https://www.oracle.com/./img/oracle_doc_logo.png)
Adding Parameters to a Data Model in Oracle Business Intelligence Publisher
Before you begin.
This 15-minute tutorial shows you how to add parameters to a data model and test the parameters.
Using parameters in a data model enables filtering the source data. The filtered data is used in reports.
In this tutorial, use the Demo data available in the Oracle Business Intelligence installation directory. You create a data set of products, and then use the text and menu type parameters to filter the product list based on the price limit and the supplier.
What Do You Need?
- Access to Oracle Business Intelligence Publisher as a BI Content Author
- Access to samples and demo data source installed and configured in the ${xdo.server.config.dir}/repository/DemoFiles directory when you installed Oracle Business Intelligence Publisher
Create a Data Model
In this section, create a data model, develop a SQL query against the Products table, and then create a data set in the data model.
- Sign in to Oracle Business Intelligence Publisher with your credentials.
- On the Home page, click New, and then select Data Model.
![how to use presentation variable in bi publisher New Data Set icon](https://www.oracle.com/img/func_plus_16_ena.png)
- In the New Data Set - SQL Query dialog box, enter Product_Supplier_Price in the Name field, select demo from the Data Source list, and then select Standard SQL from the Type of SQL list.
- Click Query Builder.
- In Query Builder, select OE from the Schema list, and then select PRODUCTS.
- From Products, select the PRODUCT_ID, PRODUCT_NAME, SUPPLIER_ID, LIST_PRICE columns, and then click Save.
![how to use presentation variable in bi publisher query builder](https://www.oracle.com/./img/bip_ds_query_builder.png)
- In the New Data Set - SQL Query dialog box, view the SQL query you built in the Query Builder dialog box, and then click OK.
![how to use presentation variable in bi publisher SQL query](https://www.oracle.com/./img/bip_ds_sql_query.png)
- In the Save As dialog box, from the Catalog pane, select My Folders, enter Product_dm as the data model name, and then click Save.
Add Parameters to the Data Model
In this section, add a text type parameter and a menu type parameter to the data model. Use a list of values (LOV) for the menu type parameter.
![how to use presentation variable in bi publisher Create new List of Values icon](https://www.oracle.com/img/func_plus_16_ena.png)
- Name: Supplier_Lov
- Type: SQL Query
- Data Source: demo
- SQL Query: Select supplier_id from products
![how to use presentation variable in bi publisher list of value](https://www.oracle.com/./img/bip_ds_supplier_lov.png)
- Name: P_SupplierID
- Data Type: String
- Default Value: 102059
- Parameter Type: Menu
- Display Label: Select a Supplier ID
- List of Values: Supplier_Lov
- Number of Values to Display in List: 20
![how to use presentation variable in bi publisher menu type parameter](https://www.oracle.com/./img/bip_ds_supplier_id_param.png)
- Name: P_PriceLimit
- Data Type: Integer
- Default Value: 223
- Parameter Type: Text
- Display Label: Price Limit
- Text Field Size: 6
![how to use presentation variable in bi publisher text type parameter](https://www.oracle.com/./img/bip_ds_price_limit_param.png)
Test the Parameters in the Data Model
In this section, test the parameters in the data model.
- In the Product_dm data model, click View Data.
- In the Data tab, click View, and then click Table View.
![how to use presentation variable in bi publisher view report](https://www.oracle.com/./img/bip_dm_view.png)
![](http://charunivedita.online/777/templates/cheerup2/res/banner1.gif)
Want to Learn More?
- Creating Data Sets
- Adding Parameters and Lists of Values
Working with Session Variables
Learn about session variables and how to create them.
This section provides information about working with session variables, and contains the following topics:
About Session Variables
Creating session variables.
Session variables obtain their values from initialization blocks.
Unlike dynamic repository variables, however, the initialization of session variables is not scheduled. When a user begins a session, the Oracle BI Server creates new instances of session variables and initializes them.
Unlike a repository variable, there are as many instances of a session variable as there are active sessions on the Oracle BI Server . Each instance of a session variable could be initialized to a different value.
Session variables are primarily used when authenticating users against external sources such as database tables or LDAP servers. If a user is authenticated successfully, session variables can be used to set filters and permissions for that session. For information about using session variables when setting up security, see Managing Session Variables in Security Guide for Oracle Business Intelligence Enterprise Edition .
This section contains the following topics:
About System Session Variables
About Nonsystem Session Variable
System session variables are used by the Oracle BI Server and Oracle BI PresentationServices use for specific purposes.
System session variables have reserved names that cannot be used for other kinds of variables such as static or dynamic repository variables and nonsystem session variables.
When you use these variables for Oracle BI Presentation Services , preface their names with NQ_SESSION . For example, to filter a column on the value of the variable LOGLEVEL , set the filter to the variable NQ_SESSION.LOGLEVEL .
The table describes the available system session variables.
Variable | Description |
---|---|
USER | Holds the value the user enters. The value always matches the variable, that is the act as value. When the user logs in to act as some other user, the value of the session variable matches the the user is acting as. |
USERGUID | Contains the global unique identifier (GUID) of the user, typically populated from the LDAP profile of the user. |
GROUP | Contains the groups to which the user belongs. Exists only for compatibility with previous releases. Legacy groups are mapped to application roles automatically. When a user belongs to multiple groups, include the group names in the same column, separated by semicolons (for example, GroupA;GroupB;GroupC). If a semicolon must be included as part of a group name, precede the semicolon with a backslash character (\). |
ROLES | Contains the application roles to which the user belongs. When a user belongs to multiple roles, include the role names in the same column, separated by semicolons,for example, RoleA;RoleB;RoleC. If a semicolon must be included as part of a role name, precede the semicolon with a backslash character (\). |
ROLEGUIDS | Contains the global unique identifiers (GUIDs) for the application roles to which the user belongs. GUIDs for application roles are the same as the application role names. |
PERMISSIONS | Contains the permissions held by the user, such as oracle.bi.server.manageRepositories. |
PROXY | Holds the name of the proxy user. A proxy user is a user that has been authorized to act for another user. See for more information about the PROXY system session variable. |
DISPLAYNAME | Used for Oracle BI Server. It contains the name that is displayed to the user in the greeting in the Oracle BI Presentation Services user interface. It is also saved as the author field for catalog objects. This variable is typically populated from the LDAP profile of the user. |
LOGLEVEL | The value of , a number between 0 and 5, determines the logging level that the Oracle BI Server uses for user queries. This system session variable overrides a variable defined in the Users object in the Administration Tool. If the administrator user (defined upon install) has a Logging level defined as 4 and the session variable defined in the repository has a value of 0 (zero), the value of 0 applies. |
DESCRIPTION | Contains a description of the user, typically populated from the LDAP profile of the user. |
USERLOCALE | Contains the locale of the user, typically populated from the LDAP profile of the user. |
DISABLE_CACHE_HIT | Used to enable or disable Oracle BI Server result cache hits. This variable has a possible value of 0 or 1. |
DISABLE_CACHE_SEED | Used to enable or disable Oracle BI Server result cache seeding. This variable has a possible value of 0 or 1. |
DISABLE_SUBREQUEST_CACHE | Used to enable or disable Oracle BI Server subrequest cache hits and seeding. This variable has a possible value of 0 or 1. |
SELECT_PHYSICAL | Identifies the query as a SELECT_PHYSICAL query. See <<Syntax and Usage Notes for SELECT_PHYSICAL- link to SQL Ref>> for more information. |
DISABLE_PLAN_CACHE_HIT | Used to enable or disable Oracle BI Server plan cache hits. This variable has a possible value of 0 or 1. |
DISABLE_PLAN_CACHE_SEED | Used to enable or disable Oracle BI Server plan cache seeding. This variable has a possible value of 0 or 1. |
TIMEZONE | Contains the time zone of the user, typically populated from the LDAP profile of the user. |
WEBLANGUAGE | Used for Oracle BI Presentation Services. Holds the Oracle BI Presentation Services user interface display language. Users can select a language on the sign-in page for Oracle BI EE, or they can change the language setting on the Preferences tab of the My Account dialog after signing in. |
AUTHINITBLOCKONLY | Determines if the initialization blocks required for authentication are executed. This variable has a value of Yes. The value is case-insensitive. |
PORTALPATH | Used for Oracle BI Server. It identifies the default dashboard the user sees when logging in (the user can override this preference after logged on). |
REQUESTKEY | Used for Oracle BI Presentation Services. Any users with the same nonblank request key share the same Oracle BI Presentation Services cache entries. This tells Oracle BI Presentation Services that these users have identical content filters and security in the Oracle BI Presentation Services. Sharing Oracle BI Presentation Services cache entries is a way to minimize unnecessary communication with the Oracle BI Presentation Services. |
SKIN | Determines certain elements of the look and feel of the Oracle BI Presentation Services user interface. The user can alter some elements of the user interface by picking a style when logged on to Oracle BI Presentation Services. The variable points to an Oracle BI Presentation Services folder that contains the nonalterable elements, for example, figures such as GIF files. Such directories begin with sk_. For example, if a folder were called sk_companyx, the variable would be set to companyx. |
About Nonsystem Session Variables
You use the same procedure to define nonsystem session variables as for system session variables.
A common use for nonsystem session variables is setting user filters. For example, you could define a nonsystem variable called SalesRegion that would be initialized to the name of the sales region of the user.
You could then set a security filter for all members of a group that would allow them to view only data pertinent to their region.
When you use these variables for Oracle BI Server , preface their names with NQ_SESSION . For example, to filter a column on the value of the variable SalesRegion , set the filter to the variable NQ_SESSION.SalesRegion .
Learn how to create session variables.
To create a session variable:
- In the Administration Tool , select Manage , then select Variables .
- In the Variable Manager dialog, select Action > New > Session > Variable .
Names for all variables should be unique. The names of system session variables are reserved and cannot be used for other types of variables.
Enable any user to set the value. Select this option to set session variables after the initialization block has populated the value (at user login) by calling the ODBC stored procedure NQSSetSessionValue() . For example, this option lets non-administrators to set this variable for sampling.
Note that the NQSSetSessionValues() stored procedure is not supported for use through the Issue SQL page in Oracle BI Presentation Services Administration.
If this option is not selected, then the variable cannot be set.
Security Sensitive. Select this option to identify the variable as sensitive to security when using a row-level database security strategy, such as a Virtual Private Database (VPD). When filtering cache table matches, the looks at the parent database object of each column or table that is referenced in the logical request projection list. If the database object has the Virtual Private Database option selected, the Oracle BI Server matches a list of security-sensitive variables to each prospective cache hit. Cache hits would only occur on cache entries that included and matched all security-sensitive variables.
To create a new initialization block, click New . See Creating Initialization Blocks for more information.
- To add a Default Initializer value, type the value in the Default Initializer box, or click the Expression Builder button to use Expression Builder.
Scripting on this page enhances content navigation, but does not change the content in any way.
- Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers
- Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand
- OverflowAI GenAI features for Teams
- OverflowAPI Train & fine-tune LLMs
- Labs The future of collective knowledge sharing
- About the company Visit the blog
Collectives™ on Stack Overflow
Find centralized, trusted content and collaborate around the technologies you use most.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Get early access and see previews of new features.
How to display BI Publisher multi-select parameter items in a bi publisher report
I have a requirement to display the items chosen in a multi select parameter in a bi publisher report. My Data Model's sample data does include the chosen parameter values but I only see the first item selected after placing the parameter in the bi pub report layout and then viewing the report (this includes when I place the parameter in a list object). How do I display in my report all of the items that were selected in my multi-select parameter?
- bi-publisher
- Please provide the sample XML. You'll probably use <?for-each:?> to loop multiple nodes. – DaveStSomeWhere Commented May 12, 2017 at 4:07
- Unfortunately, I have been asked to not include the sample XML due to the sensitive nature of our data. As noted I am new to BI Publisher; please provide an example of how we could use <?for-each:?> to display all items of a multi-select parameter. – dman6750 Commented May 12, 2017 at 18:18
- 1 You could always sanitize your example XML showing the basic element relationships and key attributes - this would make it easier using your example. I'll put an answer below with a generic <?for-each:?> example if that would be helpful (too much to put into a comment). Providing the input and desired output is necessary to get a useful answer. – DaveStSomeWhere Commented May 12, 2017 at 19:25
- Agree with @DaveCoast, please provide more details. What are the parameters of the concurrent request (and how would they look when the user enters them?), what does your XML look like (at the very least the parameter section), what do you want the output to look like? – EdHayes3 Commented May 11, 2018 at 20:30
Know someone who can answer? Share a link to this question via email , Twitter , or Facebook .
Your answer.
Reminder: Answers generated by artificial intelligence tools are not allowed on Stack Overflow. Learn more
Sign up or log in
Post as a guest.
Required, but never shown
By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy .
Browse other questions tagged bi-publisher or ask your own question .
- The Overflow Blog
- Where does Postgres fit in a world of GenAI and vector databases?
- Featured on Meta
- We've made changes to our Terms of Service & Privacy Policy - July 2024
- Bringing clarity to status tag usage on meta sites
- Feedback requested: How do you use tag hover descriptions for curating and do...
- What does a new user need in a homepage experience on Stack Overflow?
- Staging Ground Reviewer Motivation
Hot Network Questions
- How to assess whether it is imposter syndrome or actual low quality work during Ph.D.?
- Get WEBP via FFmpeg/thumbnails utility
- Why are AAVs not a replacement for through-roof vent pipe?
- Sci-fi short story about a dystopian future where all natural resources had been used up and people were struggling to survive
- What is the name of the book about a boy dressed in layers of clothes who is actually a mouse?
- How do I alter a table by using AFTER in hook update?
- My enemy sent me this puzzle!
- What is the difference between using a resistor or a capacitor as current limiter?
- Which battery clamp is positive?
- How to allocate memory in NASM without C functions (x64)?
- What are the risks of a compromised top tube and of attempts to repair it?
- What is the significance of bringing the door to Nippur in the Epic of Gilgamesh?
- Are quantum states like the W, Bell, GHZ, and Dicke state actually used in quantum computing research?
- Submitting a paper as a nonacademic practitioner in a field
- My collegeagues and I are travelling to UK as delegates in an event and the company is paying for all our travel expenses. what documents are required
- 24.04 Ubuntu crashes periodiocally, screen, keyboard and mouse freeze
- Why do National Geographic and Discovery Channel broadcast fake or pseudoscientific programs?
- Purpose of burn permit?
- Why does my PC take a long time to start, then when it's at the login screen it jumps to the desktop instantly?
- How are notes named in Japan?
- What issues are there with my perspective on truth?
- Can a 2-sphere be squashed flat?
- A string view over a Java String
- Where did Geordi's eyes go?
- Install App
Analytics Software
For appeals, questions and feedback about Oracle Forums, please email [email protected] . Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
Oracle has updated its online Terms of Use and Community Guidelines and introduced a Community Integrity Policy . These changes document Community specific rules and Oracle’s content moderation practices including use of automated tools, appeals process, and Oracle’s contact details. If you object to any changes, you may request that your account be closed by contacting [email protected] . Your continued use of Oracle Communities means that you are consenting to the updated terms.
Variable in BI publisher
![how to use presentation variable in bi publisher](https://objectstorage.us-phoenix-1.oraclecloud.com/p/usZakwxzsyewMRwrzramy7IpDhL0NnhNKqIsS4oCJQZlZGXvq0UNqBQXLk6rcQI4/n/axciphqpnohg/b/forums-prod-app/o/300000/static/images/default-user-avatar.png)
![](http://charunivedita.online/777/templates/cheerup2/res/banner1.gif)
IMAGES
COMMENTS
For this purpose I created repository variable that gets this working day. When I checked this variable in OBIEE it worked fine. However, in BIP, I couldn't use that variable to set default value of the date parameter.
To add a BI Publisher property to a template, use the Microsoft Word Properties dialog (available from the File menu), and enter the following information: Name - Enter the BI Publisher property name prefixed with "xdo-". Type - Select "Text". Value - Enter the property value.
Hello: Is it possible to use the presentation variable in BI Publisher reports? I am aware of one way, which worked; which is by addding a BI publisher section in Dashboard and adding that BI Publisher report.This BI Publisher report is based on BI answers request. Now, my question is, if there is a column with ( fx = filter (measure using col ...
Hi, I have created a BIPUB Report on a Answers request which has a column filter using the presentation Variable. I created a dashboard with the prompt and anwers request and the publisher report. The data in the request output is restricted using the Presentation Variable ,but in the Publisher report it is not effecting. Can i know how can use presentation Variable in the Publisher report ...
I have a publisher 11g (v 11.1.1.7) report with a single parameter. The report is based on a data model not a subject area. I created a dashboard put a dashboard prompt and link to the report in separate section on the same page. The dashboard prompt sets a presentation variable named the same as the parameter in the report.
Hi Everyone, I had a requirement like, > BI Analysis as a datasource in BI Publisher. > I need to show a prompt in bi publisher for fiscal year(let us assume) For that waht i had done was, >...
The article titles are exactly what I want to do but the details are the opposite. It does not explain how I copy a variable from dashboard to BIP report. I just want to take a session variable (current user) and copy it to BIP report.
Figure 6: BI Publisher Report - Query filters using parameters . ... First, let's see what value is returned by the dashboard prompt: to do so, assign a presentation variable to the date prompt and use it in the OAC report to visualise the format. Navigate to OAC and edit the dashboard prompt:
In the Variable Manager dialog, select Action > New > Repository > Variable. In the Variable dialog, type a name for the variable. Names for all variables should be unique. The names of system session variables are reserved and cannot be used for other types of variables. Select the type of variable: Static or Dynamic.
To add a property to a template, use the Microsoft Word Properties dialog (available from the File menu), and enter the following information: Value - Enter the property value. To reference an element from the incoming XML data, enter the path to the XML element enclosed by curly braces. For example: {/root/password}
Select the BI Publisher > Preview Template > PDF option from the menu to preview the data in the report using this template. 14. Select the BI publisher> Publish Template As option to publish the template for this report. Enter Template1 (or any other appropriate name) as the template name, and click OK.
Example. LEAST (1,3,5) returns 1. LEAST (1,null,7) returns null. LEAST (null) returns null. As per the Parameter definition NULL will be passed if ALL value selected in the prompt. So in this case when ALL selected ,condition LEAST (:P_NUM) IS NULL becomes true and acts like 1=1 ,so all rows can be fetched.
I would like to show this variable in the body of my Publisher report. Can anybody help? Let me be a little more specific. I created an RTF Template based off of an obi Answer request. now i have created a dashboard propmpt for date and saved this to a presentation variable. i would like to write this date to the body of the report.
Add Parameters to the Data Model. In this section, add a text type parameter and a menu type parameter to the data model. Use a list of values (LOV) for the menu type parameter. In the Product_dm data model, click List of Values, click Create new List of Values , and then enter the following values: Name: Supplier_Lov. Type: SQL Query.
Learn how to create session variables. To create a session variable: In the Administration Tool, select Manage, then select Variables. In the Variable Manager dialog, select Action > New > Session > Variable. In the Session Variable dialog, type a variable name. Names for all variables should be unique.
Currently I am using 11.1.1.5v and in 11g, we have the ability to hold multiple values for presentation variable. Can anyone let me know whether we can pass these multiple values thru variable to BI publisher parameter? Thanks
About Press Copyright Contact us Creators Advertise Developers Terms Privacy Policy & Safety How YouTube works Test new features NFL Sunday Ticket Press Copyright ...
Presentation Variables Presentation Variables are created by, and exist only in the context of, a Dashboard Prompt. The values of Presentation variables may be used as filtering conditions for any analyses on the dashboard(s) on which the dashboard prompt is present. The use of a dashboard prompt is the only way to create a presentation variable.
Steps: 1. Create dashboard column prompt with a date column and define a presentation variable with a name. You can use any default value if required as it is optional. Example: OTBI column: "Time"."Calendar Date". Presentation Variable Name: P_Date. 2. Create a BIP data model with following details. Parameter Name with Text type: same as ...
I have a requirement to display the items chosen in a multi select parameter in a bi publisher report. My Data Model's sample data does include the chosen parameter values but I only see the first item selected after placing the parameter in the bi pub report layout and then viewing the report (this includes when I place the parameter in a list object).
These changes document Community specific rules and Oracle's content moderation practices including use of automated tools, appeals process, and Oracle's contact details. If you object to any changes, you may request that your account be closed by contacting [email protected]. Your continued use of Oracle Communities ...