Not being that Øyvind but knowing which Øyvind Christian meant :P It looks like various MOS documents about BVT have disappeared. BVT wasn't working anymore on most recent versions of OAC/OAS, so maybe they did drop documents to stop people asking why it wasn't working? I did open an idea in the CCC node asking for BVT to…

https://community.oracle.com/tech/apps-infra/discussion/comment/16820037#Comment_16820037 The documents exists in MOS (linked above). If you don't have a valid support contract, you can't access MOS content. In that case all you have is the public blog post (linked above as well).

https://community.oracle.com/tech/apps-infra/discussion/comment/16819675#Comment_16819675 How can it not work? What did you do to debug the thing? It does work out of the box in OBIEE. If it doesn't work it's because you are asking this but try to do something else (XY Problem) or your environment is totally weird and…

https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/understand-diagnostic-log-files-and-log-configuration-files.html#GUID-1CA255BF-F32A-4C6E-85D6-916392249811 DV should log in the BI Server folder, can't remember if same log files as OBIS or different file there inside.

Ok, so I will skip all the usual speech about how old and unsupported that version is (but feel free to tell to whoever is managing that internally that an upgrade would be welcome!). If you have a column with names, by default you will see the duplicate entries because without any aggregation rule all the rows are…

DV error messages are often very generic, if you check log files you will maybe find a more detailed error and you will easily see what DV isn't happy with.

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…