First of all you better quickly patch your environment, not just because 12.2.1.4 is quite old, but also for things like log4shell vulnerabilities. And I get that you did things in analytics.ear, but you can’t really expect anyone to tell you how to fix something if you don’t say exactly how you changed things. It’s called…

What kind of customization did you do? Because the default way to deploy a custom logo in OBIEE 12c is the logo that goes on the left instead of "Oracle". And what exact version of "OBIEE 12c" is yours? (including the bundle patch you are using as it could have an impact as well).

The other user who had the issue (it's in a MOSC forum) said he did execute this: VBoxManage setextradata "SampleAppv607p-appliance" "VBoxInternal/Devices/VMMDev/0/Config/GetHostTimeDisabled" 1 You can read a bit about a user having the same behavior you are reporting (the date switching back to the current one) and how…

You mean that one? That's the logo, if you put your company logo, you replace the old one, which is that Oracle logo. If you want Oracle and your company logo, edit your company logo to add the Oracle logo inside in the same picture.

Hi Gavin, Somebody else posted this exact issue only a week or 2 ago. The time zone doesn't matter at all (except if you can use that as argument to have your company paying you a holiday to New York? Not sure it will really work 😁), but you are on the right thing looking at the date. The VM is very old (more than 5…

The error is a database error, therefore something is wrong with your data. Isn't your agent retrieving only a subset of data that, luckily, does respect the format you expect, while the analysis as you run it is missing some filters and retrieve data not matching the format? As it's a database error it is fairly simple:…

In general you can pass parameters values for an analysis when calling the analysis itself. You can see some extra info on this on various blog posts like for example http://allaboutobiee.blogspot.com/2018/10/go-url-with-parameters-example-in-obiee.html (ignore the part about disabling SSO etc., only look at how parameters…

Hi, Can you define "OBIEE report" better? You mean a BI Publisher report? An OBIEE analysis? An OBIEE dashboard page?

You could try adding a calculated item or a new group entry. That's the only possible thing crossing my mind that could have a chance to get you closer to what you are after. But it will require to not have a filter in your criteria because that is applied before everything else and therefore will not even return the…

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,…