@Moo+ , Isn't this the same as https://community.oracle.com/tech/apps-infra/discussion/4492284/how-can-i-merge-column-head-xml-publisher-rtf#latest ? It looks like you posted this one first in a database category (SQL/PLSQL), while the first one is in the OBIA category. If it's a duplicate of your other thread, please…

And with what Christian said, consider the impact on any existing object using that dimension: you need to plan a proper strategy for the change or be ready to have a bunch of unhappy users because their analysis don't work anymore...

Do you also enable displaying totals in the table view? (The "edit view" pencil icon of the table view)

It has to be said that his is the wrong way to do this. In OBIEE there are measures for a reason: a counting should also be a measure and by defining it as such in the RPD, OBIEE will know exactly how to generate queries. It's very difficult to know why you don't see totals, exactly for the reason that OBIEE generate…

In that case it should work if you did set the aggregation on at least one column and selected to display totals. This isn't on your same version (I believe) but should work the same way.

Hi, What are you trying to aggregate/sum into a total? From the screenshots you posted, none of your columns is a measure by default. Still by setting the aggregation rule in the column formula you let OBIEE know how that thing could be aggregated. But many of your columns looks like text more than number, so not sure what…

https://community.oracle.com/tech/apps-infra/discussion/comment/16816869#Comment_16816869 About 10 seconds: 5 to copy/paste what Christian gave you, 5 to replace one of the values with the column reference you need.

You can't change the value of a column coming from somewhere else (that's something you should do in a database), what you can do is to have a column with a formula that perform some logic and display one thing or another based on your needs. CASE WHEN in OBIEE is fairly similar in syntax as to any language having…

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…