What Massimo said is how to get the list dynamically. For the part where you want to filter the delivery, you will need to use OBIEE filtering as an agent is a normal OBIEE content. How can you show different content of a same analysis to different users? You must either use row-level security with filters applied at the…

Just to be clear: which direction is the webservice going? You want to expose OBIEE content via a webservice for other services to consume it? The official doc covers how OBIEE can be used via webservices, describing the location of the WSDL and the services, methods and parameters:…

3063133 wrote:I'm having an issue with a prompt in OBIEE 12.2.1.2.0. But this is what I'm saying ... You don't say what bundle patch you have installed in your 12.2.1.2.0, did you read the release notes of the fixed issues in the next bundle patches you didn't install now if any? Did you read the release notes of the fixed…

Hi, What exact OBIEE version you come from and which exact version you are moving to? (version + bundle patch)

2943093 wrote:Sometimes we are unable to login in to OBIEE, the issue is getting resolved once we restart the services.Please suggest me. Did you try contacting your system administrator? Somebody having access to all the environment information (so the question would have a context) and also access to log files where he…

Isn't this something which has been fixed in one of the various bundle patches of that unsupported version or the following ones? Would require to go through the release notes to find out but I believe I saw over the last 2 years at least one or few bugs linked to row level security and caching. You don't say anything…

2638545 wrote:I have already refereed Doc ID 2495989.1 but it does not explain what should be path variable or values of registry The document says what you have to make sure about the PATH variable, you must make sure it contains the Admintool bin path. The registry entries must already have the right settings if you…

Use your browser developer toolbar to identify how to uniquely select that entry of the export options. You have jQuery loaded by default in 12c, therefore you can use to precisely select that entry and either remove it from the DOM or hide it. Just remember to add the even handler to run that code only when the document…

There isn't a setting to control the formats of the export. It's either all there or none. What you can do is more a UI trick to hide the Excel 2007 option. By using some JS/CSS you can hide it. Based on the code you can make it work on a single analysis or on the whole browser page (= dashboard page). You add the code to…

Who told you it is files? The tool manage these things internally, you can't touch them in any possible way, all you can do is to set some permissions on them. Nothing else. They aren't objects of the catalog like analysis, pages or DV projects, they are different.

Yeah, for your need this option is absolutely not what you look for. The behaviour is fine because it's better from a performance point of view to not have a WHERE condition instead of having it with 10'000 values. But your need is fairly different and not so common. By using hierarchies (so having an higher level on that…

"All Column Values" doesn't include all the values of the column, it actually bypass the filter and tell OBIEE to not filter on that column. Therefore what you look for it's impossible because of how "All Column Values" work. And there is nothing in OBIEE allowing you to do what you ask for. Workarounds could be achieved…

Instead of MAX, use a reversed RANK by INVNO, so you can filter on this new column = 1 to get the highest SUBMIT_ORDER by INVNO.

Hi, You are talking about a pre-packaged product, so you must ask in that product forum. OBIEE comes with no content out of the box. Based on your product you can move or ask a MOD to move your thread to the right place.

It is in the catalog, in the system folder. So if you migrate the whole catalog via a BAR you are covered, it will come with it.

Not sure I'm going to answer your question (if it isn't the case, maybe you can post a screenshot just showing what the issue is?) You are using the prompt functionality of the pivot view, as the name says it acts as a prompt. Just like the dashboard prompt does, where you select a value and this is generally used as…

Good news: soon we will have OAS and on-premises will be just like OAC I would say that by the nature of the changes the import of a BAR does, a restart is to be expected (or all sessions gone as you say at least). And because of that I wouldn't be shocked if doing it while off is required, but at the same time I remember…

Mmmhhhh .... I have a blank right now (damn, I really have to run those commands more often to not forget them!). @Joel Acha & @Christian Berg please feel free to cover my missing memory on this one (probably the answer will come in 7-8h, midnight now here in Europe...)

Hi Adam, The BAR approach is safe and so disconnected from the original server which allows you to deploy that BAR anywhere, including your DR environment. Just need to make sure the weblogic embedded LDAP also has a process taking care to sync it as it isn't included in the BAR. You definitely have a good point on what…

Is 'opatch' the command not found? Make sure it's in your path, I don't think it is by default. Adding %ORACLE_HOME%\OPatch and %ORACLE_HOME%\bin to the PATH generally is enough to make your system able to find and run opatch.