[轉]Updating Session Variables from Dashboards using Presentation Variables
Oracle BI EE 10.1.3.3/2 – Updating Session Variables from Dashboards using Presentation Variables
This question keeps repeating so many times that i thought this in itself deserves a seperate blog entry. There are 2 parts to this question. They are
1. Updating Session Variables from Answers
2. Updating Session Variables using Presentation Variables from a Dashboard
Prompt
The first one is pretty straightforward. Lets start with a simple example. Lets create a simple session variable called Test_Var and make that variable to be initialized from an init block. Enable that variable to be set by any user. If you are using row-wise initialization then by default the variable will allow any user to set the variable.
Now, go to Answers and create a report which will show the Session Variable.
Now, as you see the session variable has a value of Test. Now, in order to update this variable, go to the Advanced Tab->Advanced SQL Clauses in Answers. And enter the below formula in the Prefix section (Do not click on Set SQL. This is executed when you move away from this tab)
SET VARIABLE Test_Var=’Test1′;
Now, also ensure that you are bypassing Presentation Services Cache.
If you go to the Results tab, you should notice that your Session Variable Value would have changed.
This has a lot of use cases. For example, you can set LOGLEVEL variable dynamically for every report. I shall also be blogging about other possible use cases later this week. This was pretty straightforward. But what if we want to set these variables from a dashboard prompt. In order to do this, lets create a simple dashboard prompt on any column and lets make it to set a presentation variable named Test
Now go back to the report that we created above and navigate to Advanced Tab. Now in the prefix type in the below formula
SET VARIABLE Test_Var=’@{Test}’;
Now, save this report and go to the dashboard and include the prompt and the report that we created. Enter any value in the Edit Prompt and click on go. You would notice that the Session Variable Value changes based on the value that was entered in the dashboard prompt.
This is again very useful for making update calls from the presentation layer to the BI Server.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10009036/viewspace-1069864/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- [轉]Updating Session Variables through GO URLSessionGo
- Using Multiple Variables with the Same Name
- Clouse Variables as Inputs
- [Bash] Environment variables
- Variables in Java 變數Java變數
- activiti變數variables變數
- SQL*Plus Substitution VariablesSQL
- MYSQL SHOW VARIABLES簡介MySql
- Type-Checking Variables
- proxysql global_variables 翻譯SQL
- variables_order引數詳解
- TensorFlow入門 - 變數(Variables)變數
- JavaScript30 - 3.CSS VariablesJavaScriptCSS
- 17-Containers-Container Environment VariablesAI
- Selecting an Instance with Environment Variables (18)
- PostgreSQL DBA(129) - Extension(pg_variables).mdSQL
- Dependencies for Variables of Type Customer Exit [SAP Help]
- MySQL JDBC 出現多個 SHOW VARIABLES 語句。MySqlJDBC
- Selecting an Instance with Environment Variables : Solaris Example (19)
- Selecting an Instance with Environment Variables : Windows Example (20)Windows
- 9 Rules for Using Color in Business Intelligence DashboardsIntel
- vue-cli3整合typescript,sass variables,多頁打包VueTypeScript
- SAP BPS 變數完美級聯 - Variables in web interaces變數Web
- C# 3.0 feature 1--Implicitly typed local variablesC#
- 概率論與梳理統計-隨機變數random variables隨機變數random
- FastAPI(64)- Settings and Environment Variables 配置項和環境變數ASTAPI變數
- 1.2 C++變數和資料型別 (Variables and Data types )C++變數資料型別
- php中出現Strict Standards: Only variables should be passed by reference in的解決方法PHP
- ORA_NLS (ORA_NLS33, ORA_NLS10) Environment Variables explainedS3AI
- Angular 18+ 高階教程 – Component 元件 の @let Template Local VariablesAngular元件
- Recipe 4.10. Updating with Values from Another Table
- QIBO CMS /inc/common.inc.php Local Variables Overriding Vul In $_FILESPHP
- C++ 關於static variables的學習中遇到的問題總結C++
- In bugfree, 解決Strict Standards: Only variables should be passed by reference in FuncModel.inc.phpPHP
- Machine Learning (4) - 用 Dummy Variables & One Hot Encoding 處理非數字列值MacEncoding
- MYSQL connector/.NET 預設的 show variables 引起的執行緒mutex鎖爭用MySql執行緒Mutex
- error X3025:global variables are implicitly constant, enable compatibility mode to allow modificationError
- [20210218]Select vs Assign – How To Assign PLSQL Variables.txtSQL