Also keep in mind that if you datasets or dataflows based on your RPD, you also need to do renaming in there, and there is no tool for that, as Christian said above.

In OAC, mostly if you have more than one person modifying the RPD, you should consider transitioning to the Semantic Modeler that provides a native versioning mechanism and could make the work of your developers easier.

Double post after a misleading instruction to post again instead of moving the thread. Closing this one… https://community.oracle.com/products/oracleanalytics/discussion/24227/unable-to-add-new-field-in-rtf-template-due-to-the-previous-grouping-structure

Speak to your cloud tenancy administrator and ask them to look into their users and credentials. You aren't having an issue with Publisher, you are not even in Publisher: you are not being able to authenticate with your cloud credentials. If your tenancy administrators says everything is configured correctly, then tell…

Hi, Your question seem to be about Oracle Integration Cloud. This community, this forum, only covers Oracle Analytics products, and OIC isn't part of them. You should go to the parallel forum https://community.oracle.com/customerconnect/categories/oci-integration for your OIC question (I believe that's a direct link to the…

The column "table_name" in user_tab_columnsis just the table name, not the schema . table name. And user_tab_columns, as the name suggest, only works for objects owned by the current user (https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/USER_TAB_COLUMNS.html). If the owner of the table is another user,…

@User_XT7VC , you mean that you can't open https://community.oracle.com/products/oracleanalytics/post/question/oac-oas ? That isn't normal, what kind of error or message do you see on screen on that page (not ideal to "debug" the forum here, but if it doesn't let you ask a question it kind of kill the idea of a forum…

Hi @User_XT7VC , Do you mind posting a new question for your problem? You should also provide more details, starting from OS (and version) used, how you did perform the install, if it ever worked before or you always had the HTTP-500 and ideally also what is the root cause you can see in the log files. The HTTP-500 is only…

Hi, Can you provide some more information about what you are doing when having that error? What service are you calling in OAC? (OAC has many parts, each having different web services exposed) How are you calling it? The paths you posted mention BIP: is this only related to Publisher?

With all due respect for @GayathriAnand-Oracle reply, even if that feature was available, it is pointless for your request. The feature she mentions is only valid for caching a dataset and refreshing only new records or changed records instead of having to reload the whole dataset in the cache. It isn't your case. Look at…

Ok, moved to the Publisher category to get the attention of the Publisher people. I do remember having seen a number of topic about Publisher upgrades and migrations, it sounds like a topic where there is still space for some "good practices" in how to perform those things.

the scheduler jobs used by BI Publisher @Tiang , is your question mostly focused on the Publisher content migration? Or do you also have other elements of the analytics platform that you are interested in? I'm asking because if you are mostly after the "good practice" to migrate the whole Publisher content, moving this…

Ok, in this case (with an API giving you only new and updated rows), caching isn't going to help you much in my opinion: you still don't have a full, unified, dataset at this point to benefit from a "smart" caching mechanism. I believe that a dataflow is what you will need to do the job of adding the new records and…

the volume of data is too large to be ingested through a single API call. Not directly answering your question, but if the size is a challenge on the API call side, is incremental load really going to help you? If you don't have a different API call that only gives you new and updated rows, your size issue will still be…

@Eliran Hadad , What you see is the expected behavior as @GayathriAnand-Oracle described above. The idea is that your analysis or Publisher report is added to a dashboard page somewhere, and the traverse permission allow users to see it while not being able to "find it" (navigate to it) in the catalog page. If you want…

As much as I would agree with the above comments that complex calculations are better performed in the database, in your case it can't work… You are mostly facing a single expression repeated multiple times: FLOOR((TRUNC(sysdate) - TRUNC(TERM_DUE_DATE))) By using sysdate, you prevent yourself of being able to calculate…

Hi @uocam , No need to post it anywhere else. Publisher is just a different category in this community (not a different community). Your question has been moved there (from the OBIA category). If you want a direct link to the Publisher category it is this one:…

@SARAORC , Please do not double post, it doesn't get you more answers but the opposite. This one is now closed.

Hi, Any idea why there are two oracle community? There are many Oracle forums (at least 5-6), and each has some special focus (MOSC is the exception as it covers many products). Oracle Analytics products are covered in this one, in https://forums.oracle.com/ there is a pinned message on top of the category where the…

Hi, As said earlier by Steve, your picture show the global Oracle Cloud account login screen, not an Oracle Analytics screen. Therefore your issue seems to be a cloud user issue, which is covered in a different forum (Steve provided 2 links), and if you can't get your cloud account administrator to solve your cloud account…