As Krishna said it's not doable ... the setting is "always" or "never" (ok, on mouse over).

Not saying Windows 7 isn't a valid OS for your desktop daily work... (and there is also still some form of support for it by Microsoft). But the first and most important thing: OBIEE isn't a desktop application, it is a enterprise level server software. So just this explain why there is no effort to officially support a…

Hi, Did you do some analysis to make sure you aren't getting negative or zero data back? When you do an upgrade in OBIEE you maybe don't touch anything but the tool start generating queries in a different way and return you data in a different way. So I would say to first add a table view to display the values and so you…

Hi, OBIEE is not really the place where to do data cleansing because OBIEE doesn't store data ... So the cleansing process is done again and again each time to run an analysis. As Joel said would also help if you give some extra pieces of information ... I assume you maybe means you get data that are received as varchar…

Hi, Actually you are installing on a OS not officially supported, so if it doesn't work it is not shocking .... Difficult to know if you are supposed to be able to install OBIEE 12c on a Windows 7 because a) it's a desktop OS b) it's a "old" OS c) it isn't supported ....

This evening I'm (you are) lucky: https://blogs.oracle.com/proactivesupportEPM/entry/km_doc_how_to_change

Hi, There is a MOS document about how to uninstall Essbase in OBIEE 11g, and there is an Oracle blog post pointing to a MOS document on how to change passwords (all the password) so that your Essbase will work just fine. Just trying to find the link to the second one (so you can finish changing the password in the places…

Well, it will be a cool task for sure From 11.1.1.7 to 11.1.1.9 is still a migration, there are things that will stop working maybe and things that are going to work in a different way. So it's not just about "copy/paste the RPD and reports" from one to the other and done.

As the original topic of the thread is covered, anything else or you can maybe close the thread? For now it's still This question is Not Answered. For the email I avoid posting it to limit spam...

OBIEE 12c is certified for RHEL7 (look the details in the certification matrix Oracle Fusion Middleware Supported System Configurations ). A migration from OBIEE 11g to OBIEE 12c is possible but it's not a "next, next, finish" job. There are many changes in the platform and some of your reports will maybe not work or work…

Hi, The certification matrix for OBIEE 11.1.1.7 doesn't cover RHEL7 just because it didn't exist back in 2013 when 11.1.1.7 was released. I guess I saw RHEL7 in the OBIEE 11.1.1.9 certification matrix, so maybe time to start thinking about upgrading? (to 11.1.1.9 or 12c)

So you must use the "Descriptor ID" functionality @Christian Berg mentioned in the first reply. That's how OBIEE manage that situation. Configuring columns in the right way in the business model by setting descriptor id and sort columns is one of the activity required once when building the RPD and giving you access to…

I of course agree with @Andrew Fomin. , @rmoff and @Thomas Dodds on the main concept. But still curious about something: how many pages does your dashboard have? (so how many values/entries in your prompt?) If you answer < 8-10 then go back to what the people mentioned above posted. If you have > 20 then I can at least see…

Ok, so few more questions: was it always as slow or changed lately? Something happened/changed on the weblogic config or on the AD side? Is cache set properly? The "use filter" I guess it's maybe more an on-screen filter, but it still retrieve all the users first and display only some (didn't test to validate this point,…

So I would bet the time you wait is weblogic querying the corporate active directory for any possible user existing there... Ideally you must try to define active directory authentication provider with filters as close as possible to the list of users you are supposed to have in your system and not query everybody from…

Hi Dilek, What are your authentication providers? I suspect you aren't only using the embedded LDAP but maybe connected to a corporate LDAP or something like that?

Something like: CAST(LEFT('@{your_variable}', LOCATE(',', '@{your_variable}')-1) as INTEGER) If your variable isn't always in the format " number, ..." this formula will return you an error because the 2nd attribute of LEFT must be greater than 0, so if your data can be in a different format you must manage that with a…

There is one thing we didn't asked you ... Does your physical source (or a logical column formula on the RPD) generate the "7, It's fashion" value? So you really have things like "7, It's fashion" stored in your source and want to only get the number out of it? (in this case 7) If that's the case you don't have tons of…

Descriptor Id columns are there in 11g, they weren't in 10g (can't confirm if only in 11.1.1.7 and after or directly in the first 11g release, can't remember). The link @Christian Berg posted is about 11g. So if you don't see that part of the options on your column prompt it's maybe because your column doesn't have a…

Hi, Not sure I got exactly what you look for... If you want to "validate" the values entered by users into a text prompt (saving into a variable) I would use conditions to display a section in your dashboard page with the error messages based on values or the real analysis in case the value is fine. So you make an analysis…