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.

Did you check the checksum of the archives? Do they match? Your linux is a supported version I guess, right?

Are you using the right file? Where did you get it from? Sometime things seem to be the same tool & version, but are actually different ... For an OBIEE install the Weblogic install file needs to be the one you find at https://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/default-4441820.html

Can you double check that you took the right file and you are doing the right kind of install? I didn't install OBIEE on Windows for the last 5-6 years, but I'm quite sure the install process is the same on windows as it is on linux globally. The weblogic install just need to know where the oracle home is going to be,…

Correcting myself after checking some install scripts I have around and based on Joel reply, which is right: when you go through that wizard, OBIEE is already installed, just not configured. Those questions are asked in the configuration of OBIEE, the step between having a bunch of files on your disk not doing anything and…