Isn't this something you should ask in the OEM category? Because OBIEE or BIP will just let you report on whatever source you have. But they will not give you any default source with system metrics like what you ask for. Therefore it sounds more like your question goes down to the source of the metrics and how to get…

The grand total is an automated aggregation of all your row, if you remove a row (by filtering) it will be impacted. Because what you try to do isn't natural (seeing some rows and one last called "grand total" but mismatching numbers is something that luckily the tool doesn't do automatically), you have to add a grand…

While not directly related to your request, knowing that OAS doesn't have any support for Solaris SPARC, you should also consider the future of your tool more in general. At some point support for OBIEE will be over (almost 2 years since the first release of OAS 5.5), and at that point you will maybe need to consider…

We are back to what has been said in the previous threads: a dashboard doesn't have any logic or formula. A dashboard page only has references to one or many analysis. Therefore, if you want to calculate a sum between 2 numbers, it must be into an analysis. There is really no logic in a dashboard page: it only display…

(from another thread you opened) By the way, you have a bunch of open thread without any feedback, you should consider taking 5 minutes to go back there and check if you got what you looked for and close threads if needed (because remember this is a community forum: you take and you give, you closing threads is part of…

Add a "SUM()" around all that and you should be good. A column can be referenced as "table name"."column name" or "subject area"."table name"."column name", both will work. So try with: SUM( "Payables Payments - Disbursements Real Time"."- Invoice Installment Amounts"."Payment Amount" )

I would have said that something named "payment amount" would be set as a measure with an aggregation and the tool would automatically aggregate into a single row (assuming every other column has exactly identical values). If "payment amount" isn't a measure already, try editing that column formula (in your analysis) and…

You were really close ;-) The "BY" goes inside the brackets. RANK("table"."column" BY "table"."column") , you should always use the "table"."column" syntax to reference columns in an analysis in OBIEE/OA (assuming that's the product you use as you posted in this category).

Or model your data correctly by setting the sort order column for your "month name" column in the RPD. By the way, you have a bunch of open thread without any feedback, you should consider taking 5 minutes to go back there and check if you got what you looked for and close threads if needed (because remember this is a…

Ideally you solve that in the model or the database level directly by having a view with the "current" values of your rows. You could try by adding a rank on date by ID and only keep the rows with 1. Keep in mind the pre & post aggregation filtering issue, so you could look into selection step to keep only the rows you are…

With these functions you can do what you are looking for. LOCATE(expr1, expr2): Returns the numerical position of a character string in another character string.LENGTH(expr): Returns the length, in number of characters, of a specified string. The length is returned excluding any trailing blank characters.RIGHT(expr,…

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.