As you are talking about OAC (a cloud product), what is "Server A"? It's a database of some kind, ok, but what exact kind of database and where is it? Keeping it short, you can't install OAC on "Server A", mainly because you don't decide where to install OAC: you ask for an instance and you receive the instance. You don't…

What product are you talking about? Not sure what you are using as "workbook" isn't a natural word in OBIEE/OAS...

You have an issue with the file names. The 5 files you download should be named exactly SampleAppv607p-appliance.zip.001 , .002, .003, .004, .005 Your file seem to be named "SampleAppv607p-appliance.zip.zip". Set the correct file names and it will go well.

That's one I have handy: biserverxmlgen.sh|.cmd -R <RPD file path> -P <RPD password> -O <destination XML file> The script is next to all other scripts (runcat etc.). When done via the GUI it does split every object into a file and type of objects in folders: you could still do the job, but it will need to go through a…

Try running ./runcat.sh -cmd report -help It will gives you the answer you are looking for. The blog post is from 2014, at that time it was 11g. 12c changed various things, but the help command will tell you exactly what it expects for the -fields parameter (which is dependent on the value of -type as well).

To be honest no idea, I really try to stay away from using a SELECT as table in the RPD because it hide the logic of things, it's "safer" to create a view in the database with the logic, a lot simpler to track the logic and audit. If you can't get an RPD report giving you that, another way of getting there could be…

You can setup your own monitoring tool looking at agents logs and status in the database (S_NQ_JOB and related tables in the BIPLATFORM schema), or you can also setup an OBIEE agent using the agents tables to send you an agent when another agent failed. Of course if the issue is in the mail server or the whole OBIEE…

Did try by generating a report with Catalog Manager? It probably tells you something special for analysis built on a direct database request. As alternative, you can do a full search in the catalog for every analysis having the special XML attribute that exists only in DDR analysis: connectionPool=" Both ways should work,…

What are you talking about? A product name and version would help, and also any other detail about what you have done so far because we can't see your screen...

It's all about finding how to escape / encode correctly things. I know it is possible (done that), but it was so long ago that I just can't remember anymore what it was like... Not having much time to try it myself today.

So you talk about BI Publisher reports? ("basic analysis reports" : here again you are using the word analysis which generally point to a Classic/Answer analysis and report which points to BI Publisher, a different tool even if embedded inside OAS/OAC/OBIEE) You also mentioned "OBIEE cloud" in your original post: do you…

Sorry to ask, what is a VAR file? Do you mean BAR? Assuming you meant BAR, an import of a BAR does replace what you tell it to replace. If your BAR file doesn't have that piece of content, it should get rid of the existing to replace it with nothing. The import let you define (at a high level at least) the content to…

What do you call "reports"? DV projects? Classic analysis? BI Publisher reports? There are ways, but users will still have customization options most of the time...

How about trying from the GUI of runcat? It should deal with the escaping there....

This is just a duplicate of https://community.oracle.com/tech/apps-infra/discussion/4486979/how-to-replace-column-name-in-existing-reports#latest , no idea why it exists, but close it. Double posting isn't a good thing (and also against the forum rules)

Try looking in your log files if you have a log level high enough. But you should really consider enabling usage tracking as it's useful for various tasks.

Did you try some alternative syntax to escape " ? " in your command is probably interpreted as a quoting of the values and not as part of the value to search & replace.

What do the logs show? How is the query showing all the values different than the one with the filtered values?

I highly doubt an Essbase server has an http:// address, "Essbase Server" is the address where the Essbase agent can be connected, it isn't an http:// link. Read the doc, it tells you most of the things you should look for:…

What is your exact version of OBIEE? (12c doesn't mean anything as there are 5 main versions and many many more bundle patches). Did you check the certification matrix? OBIEE 12.2.1.4 is certified for Essbase 11 and 12, you are using Essbase 9: a very very old release (2005 or there around) and things changed with 11 and…