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…

Sorry @3332985 but in that case do not spend the many K $$$ for OBIEE license and download Oracle SQL Developer for free (Actually as it's for Publisher he can directly bypass the RPD and write the query) The RPD model perfectly support outer joins and any kind of strange model, not just nice stars coming directly from the…

You simply join your new dimension as a normal dimension and in the business model you set the join between the fact and that dimension as an outer join. You can then test if the join exist or not by checking if the column of DimB is null or not and display the *.

What is your version? As there are something like 58 different versions of OBIEE around it would help if you provide it .... In 12c there is a kind tabbed visualization for the options and the checkbox is on the second tab (can't remember if it's "More" or something else the name of it).

Suppression is a left to right thing, it suppress as much as configured from left to right, but when your "Line number" column is reached it can't suppress and merge the cells of "Organisation" as they are related to different "Line number". So "Line number" stop the suppression of other columns and any other column on the…

Hi, If I get you right you are calling data-model-cmd.sh on your old OBIEE instance (12.2.1.0.0), right? Why don't you call it using the command of the new updated one? (12.2.1.2.0) The difference is that in 12.2.1.2.0 (maybe already in 12.2.1.1.0, can't remember) they renamed the script, it's now named datamodel.sh So…

Hi, You will have to give a bit more ... What value is your detail report filtered if not the one of the slider? Is the column of the slider there and set as a filter?

OBIEE has functions to locate the position of a string into another and to get a substring from a string. Just combine these 2 as much as needed to get the position of the 3 " ; " and then use substring to extract the value.