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 there is a pinned message on top of the category where the Analytics content has been moved…

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…

I can understand that GEN2 and GEN3 are common names for you, but they don't mean much for somebody not being in your environment. A full product name and a version would increase your chances for useful replies (always keeping in mind this is maybe not the right forum for your product/request).

Hi, If your issue is with BICC, this is probably covered by the CCC forum at . Look for your app and the various categories in there.

Hi @Mayank6088 , You maybe could provide some more details about your question. Currently there is only a title but no content was provided (or got lost somewhere in the submission). What part of the product are you talking about? DV? "Classic"? Publisher? Waiting for more details, I can just say that a majority of people…

@Chandresh Patel , the "old" webservices (WSDL) also support a login with a token. It just isn't documented because the doc for the WSDL webservices is being reviewed and refreshed now for Oracle Analytics (Cloud and Server). @Mike Durran-Oracle mentioned that in a previous post here in the forum about the WSDL…

If you aren't using a TLS connection, the change in TLS connections will not affect you. The change is that they will "force" to use newer/recent versions and probably desupport old versions (TLS 1.0 and 1.1 I imagine). If you have connection using TLS, you should perform the test documented to check if they will be good…

Actually I believe you also have an error in the formula you used: EXTRACTYEAR returns a timestamp for January 1st for the year in which the input value occurs. That's not what you want, you want just the year, as a number (and not a timestamp), for your date: you should use the YEAR(<date>) function instead.

Hi, In your "Previous Year" calculation, what are you trying to get as value? Currently, if your formula would validate, your "Previous Year" calculation would only have a TRUE or FALSE value, because the calculation expression is a logical operation. Shouldn't your "Previous Year" calculation be just the…

While I didn't try recently, and definitely not in OAC, in older OBIEE the syntax VALUEOF(NQ_SESSION.USER) was used in the "Execute before query" of the connection pool. My guess would be: is it possible that your query is executed before the user is even connected? Is your connection pool really establishing a connection…

Thank you @Farivar Javanbakhti-Oracle for this spotlight, and thank you everybody else who commented above (and below, planning for the future :D ). Let's keep making this community alive and push the products being better known and give them some extra love, from both sides: users and Oracle.

Sounds like you have permissions issues if you can't see things where they are meant to be. Check in DV > Console > Content (or Content Management), there you should see the existance of the connection, and also see who is the owner. If there as well you have no control on it, ask the owner to set permission correctly to…

I can only agree with you … In "classic" the language (the XML) already accepted complex expressions 10 years ago, but the GUI never allowed to generate them. I imagine there are good chances the same applies to DV workbooks, but you also can't tell your users to edit the JSON of the workbook to write expressions manually…