Hi @User_HPSSW , Welcome to the Oracle Analytics community. Do you mind giving some more information about what you are asking? You tagged Publisher: is this question about Publisher? Your title says Oracle Analytics Server, and not sure what you mean by "url of oracle bi". The more information you give describing what…

@Prabhjeet Kaur , If you aren't asking about using BICC as part of data replication in DV, you should visit the forum in charge of the BICC product and all the other cloud applications, and ask there: BICC isn't an Oracle Analytics product, it isn't part of OAC or OAS (this category of this community), when not used for…

Hi, In Oracle Analytics, the username of who modified a catalog object is stored as one of the various metadata linked to the catalog object. Up to OBIEE 12c it was an information stored in the .atr file coming with the catalog object. In OAS it is stored in the database, inside the BIPLATFORM schema, because that's where…

You should look at the AGO function, that one will let you get the Amount for 2020 when on the 2021 year. And then, you can add a CASE WHEN to handle the case of the Amount existing already for that year, and if yes you use it, or the Amount doesn't exist (like for 2021) and in that case you do an AGO(…) * 1.02 . Something…

Adding on Philippe answer, if you don't want to go into building a full semantic model just for that "OR", you can do it in a dataflow and create a new dataset with the result of the OR join. And then use that where you need it. It could be a "quick win" (not ideal, not perfect, but does the job). Another simple solution…

Hi, It sounds like there is a lot of implicit information in your post. Because Publisher, as a technical solution, doesn't come with any data, but your post is all about data, it would be helpful if you take a step back and start by describing what product you are using (is that a Fusion application?), what you are doing,…

Hi @User_X7U2V , do you mean automate file upload and refresh reports in OAC? Do you mind if we take a step back to understand your situation/case and be able to answer based on that instead of guessing? You have some OAC content, probably DV workbooks built on top of one or more dataset, right? And now you would like to…

What does your source look like? The query behind this table? Does it retrieve A, B, Year, Amount? Or something else? My first guess is that in the row-by-row retrieved by the query, when year = 2021, there is nothing in the Amount_2020 column, and therefore your CASE WHEN is doing nothing * 1.02 = nothing.

Hi @User_GUABF , The feature highlighted in the above video, is currently only in OAC, introduced in the November 2024 release. If you are using OAS, you will need to wait OAS 2025 to have it.

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…