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…

So did you got everything you were looking for? Maybe you can then close the thread? For now still This question is Not Answered.

Not really as ... Christian Berg wrote:You have:- Dashboard Group - Dashboard - Dashboard page - Dashboard subpageThat's it. And subpages were only introduced in 12.2.1.1 by the way. So between "Dashboard Group" and "Dashboard" you see that there isn't any group in between. Can you create your hierarchy in the web catalog?…

Does your prompt use the same column? The smaller scope of a dashboard prompt is the page itself, so if your 3 dashboard uses the same columns you must make these 3 columns different (OBIEE works on the formula representing the value of the prompt when column based, when variable prompts just uses 3 different variables).

Hi Venkat, Did you read the README.md ? They tell you exactly how to install (so what to download). Making a long story short: https://github.com/d3/d3/releases/tag/v4.3.0 (current release) and you find the link to d3.zip and there inside you can't really miss the file. To deploy D3 on your OBIEE 12c you have 2 options: A)…

Hi, That's actually the default behaviour when using a pivot view and setting the "Data Viewing" as "Fixed headers with scrolling content". I just did it on a SampleApp 506 running 11.1.1.9 and it's what happened. Now when you say : We cannot use a pivot view here and needs a solution for a normal table view. Well ... You…

Please avoid double posting OBIEE 11g - Download All/Display All of rows in Excel Now there are 2 threads will probably stay unfollowed and open forever ...