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.

That's a different topic, the original question was about add the piece of CSS to have icons available. There are ways to customize a font and now that in 12c everything is by default HTML5 instead of flash you are supposed to be able to easily adapt the font of charts etc. You can of course ask Oracle to add this "basic…

Well, were you expecting something different? The idea of a customisation is that it's different / custom for your own needs, and you can't expect Oracle to try and document all the possible customization as, OBIEE being a web app, there is an infinite number of customisation. In the doc Oracle tell you in a generic way…

A Pangul wrote:It is similar to standard funnel except that the target values of all the stages before the last is calculated based on the last stage target value and a constant called target factor. That's what we already said and all agreed about, the point is what is the "constant called target factor" and where does it…

Hi, Apparently based on the doc there is a constant coming into the calculation: Last-Stage Only:Uses a standard shape with equal stage widths. It is similar to standard funnel except that the target values of all the stages before the last is calculated based on the last stage target value and a constant called target…

As now you are the 2 versions depending of where the error comes from it's up to you to do the next step. 986359 wrote:... then report errors out. Post the error and/or a screenshot of the error.

Hi, You mean the OBIEE error of the varchar being bigger than 4000 ? (Just to be sure it's not your DB returning a ORA-xxxxx error) OBIEE has varchars up to 4000 and from an analytical point of view it's generally big enough. Some historical workarounds I saw around was to split the longer column into many columns of 4000…