As said in the other thread, the MOS document https://support.oracle.com/epmos/faces/DocContentDisplay?id=2072347.1 says BVT is not supported on OAS. The question is what "not supported" means: it does (maybe) work but there is no support from Oracle if it doesn't? Or it means it doesn't work?

https://community.oracle.com/tech/apps-infra/discussion/comment/16810752#Comment_16810752 As far as I know not, and https://support.oracle.com/epmos/faces/DocContentDisplay?id=2072347.1 has a note saying it isn't supported on OAS.

Could you look at the logs for the 2 situations? (the one with 32 and the one with 1) Because in theory it should work, in practice it could depends on other things as well. But here it also goes into the used model etc., and only you have this model. Also what about the exact product name, version and bundle patch? Is it…

You maybe aren't really looking for the equivalent of VLOOKUP... You have dashboard page, this means that you can have multiple analysis in it and therefore not a real need to get a value into another one. So the question is more about how to get the RANK of a given customer without having all the customers in the…

You can use an analysis as filter for another one, if you have an analysis giving you the name of the customer, you can use it as filter for the second analysis with the ranking. Or, of course, use a prompt (either directly or via a presentation variable) for the job.

You have to edit your database and pick the right type there. If you select an Oracle database as type at the database level, the connection pool inside will give your different Call Interface options. PS: while it isn't fully in the wrong place, in the future feel free to ask OBIEE / OAS questions in…

Log files! Every single piece/component of OBIEE has logs, lot of logs. If the bi_server1 managed server doesn't start, look at that log file (and no need to take a picture of the file on your screen and post it: the log is long and you have to read through to understand what is going on).

Did you try adding something else new in the RPD? Same issue? Dropping and re-adding that object it still behave the same? Did it ever happen before? (Yes, it's really random tests to try to isolate the case and see if it can be reproduced all the time or it has been a single occurrence issue).

Is a "domain" a subject area? Or is it a business model? Or both? When you say disappeared, you mean you don't see the new objects anymore in the front-end? Or that if you download the RPD from your OBIEE server the changes aren't there anymore? How did you do the changes? Fully offline? How did you deploy the RPD? Did you…

Sorry to ask, but did you even only googled what OAD is? No, OAD isn't a full OAS running on your laptop (what would be the point of making a different product if it does the same thing?), OAD is only DV and nothing else. The download page of OAD tells you the requirements:

Where are you executing BVT? (what environment, OS) If you increase the log level to "FINEST" you will get the details of the IOException that is generating that error.

https://community.oracle.com/tech/apps-infra/discussion/comment/16809998#Comment_16809998 Ok, but did you try to debug the query to find your error? Nobody here has your database to run your query against it and see where the issue is. Decompose all those conditions in small pieces, focus mainly on what tries to convert…

ORA-01843: not a valid month This is a database error, it isn't the BI server complaining, but the database receiving the query doesn't like it. Look at the generated physical query (you posted the logical query), and find the error there. It will lead you to easily fix your LSQL formula once you understand what the…

10-12 GB of free memory and 10 GB Swap Space for run-time requirements What I say is that it isn't like 10+ years ago when RAM was expensive and Swap was a cheap alternative (because being on disk, a slow and cheap device) and so a server was configured with as little RAM as possible and following those specs. Nowadays…

It's is created by the system. If OBIEE create the file, it isn't going to be an issue. OBIEE doesn't go read the file every time you run a query, you aren't going to see a performance impact on that side. As said: it's something fully managed by the system, you shouldn't even be there looking at what is created. Or,…

And what is the issue? If the issue is that a file is created in that folder, why are you even looking there? In OBIEE 12c, the RPD isn't to be placed physically in a given folder on the server. There is a utility to download and upload the RPD and what the server does with it, isn't your business (that's why you paid a…

You don't provide any context or details. What exact product name, version and bundle patch? What's the history of that environment? What did change before the issues started? Anything to let us, not seeing your system, have an idea of what the context is...

What is your OS?

You references a MOS document about 10.1.3.4, let's just say it doesn't apply anymore (please don't tell me you are trying to install that version or another no more supported version). As your sys admins told you, swap isn't for tmp files like the ones mentioned by the MOS document you linked. Swap is used when you run…

What for? You maybe want to provide some context about your question, because right now I don't really see what kind of "smart" reply could be given....