Aren't you using the wrong tool for the job? OBIEE first, and OAS now, has never been designed to be a database, to store data, and act as data source for analysis. The tool was meant as gateway to connect various sources together, model them to give them a business meaning, generate dynamic queries, and let business users…

Did you try running BVT on OAS? The BVT documentation said it didn’t support OAS. The tool isn’t much different, if it doesn’t work with OAS it’s probably because of a difference in the security (that can’t be changed in OAS). It would be quite simple to fix the code of BVT, but the code isn’t available and Oracle owns a…

You resurrected 3 old threads at least related to BVT. BVT is gone, doesn’t exist anymore, it has been decommissioned and removed fully from everywhere. It wasn’t built for an OBIEE to OAS upgraded, it was built to support a move to the cloud. How did you validate your OBIEE upgrades so far? Do the same with OAS, because…

You resurrected 3 old threads at least related to BVT. BVT is gone, doesn’t exist anymore, it has been decommissioned and removed fully from everywhere. It wasn’t built for an OBIEE to OAS upgraded, it was built to support a move to the cloud. How did you validate your OBIEE upgrades so far? Do the same with OAS, because…

You resurrected 3 old threads at least related to BVT. BVT is gone, doesn’t exist anymore, it has been decommissioned and removed fully from everywhere. It wasn’t built for an OBIEE to OAS upgraded, it was built to support a move to the cloud. How did you validate your OBIEE upgrades so far? Do the same with OAS, because…

What is the name of the product you are using? You asked in the OAC/OAS category, but OAC and OAS are platform without any content, while your question is about some type of pre-packaged content (or your own custom data models). Based on your reply, your question can be moved to the right category or you can be pointed to…

I would say there isn't a simple way because the subject area isn't unique for a query. If you build an union query, you can have 2 different (or more) subject areas involved in the same query. You can set the variable in the analysis itself, to a manual value, allowing you to cover the multiple subject areas cases, but…

+1 Michal, also because point (d) isn't really true with an Oracle database: the query with the inner join will be transformed by the database removing the join and pushing the condition in the WHERE clause (the same applies to outer joins rewritten from ANSI to Oracle join syntax, the (+) one). Keeping it simple: Tips for…

12.2, 12.3 : these aren't versions, and this is where the confusion is from. So you are using the latest (or worse case second to last) OAC version. This change everything...

I don't have such an old tool around to test. OBIEE 12.2.1.3 is very old, not even sure if it is certified for autonomous. I do remember that when I did update my wallets, because of the change in the certificates, there was a list of requirements for the clients to be able to use the new one with mTLS. I don't know if…

Ok, so OBIEE 12.2.1.3. For the image, apparently somebody configured this forum to allow edits only for 1h after posting (doesn't make much sense, but it's just one of the many issues of this forum). Sounds like you can't do much anymore for it...

What is the product name and version? And you should delete the screenshot of the MOS document: it's illegal to post MOS content in a public forum. If you need to reference a MOS document in a public space, post a URL and/or the Doc ID and users with a valid support contract will be able to open it.

You can also download the latest Oracle Analytics Cloud Virtual Appliance under the "OAC Images" tab. Just saying: no, this can't be done, if you don't work for Oracle. To the Oracle employees asking questions and answering them: never forget this is NOT an internal Oracle forum for employees only. This is a public forum.…

As said, you don't require SQL to work with OAC. You could build things visually and work "clicking" around without the need of writing queries. But SQL is really something extremely useful with working with this kind of tools.

Are you asking if you need to know SQL to learn and use OAC? Or are you asking how to learn SQL as well? While you could use OAC without knowing SQL, I will say you will not fully understand how the tool work without knowing SQL. You will still be able to build things and display data, but you will not really be able to…

You can create free tier account and provision OAC there. https://www.oracle.com/in/cloud/free/ Keep in mind that OAC is not part of the free tier but it is available with the 30 days 300$ cloud credits. As soon as you reach 30 days or 300$ (the first one), your OAC will stop working or you have to pay for it yourself (and…

If you look at the posted example, the filterExpressions is a piece of XML that use the same XML syntax as filters in an analysis. If you don't want to write it by hand from scratch, build the filter in an analysis and then look at the XML and adapt it as needed. (Using the webservice is a kind of advanced task and that's…

@user9176407 Post a new question instead of commenting on a 7 years old thread. Also make sure to provide the minimum information for people not seeing your screen or knowing your environment: product name and version, and what means for you "command", "data manipulation", "XYZ" etc.

we have a password standard of 30 characters or less If that's really the standard, 16 being less than 30, it does still match with your standard. I didn't go reading details of where that limits come from, but you could try to test if it's just the RCU having that limit. Create the schemas with a short (<=16 characters),…

As Ezequiel said, the font used in more easily changed in a custom style instead of having to edit everything and force a font. You don't have to import the font, it should be available on the clients (and Calibri is everywhere on Windows clients, but still, you better define 2-3 fonts as it's common practice to make sure…