Hi @Abhi209 , Welcome to the Oracle Analytics community. This is a very old post (8 years) that has been migrated across a few forums. The best way to receive an answer that could help you, is to post a new question (button on the top-left), giving all the details about it. A product name and version and more details about…

Hi @Mohan Ambavaram , Welcome to the Oracle Analytics community. Your message apparently got missing somewhere, it just has a title. Would you mind posting some more details about what you look for? It's also possible that you maybe aren't in the best place for it (there are many parallel Oracle forums), and based on the…

If you model your 2 sources in the same RPD, you will have exposed as SubjectArea1, the other one as SubjectArea2. If you then want to compare an analysis, you can rebuild it using SubjectArea2 and then you can open the 2 analyses and you compare them. Or you duplicate an existing analysis and then point it to the new…

There are no risks as long as you don't touch the existing objects in the RPD, the new content will be fully separated, not sharing anything with the existing. They are inside the same RPD but do not interact in any way. Then all your catalog objects will need to be edited or duplicated to point to the new subject area(s).…

Hi Dilek, In my test, done end of May 2024 with OAS 2024, I didn't have any issue and I didn't have SSO. I tested with a clean install of OAS 2024 and just adding a proxy in front. I didn't configure the proxy for each service/path of OAS, it was just a full proxy for any request to <host>:443 ⇒ <OAS>:9502 . I would look…

Hi @Faizan Rashid , Welcome to the Oracle Analytics community. Could you share what product is your request related to? I see the Publisher tag, but your question is about data, and Publisher itself comes without data (it can connect to a number of sources). It's possible that your question isn't related to an Oracle…

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.