The issue is to know what you did in detail and what is working and what not. If there is an issue with the internal LDAP over SSL, nobody will be able to login because you have an issue connecting to it. The Doc ID 2188982.1 globally works, but it's safer to do things step by step to not lock yourself out if you aren't…

While not knowing what has been setup, I would say that first 12.2.1.2.0 is old and would deserve an update to 12.2.1.4 at least (if not OAS 5.9). Second, this could be because you didn't configure your system to speak with the internal LDAP over SSL? The doc covers these aspects, so no idea what documentation you did…

While not being what you are asking, what about saving your analysis column for now as workaround? Users will find it in the catalog and can easily add it to any analysis where they need it just with a double-click (or drag & drop). It will contain whatever formula you save in it.

BVT isn't really maintained or developed anymore, it was a tool to motivate people to move to 12c at the beginning and as been used for the initial cloud migration as well, but that's about it. I did post an idea in the CCC Analytics forum to make the BVT code opensource so the community could take over the project and…

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…