When you write a formula involving a measure OBIEE keeps the resulting column as a "measure" type, so that's the expect behaviour if, has OP said, the calculation is done on measures. And obviously the totals being the same measures at a different level the calculation of this column still apply there. My question would…

What Joel posted perfectly works based on what you described in a standard context. If it isn't working for you it's time to do an effort: invest more time in the question, posting all the relevant bits to allows people to give you possible solutions because right now it's 20% of info given and 80% of guessing... Remember…

Not what you look for but ... Restarting a tool like OBIEE on schedule (weekends or every day) is often the workaround for another issue. It is generally better to fix the source issue as OBIEE is meant to run forever (or till the next patch / upgrade).

I would say the question is not if OBIEE still work, it's more if it's supported. Because even if it works, the day you have an issue you are alone: Oracle will tell you that you are not having a certified environment and therefore you can't say the issue is OBIEE. Only possible exception is if you talk only for dev…

If your set it as "system-wide" it isn't user-level, but system-wise. Everybody using the system will get that setting! (that's why "system-wide" settings could be dangerous )

That's the difference ... You talked about RANK and with the RANK() function it works as said above: you set the aggregation at "none" and no value in the grand total row. TOPN() has a different behaviour. If you use RANK() and add a filter on it to be <= 10 doesn't it give you the same result but without a number in the…

The answer is slightly disappointing (I'm not sure if Google is really not able to follow a standard in Gmail, and I bet there are standards defining how things are encoded, named, formatted). I imagine you can still download the file from your browser and rename it to get rid of the space added to the extension. It just…

I have a docker image which deploy a custom style on top of OBIEE, and those are definitely tasks which needs to be performed after OBIEE is configured and therefore inside the container. The image simple take care of knowing it must do something. In case you want an alternative image you can also have a look at…

What is the formula of your "Rank" column? (I believe there isn't nothing confidential there inside) That analysis is a simple one, right? No union or things like that? What exact version of OBIEE 12c are you using? (in case it behaves differently yours from mine, that cold also be something to look into)

Could you please post all the details? As you see me guessing what you don't say and you are (hopefully) doing doesn't seem to work. Remember we don't see your screen, we have no idea what your analysis is like and therefore it's difficult to figure out if you are doing something special or what else.

Set the "Aggregation Rule" for the 'Rank' column to "none".

Damn those DBAs not willing to share a temporary DBA account I have no idea why you get the issue, actually my install was fully automated as it's inside a Docker container. Here is the commands in the order they were called (the 2 ZIP archives are located in /opt/oracle/install ) : cd /opt/oracle/install unzip…

Did a silent install of 12.2.1.4 on OEL 7 just yesterday and it worked by itself. Did you get the binaries from e-Delivery or https://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/default-4441820.html ?

You could get that info from Usage Tracking, would be the most precise and custom tailored per user way to have a list of recent objects the user looked at. UT being a table in the database make it super easy to use.

It's quite vague your description of what changes you did. First it looks like that registry only has OBIEE 12.2.1.3 and error correction support for that version ended April 2019. Weird that Oracle doesn't have a 12.2.1.4 image if that was a really officially supported registry ... Keep in mind that the image is probable…

I guess this is somehow linked to a previous thread which was about how to filter page Y based on analysis in page X. OBIEE always try to be as smart as possible, optimizing the query as much as it can. Till where you see the filter on analysis page #2? When does it disappear? It's possible that OBIEE believe the result…

You can open a SR asking for a patch for AIX for the issue. As it's around for quite some time and you had the same issue on 12.2.1.4 which is the currently last version and totally supported they will maybe be able to do something more "acceptable" than renaming everything to remove special characters.

Is that the real name of the analysis? "Analysis Name ĄĘ.pdf" ? I guess I had the case some years ago where the issue happened with objects having special characters into their name, in your case the "ĄĘ" would be the special character. Can you just try to have a simpler name without any special character and see if the…

So it's time to go back to Post all the details about the context, the environment, the tool (exact version including bundle patches) etc. And also what's your database behind that model.

Something like this: TIMESTAMPADD(SQL_TSI_DAY, CAST(RIGHT('19087', 3) as INT), TO_DATETIME('20' || LEFT('19087', 2) || '-01-01', 'yyyy-mm-dd')) But ideally you must have a proper time dimension giving you various formats representing the dates based on your needs.