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.

As P G said, it's like that since 11.1.1.9 ... Consider renaming in the BMM layer instead if possible.

Hi, I will say that as long as you pay attention to not have any port conflict (setting different port ranges during config) you can install multiple independent OBIEE, they are not going to be aware that other OBIEE are there ... So different install folder, different ports and different RCU schemas, not a problem (as…

Would help if you tell what tool is your source and where do you try to get it (normal OBIEE, OBIA etc.)...

The total value will change, and this is why your RANK() approach will not work if you add accounts. But are you going to change the label of the total account as well? If the answer is yes then you need something else like an attribute you don't display but which is related to the accounts and identify the various kind of…

Ok, so ... think SQL In a IN condition (https://docs.oracle.com/cd/B19306_01/server.102/b14200/conditions013.htm ) you must have an expression list (a "static" list of values separated by " , " ) or a subquery. In your case you mixed them. The subquery return values in rows, so if you want your month to be "Jul", "Aug",…

Asim already went on a better way to do that. Ideally your time dimension has the required columns to not have to deal with textual months matching. Other than that you say you want to filter but post a SELECT ... FROM piece of code, not really sure what you really try to do. (A filter is a condition in a WHERE statement…

Why don't you simply use as condition the values of your first column? "TOTAL POSTPAID - Consumer Gross Revenue" will always have the same name while ranking can easily change by adding a new account / kind of revenue.