And the context is? Where are you running that? Did it ever work? What did you install in that place to have the "datamodel.sh" file?

By the way: you did open 3 thread for the same exact thing. It's against the forum rules to double post...

Hi, Your question sounds more related to a product different than OBIEE, even if OBIEE is maybe used for the job. You ask about pre-packaged metadata, if you name that product properly it is maybe possible to move this thread in the right place.

That piece of text is stored inside the agent in the catalog. You should find it if you read the XML of the agent. Catalog Manager does have a search & replace option, just keep in mind there isn't an "undo" function: once you did replace something, it's replaced. This means you should take a backup of your backup of your…

That's LSQL, now look at the physical SQL generated by those LSQL statements. Because 2 very similar LSQL can have very different physical SQL generated (that's the real power of Oracle Analytics with the RPD).

There is no magic in DV: everything is a query that retrieve some data. Look at the generated LSQL, look at the generated real SQL and adjust accordingly to fix your error. As it's based on your source and you don't say a word about it, where it is from and how it got there, nothing else can be said.

The easiest dirty solution crossing my mind is ... a virtualmachine 😐️ You could run it on your shared server: if on a desktop OS the Admin tool works fine with your RPD, that could be a workaround. It's not nice, not at all, but at some point there aren't tons of alternatives. Because the server OS isn't certified…

As far as I know no, because the concept of the Admin tool is to be a client tool, not a server tool. Therefore the certification is for clients OS (and not server OS).

That's what a 8 years old version gives you: even MOS updated their document to match newer versions. Still there are various blog posts on the topic. By reading the 12c MOS document you have an idea of what tasks could be involved, with that in mind you can read 2-3 of the blog posts about doing the job on 11g and see if…

There are MOS documents covering this topic, did you search in there? The question is: why do they bother to update their database to 19c but keep using an OBIEE 11.1.1.7, an 8 years old version that heavily require Flash to not look like a webpage of 20 years ago? Time to take updates seriously...

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…