Support of Oracle product is covered in details in MOS documents, like https://support.oracle.com/epmos/faces/DocContentDisplay?id=2775561.1 for OAS. If you have an environment that was working and then stopped working, you should look at what changed between the last time it did work and when it didn't. The only…

You can duplicate everything in your RPD (obviously you need a different name for the subject area and the business model). You create your new physical source, import/define your physical objects, map them to the copied business model, create a subject area on top of it. The easiest would be a different server where you…

And confirmed! /ui/dv/ui/api/v1/queryvalidation/whereswill happily validate the usage of a session variable there, even spaces around the = . It's really just the front-end blocking the validation, and not even sending the async call to the back-end for it.

Thanks Wayne for the 'space' hint, that is the key to get it validated. The fun thing is that the validation error doesn't come from the backend, it's a front-end limitation. With a space after the '=' the front-end javascript doesn't even send a request to /ui/dv/ui/api/v1/queryvalidation/wheresto check for validation, it…

@Ankur.Bansal , please do not double post

Now I'm curious: when it validate, does it work as expected? Because if it does, I'm very much curious to know why the not-validating message is that the session variables are not supported there.

Hi, I never managed to get a valid validation, always got the "Invalid Expression. Session variables are not supported". And I tried a number of times…

Did you check the logs? Without building a same use cases, difficult to say if OAC can or can't do an outer join when done by the BI Server. But the logs should tell you everything is going on with your query and how it is being handled. It also allow you to make sure you aren't killing your outer join, turning it into the…

Hi, Welcome to the Oracle Analytics community. I have the impression you are in the wrong forum/community. This one look after Oracle Analytics products, while your question seems to be more about an application, maybe a Fusion application? If you are asking about a Fusion app, you should have a look in , it's a parallel…

Hi, What product/version are you using? Just to not give you random replies based on a product you aren't using (OAC is now almost 12 months ahead the latest OAS, and all the changes are in DV).

Hi, If you use the Semantic Model to model your data, you can easily create multiple logical table sources for a unique logical table "Sales" with fragmentation logic to tell the system what tables contains what data. Then, when you run queries, the system will automatically query the right table(s) based on the conditions…

Not sure you can do much. ODBC is a very generic and almost every source has its own little special things. The RPD supports generic ODBC and that's what it does try to speak with the sources. That's why I was saying to directly see if there is some data coming through when doing an analysis, because doing a row count in…

Hi, OAS 2024, also known as OAS 7.6, does comes with the Admin tool version 12.4.2.0.0. You should try to at least use products of the same versions. Not saying that this is your issue… What kind of database type did you select for your Databricks connection? The import of metadata maybe worked, but doesn't mean that the…

The timing is maybe going to play against you: the OAS 2025 release is probably being packaged right now, therefore even if they do implement the feature, you will not have it in OAS before 2026. But at least it's there. I imagine support for pagination can be handled by some attributes of each end point, because every…

As far as I know there isn't any setting for pagination of REST calls, and I doubt it does magically handle it (if it was the case, you wouldn't be asking). The REST connector is still defined as "preview", therefore it's possible that support for pagination could be added in the future. The best you can do for now is to…

In addition to what Federico said, if your 2 tables do not contains exactly the same data, you don't want to always query both tables. If you have a known rule defining what is in table A and what is in table B, you can define the fragmentation rule. In this way, if a filter is set in the front-end for that same criteria,…

This RPD was working fine in my previous Oracle Version OBIEE 11g. Going in the same direction of where @Brandon_H was going (I believe): did you upgrade your RPD before to try to deploy it in OAS 2024? Because OBIEE 11g is many many years older than OAS 2024, and there have been many changes. Even just OBIEE 12c required…

Hi, Do you mind to expand the "WACS" acronym? Is that Oracle Utilities Work and Asset Cloud Service? If it's the case, I imagine your Publisher is provided as part of that service, is an embedded thing and a product you installed independently, right? If WACS is that cloud service I mentioned, I have no clue what it does…

Hi, You seem to be asking a purely data-related question and not a Publisher question. As you refer to a MOS document about Oracle Fusion Cloud services, you should consider asking in the forum that cover Oracle Fusion Cloud applications: (it's a parallel forum fully independent from this one). This category is mostly for…

Hi @MSR16 , Another question for you, just to have a better understanding: as your Publisher is part of OAS, did you install the full OAS and are you using the Fusion Middleware security? Or it's fully standalone and you followed for the config of your LDAP?