Like always you would need to try to identify which part is taking time. There are some caching settings in the AD config you did in weblogic, you can look into that to try to have some info cached. You can also try to define if you are working on a too high level of your AD and therefore queries take time and you maybe…

http://adminobiee-vip.saude.gov:7001/console : the local LDAP embedded in Weblogic http://adminobiee-vip.saude.gov:7001/em : Enterprise Manager where you have mappings between local users/groups and application roles

Marcelo-Tarquinio-Oracle wrote:There is a possibility to login tools without SSO, correct? Of course, by default there is no SSO in OBIEE. Or, to be precise, there is an internal lightweight SSO which is there only to have a shared session between /analytics and /va. If you can't login start from the beginning: are all the…

Data Visualization projects can't be exported in Excel, at least not the visualization as CSV is the format. So just that make your "wish" impossible. You need to keep in mind the 2 tools are quite different and if DV can use Answer as source for data, Answer doesn't do much with DV projects. Even showing a DV project into…

Boček Petr wrote:my account is set up in EM the same way and I can't run the commands How? Where the account come from? (EM isn't a LDAP) What privileges / policies does your account have?

How can the new measure you created be a row? How can that be a measure if few post ago you said "5.111", "5.112", "WAC" are the measures? That's impossible! The measure it's either your rows or your columns, it can't be both at the same time, you better figure out exactly what is what.

You can't use the automated totals/subtotals options of the pivot, because they would be on everything or nothing. Depending on what your "5.111", "5.112" and "WAC" are (measures, values of a dimension attribute etc.) you will need to add an element there with your calculation. If it's measures add a new one with the…

You covered data level security, but don't forget the whole front-end: privileges + catalog permissions. It's worth to setup everything as "clean" and restricted as possible from the beginning so that whatever happen later (like now a new part added in OBIEE or anything else) is covered by default with security already in…

You also have the privileges in the front-end. As security is in multiple places and require to be configures everywhere to be effective you maybe want to define a proper security model and strategy (which was supposed to already be implemented even for a single "project" ).…

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…