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.

More than "migrate" users and groups, you have to create them in Oracle Cloud. Because OAS doesn't allows you to have local users and groups, it does integrate with the cloud identity provider. That's a different topic (it's outside OAC, just like users and groups are outside OAS). The whole security part could be tricky…

In Oracle Analytics the data isn't stored inside the visualization, therefore you can move your DV objects using the documented processes (BAR export in OAS and BAR import in OAC) and you can then change the connection details in OAC to point to your on-premises databases if needed. Of course you will need to handle the,…

Yes you can. What you generally do is to define them as 2 different physical databases (so not 2 connection pools in the same physical database), define the joins as you need (you can join objects of different databases) and then you unify them into a single logical model. Or in your case, just grant access to the same…

ODI isn't an Oracle Analytics product, it isn't covered by this forum. Currently ODI is covered in the generic "Analytics Software" in a parallel forum:

Is your question about standalone ODI or is it part of a package of products including ODI, like OBIA?

What kind of data source? In what part of the product?

Hi, first and second report both has receipt date filter which is coming from different fact tables Does this mean that the "receipt date" in your 2 reports are technically 2 different presentation columns? Even if both have maybe the same name and the same meaning, they do have 2 different logical columns behind? If…

Well … that's a strange priority: I would focus first in helping users and after in trying to get them set a user. And in the end, you are free to use any name you want, so even a random one works. But well … I really don't know how/where you can change your display name, mine was set already before they did deploy these…