3808468 wrote:I wants to be use url ashttp://${SERVERNAME}.xxx.com:9502/analyticshttp://${SERVERNAME}.xxx.com:9502/VA This has no connection with the lightweight SSO. OBIEE will always have the links as /analytics and /va (I guess only OAC changed for /dv at the moment). If you enter your /analytics URL in your browser…

Why? Why do you want to turn off the lightweight SSO? Having the lightweight SSO enabled or disabled doesn't change anything other than you having to enter your login again when switching to Data Visualization.

Restarting the Weblogic deployment can be done in Weblogic Administration Console. All the deployments have controls to start/stop/restart them.

Could you maybe use Selection Steps to keep only the TopN (using a presentation variable to let your users decide the value if N) ? In this way you can remove the TopN column completely from the analysis and it will not be in the total anymore (not being a column anymore). Just randomly guessing all the possible ways to…

Here things depend on your real model in the RPD. It works fine on a a classical sample, so if your model must not be just a simple "standard" one but there are other factors to keep in mind.

Sorry but I struggle to follow ... So the thread was about not being able to install and now you ended up disabling the lightweight SSO ? Not really sure how you got there, why and what you are after all in all ...

deniska wrote:This has incorrect syntax. Just for explaining Are you writing that thing in OBIEE? (Admintool in the RPD I hope) "IF ..." doesn't exist in OBIEE the UI tells you that when you look at the list of available control expression. You need to write a CASE WHEN ... deniska wrote:I see. I can do this in Essbase…

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 ?