I am new, and not sure if i am in the correct discussion. Welcome, what product (the full name and version ideally) are you using or asking about? That's what defined if you are in the right place. If not, don't worry, somebody will move your question in the right place (so no need to post it again somewhere else).

I really meant what Christian said: "just give it a try and see what comes out" ;-) some of them have taken this "not supported" path as well, wonder if they faced serious disruptions in using their newer upgraded environments or if they managed with work arounds like patching etc.. As said earlier and by Christian too: it…

A change in OS or OS version only means out-of-place migration is required. OBIEE/OAS content is "above" the OS level, and therefore OS independent. That's why it is mandatory to use the OBIEE/OAS tools for moving content, because these tools will work above the OS level and not bring along issues related to the OS (could…

Fairly sure the doc covers this. Migrations go through the BAR: export a BAR from your 12c, import the BAR (or the pieces of it you care about) in OAS:

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…