Taking your own reasoning a step further: what does force users to use your special template with the "sensitive" messages all around? It sounds more like you are trying to solve a human problem in a technical way: educate your users, teach them about data sensitivity, about the rules on sharing or using that information…

https://community.oracle.com/tech/apps-infra/discussion/comment/16816506#Comment_16816506 I struggle to imagine how watermarking on a dataset could look like. How about you add a new column to your sensitive tables (database and/or logical in the RPD) with the value 'sensitive' in it? That sounds like watermarking a…

Look at the AGO() time series function in OBIEE. If you did model your time dimension correctly, it will do the job. If you don't have a proper time dimension in the RPD, you should start there.

I don't remember parameters out of the top of my head, did you check the logs? Agents logs all these things.

And what is OBIEE supposed to do with your XML? If you have a Publisher data model, why don't you just create a report on top in Publisher directly? Publisher can use the BI Server as a data source because it can be accessed "as a database", the other way round not much: OBIEE use the RPD, BI Publisher isn't a physical…

Not a single prerequisite should be ignored. If you ignore them, it's your own responsibility and if something doesn't work you can't expect any help from Oracle. Did you go through the documentation (or just the screenshot you posted, it has the checks that failed)? They gives the list of minimum required packaged for the…

Hi, I assume by "delivered" you mean via email. In this case you should ask the question to your SMTP server administrator. OBIEE can generate files of tens, hundreds of Mb, but mail server generally have a limit at about 10-20Mb for attachments, or even less.

That's the one, FMW and right version.

If it isn't confusing, it isn't Oracle and you aren't downloading the right product 😁 This page send you to https://www.oracle.com/middleware/technologies/fusionmiddleware-downloads.html From there they send you around a bit in the most confusing possible way, till at some point you get on…

Go back to the installation documentation, the certification and the download page: OAS 5.9 requires FMW 12.2.1.4, your 14.1.1.0.0 install is useless for OAS. Install the correct FMW and the problems will disappear. FMW is not swappable with a newer version just like that, the dependency is strict: OAS 5.9 <=> FMW 12.2.1.4

https://community.oracle.com/tech/apps-infra/discussion/4491344/where-does-the-oracle-analytics-server-saves-the-uploaded-files Who said they were stored as files in a filesystem? There is (was?) a webservice that has a limited set of features for datasets (your file isn't a file anymore, it is a dataset), it wasn't much…

Well, your title says "BI Answers" and DV is a different product in the end, even if it still relies on the BI Server to get data out. It could depends on many things: what you workbook is based on, how is the dataset defined etc. As DV doesn't have an explicit definition of measures and attributes it is a bit more tricky…

So you would like to have a text column as a measure with an aggregation (because the amount will automatically aggregating assuming it's a measure and not an attribute). If your source is an Oracle Database you can use the LISTAGG function and call it from your analysis by using evaluate and defining all you need there…

Yes, maybe, no: it depends ... Define "merge or combine multiple rows into one row".

Turn all your amounts other than the pre-payment into negative numbers and RSUM will work just fine. PS: as an Oracle employee you should setup your forum profile following the internal rules/policies (appending the "-Oracle" to the screen name etc.)

If your analysis 2 filters based on the results of 1, doesn't it shows only order # 1-5? What you are asking does sound, to me at least, more like a logical / functional dependence than what "based on results of another analysis" is, which is a real WHERE condition in the query. And as any WHERE condition, it limits the…

Well, it probably depends a lot on what and how you are doing exactly. Maybe take a step (or a few) back to get a global view of what you did, what you would like to do and how you could get there. The RPD does work well for more than 10 years, but it's quite "unique" when starting with it... PS: you should also go over…

If the data is the same, why don't you just change your connection pool in the physical layer to point to your ADW instead? If tables have to be renamed, you rename them once (only the "real" physical tables needs to be renamed, aliases will point there). The same for schemas: one rename and job done, any business model…

What is "last viewed dates" supposed to be? Usage Tracking has dates on every single row, select MAX on the date and group by analysis and you get a last executed date. Of course here it's just like for the users: you need to have Usage Tracking enabled for a while before to consider the data as safe to be used. Every…

Keeping it short... no