Based on your numbers, your RPD isn't huge but already a good size with 120 elements in a logical model. More than on another server I would try on a client: the admin tool is developed to be used on a laptop or desktop PC, it is a client. There is no licensing, you can install 200 admin tools, you are paying for the…

To what numbers of objects does the 1Mb translate? (subject areas, business models, .... some generic numbers to have an idea about what's inside that RPD). The Admin tool isn't Java (and that's why it works only on Windows), so java settings aren't going to do much.

Ask your sysadmin to check your settings and look into network connectivity, firewalls etc.

What kind of work is it: online or offline? How big is your RPD? Does it behave differently when using the admin tool somewhere else than on that environment? I don't remember having ever seen a document about "admin tool" performance.

No, no filters. The TOPN(....) formula will filter for your directly as you can see in this quick example on a TOP 3.

Hi, Your prompt set a presentation variable and in the formula for your TOP x you use the variable instead of the hardcoded number. Just make sure to also set a default value in case the variable isn't set (for when you preview the analysis alone and not in the page where the prompt setting the variable is located. You can…

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.