You can't use a TNS name in OAC because you don't have access to the tnsnames.ora file on OAC (it's cloud!). Remove the TNS name and enter a full connection string pointing to your database. The DV connections have nothing to do with the RPD.

Actually, not sure your option 2) really works with OAC. I don't have an OAC up and running right now to test, I know that the "downloadrpd" parameter does work, but the upload maybe doesn't because you will not know all the parameters to use. Still not a big deal as there are the other 2 ways: via the admintool directly…

And the doc says you can also do it via the console in OAC, the 3 ways should work and will do the same job. Option 2) can be performed by your own local laptop/desktop PC where you installed the Admin tool: it comes with datamodel.cmd Try it and you will see if all works. But as you have alternative methods, not a big…

The RPD is a piece of OAC, so it can only be deployed in OAC and not in any kind of database. For the how, the doc covers all that. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsmd/upload-data-models-file-rpd-using-console.html…

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.