@ManojWadhwa , I didn't read the doc you posted, but if you are looking at Publisher embedding, keep an eye on this : https://community.oracle.com/products/oracleanalytics/discussion/21391/embedding-oracle-publisher-report-content-into-applications I believe that if/when an answer is provided there you could probably…

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 https://forums.oracle.com/ , https://community.oracle.com/customerconnect/ or…

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…