OBIEE 12c is by default an enterprise install. It isn't like in 11g when you had "simple installation" and "enterprise installation". Even not using SSO you are supposed to use an enterprise LDAP or AD, the embedded LDAP in weblogic is suggested only up to a limited number of users and mainly in a sandbox / dev setup.…

Why did you end up doing 2 different weblogic accounts in the first place? I have the impression you took the most complicated to install OBIEE instead of doing the "normal" one which is mainly few settings and some next, next, next clicks (or silent install directly). Mainly if you are new, stick with the normal way of…

Sure, CASE WHEN <condition> THEN your-column-A WHEN <condition> THEN your-column-B END. Just use a presentation variable you set in your dashboard prompt for the condition.

3698127 wrote:... Can you please let me which parameters can set performance. It isn't as simple as that: there isn't a single thing which make performance better or it would be turned ON by default. You can look at https://docs.oracle.com/middleware/1213/wls/SECMG/ldap_atn.htm#SECMG185 and also in the Tuning guide I…

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…