As said in your other thread, a dashboard doesn't have any content. It only has links to analysis and display a view of that analysis based on the settings you define. You want to change these things? Edit the analysis that are doing the real work of retrieving data and add a filter there to remove results if 0 and change…

You already had a new thread open (after posting in that old one): https://community.oracle.com/tech/apps-infra/discussion/4493301/an-error-occurred-while-writing-to-the-server-please-check-to-make-sure-you-have-entered-appropriat#latest Close one of the 2 new and keep only a single one open. When you have a question, like…

A dashboard doesn't contain any logic (let's ignore conditionally display sections etc.), it only links to analysis. You already know how to use formulas in analysis (your previous threads). So job done: add the needed analysis to the dashboard where you need it.

https://community.oracle.com/tech/apps-infra/discussion/comment/16821002#Comment_16821002 Double posting is against the rules of the forum and against the netiquette (yes, it's still a thing). As Christian said: this is a community forum. People are here on their own time and aren't paid. Posting twice is often a sign that…

But when I drop it under 'Table prompt', it didn't give any option for Month Jan or Year 2022. So I was wondering if I did anything wrong. You didn't say a word about how you did it exactly, so difficult to say... A random guess, because you have some 2022 data is that yes, you did something wrong.

Seeing things from a different point of view: you want to upgrade your database from 12c to 19c, so why not upgrading OBIEE as well? (I mean in general, there is no reason to stay on a old unsupported OBIEE as that's probably the reason you are moving your DB to 19c.) OBIEE deserves as much love as your database ;-)

Do you have any data for January 2022? OBIEE doesn't generate rows (except if you really trick it into doing it), it applies functions to your existing data. And if you have data for 2022, like for everything else logs exists: look at the generated queries and find why 2022 doesn't exist there and fix as needed.

Hi @User_EGB2F , It seems like you moved on to something else with your other questions. You maybe want to review the rules of the forum and learn how to close threads and mark replies as required if they did work for you. Right now you are expressing lot of "requests", but not giving a single input back to the forum. Keep…

Did you try the documentation? As you don't really have a question, the doc covers how to start and use the tools.

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…