Hi @Bhanu Priya , BICC isn't technically speaking an Analytics product, it's part of Fusion. Fusion and data questions could more easily find answers in Cloud Customer Connect, a parallel forum: .

Hi, Your request isn't about Publisher, but is a SQL question. You should consider posting in forums dedicated to that, for example . Also, did you check ?

@dilek , Based on the document linked above, you can read that there are number of requirements for OAS, mostly it always point to a form of SSO. Last time I tried (a quick test just to know what to answer to a customer's question) right after OAS 2024 has been released, I didn't need a SSO. What was required was OAS to be…

@User_2A2IB , For the future, this forum/community is focusing on Oracle Analytics, not Oracle Cloud in general. There are a number of other forums/communities covering Oracle Cloud and various services in there. PS: I though employees have a policy requiring them to identify as Oracle when using public forums, you maybe…

Did you follow the steps described on the point 2. of that page? The Cloud Customer Connect forum requires users to first indicate interests to have a full registration and have access to it. They also give you some step-by-step instructions.

Hi, Your question being about data, it isn't a Publisher question, this category cover Publisher as a technical product. If you don't have FDI, you should consider asking in the forum covering the Fusion application you are interested in:

You don't say "where" or "how" you would like to do that: analysis, DV workbook, semantic model/RPD, Publisher? Keeping it simple, assuming there is a SQL source somewhere there behind, UNION is what you look for. with t as ( select 1 a, 1 b from dual union all select 2, 1 from dual union all select 1, 3 from dual ) select…

@Luis E. Rivas -Oracle , I know how the Oracle processes are, and that you will not give any date for when this will be officially supported. But knowing what this "feature" allows, that it's a fundamental thing for any enterprise usage of datasets because that's what allows to have an equivalent of row-level security…

Welcome to the forum, Do you mind sharing a screenshot of where you restrict, or allow, a PNG in Console > System Settings > Security? Because I don't see that in OAC, and I also don't remember having seen that (but right now I only have a “special” instance handy, therefore it could be something on that instance) The same…

By different server I meant that you would need a second OBIEE 12c server. OBIEE can use only a single RPD. If you want to test your existing catalog content with your current RPD model but sourcing from Snowflake, in parallel of having your environment sourcing from an Oracle database, you need a second OBIEE where to run…

Hi @Sneha_K-Oracle , This is an almost 7 years old thread, that has been migrated across a few forums over time. The users who posted above aren't active anymore (at least they never used this forum in the past 2 years). Ask a new question in the Publisher category, providing all the details (product name, version) and…

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…