Hello Everyone,
Is it possible to create a report in BI analytics to list all the repository variables ? If so Please let me know or shower some ideas on how to get a list of repository variables.
Thanks,
Ary
Hi,
Have a look at OBIEE SampleApp , it has an analysis showing variables. Can't remember if it's session or repository variables (or both probably).
It uses the "issue SQL" page to call a NQS function returning the list of variables defined in the RPD.
So you can use that way of doing things.
Same thing is by calling the executeSQLQuery method of the XML View webservice, it's the same exact thing and you will execute the same exact query to get the XML back.
As Gianni said there's a script in the SampleApp which basically does this:
call NQSQueryMetadataObjects('3031',...)
Just search the VM for listRepVars.js and then call it from a text dashboard object like showcased in the "Admin Features" dashboard, "More Variables" page.
Thanks for the reply. I followed instructions as provided. I deployed listRepVars.js file and created text box in dashboard. When i run the dashboard all I see is the empty table structure for statics and repository variables without any content in it. Please help where i did mistake.
I am using below code in the text box.
<html>
<head>
<script src='/analyticsRes/CustomApp/customjs/listRepVars.js'></script>
<style>
table.ma_toc tr:hover td{
background-color: #DEEEFE;
} </style>
</head>
<body>
<h3>Static Variables</h3>
<table id='staticVars' class='ma_toc' width="900px" cellpadding="2px" border="1px" bordercolor="#e2e2e2" style="border-collapse:collapse;font-family: Arial;font-size: 12px">
<tr style="background-color:#e1e1e1" align="left"><th><b>Name</b></th><th><b>Current Value</b></th></tr>
</table>
<br/>
<h3>Session Variables</h3>
<table id='sessionVars' class='ma_toc' width="900px" cellpadding="2px" border="1px" bordercolor="#e2e2e2" style="border-collapse:collapse;font-family: Arial;font-size: 12px;">
<tr style="background-color:#e1e1e1" align="left"><th><b>Name</b></th><th><b>Init Block</b></th><th width=110><b>Var Type</b></th><th><b>Current Value</b></th></tr>
<script>listRepVariables();</script>
</body>
</html>
Did you looked at what was written in SampleApp and looked how the code they had in their page and looked at the script itself?
The idea of the script is to use javascript to send a request to the "Issue SQL" page you find in "Administration". The query will be the "call NQS..." which return some XML (you can run it by hand there and see the result). The script will then parse the output to get the list of variables and finally display them.
So if you don't see anything start debugging.
It's javascript, which means you have lot of chances you have an issue there, open the developer toolbar of your browser and look at what happen. Is the JS loaded? Is the query sent to the "Issue SQL" page? Does this page return something? Is this "something" parsed into something else? etc.
Of course if you don't have the permission to open and use the "Issue SQL" page do not even try to use the script: it will not bypass any security, if you aren't allowed it will fail.
user9255588 wrote: <script src='/analyticsRes/CustomApp/customjs/listRepVars.js'></script>
So I assume you deployed analyticsRes and there inside created a "CustomApp" folder with another folder inside named "customjs" and placed "listRepVars.js" there inside?
Do not copy things randomly but first look and try to understand what will happen and how things are supposed to work.
There isn't any simple out of the box way to list variables, it's a totally custom developed things. So you must understand the concept of how it will work (and why it will work) and then implement it based on your system.
+1 to Gianni it's all about file placement. My custom JS are normally in /mydeployment/customJS right next to /mydeployment/customMessages
So the line would read <script src='/mydeployment/customJS/listRepVars.js'></script>
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
The user icon in the upper-right corner of OAC (DV) is displaying more menu options for our non-admin users than we wish to display. We would like to restrict these to only "Profile" and "Sign Out" for regular users. Is there a way to customize these menu items? Especially if we can control this via security, that would be…
What is wrong with this code
Am I missing something or is there no way to search through previous posts to make sure I don't duplicate a question? All I see on the filter options are tags or status… a general search for a word or phrase would be helpful.
We were under the impression that when exporting a visualization in DV to CSV format hidden columns would be include from the grammar panel. This is not happening. See below for a screenshot showing 3 hidden columns that do not appear when exporting the pivot table to CSV. This seems to have worked a month or so back but…
Migrated RPD from obiee12c to OAS 2024. post migration when we try to access dashboards on OAS we are getting below error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS…
