https://community.oracle.com/tech/apps-infra/discussion/comment/16819293#Comment_16819293 The key point of Christian's reply is: you aren't writing a query or a view in your database, you are writing an expression in OBIEE. You should speak the OBIEE language as much as possible, or you are just wasting the money you spent…

What Christian said, or ... simple logic: what does the piece of code you posted do in your database? It's extremely simple and you can get the same result with some logical conditions and using '>' or '<' .

@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