Hi, Isn't this a generic question about Oracle Cloud and not at all related to Oracle Analytics? This forum is only for the Oracle Analytics product (Cloud, Server, OBIEE etc.). For generic cloud support you should either contact support or find the best category for it in the Developer Community forum…

So It is true that user should be a part of Administrator group to perform download and upload RPD. Not at all ! Please, don't ignore how security and privileges works in OBIEE (and OAS). You can grant all the required policies even to BIConsumer if you want, and your BIConsumer random users (make authenticated users part…

I know that the lightweight SSO changed from not existing at all, to being there but not enabled by default to enabled by default. A similar example to what you say is: "I want Internet Explorer as browser, and it's there by default in my Windows 7. Now I updated to Windows 10 and it isn't there anymore. How can I have…

@ManojWadhwa , I didn't read the doc you posted, but if you are looking at Publisher embedding, keep an eye on this : I believe that if/when an answer is provided there you could probably benefit from it.

And that's why everybody love Excel : it comes with its own logic, but because of the number of users, it is always right 😁 Not like databases or any other type of files where data types exists and are a real thing 🙄

 it's working fine now While it is working, and it was working before, it's technically not supported (there are many things that works in the product while not being officially supported). Therefore it's a risk still to use that. There are other ways, official ways, to track users, sessions etc. Consider planning to…

@Ambient , possible! It's one of those Excel things that would deserve a test (or to search to confirm it), I just remember it is from 1900, just to annoy everybody having to handle it :D But OP should easily know if his dates are off by 1 day or not.

In this case, there is nothing that can be done on "text to date" conversion, because the data is not a date at all. This is an example of the data: the first column is the "date". In Excel, those numbers can be turned into dates visually, just telling Excel that the column is supposed to be formatted as a date. But…

I mean real SSO, I don't talk about the lightweight SSO that is in OBIEE to allow to switch from DV to "classic" without being prompted for a login. If you were embedding content by using an iframe and calling the URL passing the username/password in the url (nqUser and nqPassword), that's not really how embedding is…

Do you have SSO setup in your OBIEE 12.2.1.4? If not, being prompted for credentials is the expected behavior.

Ok, I had to give it a try to find out what was going on. I call it a bug: the function exists, the formula is valid, but still it doesn't work. The workaround is to use a TIMESTAMP instead of a date: TIMESTAMPADD(SQL_TSI_DAY, "LAST_UPDATE_DATE", TIMESTAMP '1900-01-01 00:00:00') If you are motivated to raise an SR to…

I would say the issue could be a circular reference: you are redefining the formula for "LAST_UPDATE_DATE" to be a formula referencing "LAST_UPDATE_DATE". Add a new column with the formula, you can keep your "LAST_UPDATE_DATE" as a number if you want, but it's pointless (so you can hide it), and then you have a new column…

You should write DATE '1900-01-01' , the word "DATE" is important because it's a casting of the text following as a date. As an alternative you can do an explicit casting with the CAST function or use the TO_DATETIME function to generate a date. And technically there can't be the equivalent to Excel with dates as numbers,…

If your source is a CSV file, there is not an issue, it works as it should. CSV doesn't have data types, it's text or number. You can tell Excel to convert a number to a date, but it was (and still is) a number and it's Excel doing the conversion. Being a number, you can't turn it into a date just by trying a cast or a…

Apparently it has been published after the first post: it wasn't there, didn't exist, but it is there now.

Does the document really exist? Is it public?

What sources are you using for your DV workbooks? If they do use subject areas, then you will have the RPD in both places. You don't really have many choices anyway and it's quite easy: do you need to use your subject areas as sources in DV? Then you need to deploy your RPD in OAC as well, adapting all the connections to…

The "owner" was already having that special feature of bypassing some security. But sometime that's not what you want: folders have owners that should stay owners. And when the catalog was still on disk (before OAS), it was very easy to just set the needed permissions with catalog manager (GUI or command line) in offline…

It's technically "impossible". The RPD is deployed on the product: if you are using OAC the RPD is deployed inside OAC in the cloud. But you can keep developing your RPD locally and then upload it to OAC. Or download it from OAC locally and you work on it locally (offline). You should also consider, as long as your RPD is…

Hi, This forum is only covering the Oracle Analytics products. OCI Data Integration is not an Oracle Analytics product, it is therefore not covered in this forum. Not sure where it is covered, you should try looking in , or to see if you can find a category covering that product.