Not what you look for but ... When an analysis has the whole business logic of the company into a CASE WHEN with 52+ options and it is repeated and string operations added on top of it, I wouldn't blame OBIEE for performance. Even just adding a view in that thing would make the analysis 50 times faster (and a materialized…

3673447 wrote:Even in the instance where OBIEE 12.2.1.4 is deployed, I see that graph visualisation is missing. Sorry to disagree but it isn't an "à la carte" thing. In OBIEE 12.2.1.4 DV has the same feature for you as it has for me and anyone one else who installed it (as we aren't talking about custom plugins here). Are…

The option to add an image is there in DV in 12.2.1.4 ! Not sure why you posted a screenshot of DVD: DVD is in sync with OAC, not on-premises OBIEE. This screenshot is from a clean 12.2.1.4.0 :

I was using OAC as I don't have a 12.2.1.4 handy right now. Are you sure it isn't there in 12.2.1.4? The image visualization is a quite basic one, it's there for quite some time.

Although I understand where the "no" by Christian come from, sure you can build that kind of page in DV. By default DV has a standard rows/columns alignment like you get with sections and columns, so visually it will be similar. You have the "Image" visualization which let you pick a picture and you can add an action on…

Hi, I'm not really sure of what you are asking for: do you want sections and columns in DV? Or do you want a DV object to be able to easily add a DV project in a dashboard. DV and Answers (the classical OBIEE) are different products with different behaviour. DV doesn't work on sections and columns but more on a free-format…

Well ... I would say that's a bug in 12.2.1.3 ... This is the option to add the "All Column Values" on top of a prompt: And it is supposed to exist only with column prompts because of the special behaviour of this being a keyword and not the actual full list of values. I don't have 12.2.1.3 to test right now, I'm using a…

Did you try by adding this instead: "Department Hierarchy"."LOB Name" <> 'Corporate Affairs 11111' ? As you set your "Department (Previous) Hierarchy"."Previous LOB Name" value in the FILTER just hardcode the same value once more If you still have an error, would be good to post the error (as it could come from your model…

Your 2 prompts are the same exact one? They aren't ... The "All Column Values" is an option existing only on column prompt, as soon as your prompt is of a different kind (variable prompt either with manually provided values or LSQL based values) it doesn't exist. "All Column Values" isn't a list of all the possible values…

Could you post some details on how you resolved it? It's a community forum, where people share knowledge to help others. What worked for you in solving your issue could help others finding this thread and having the same problem. Post some info on how it has been solved and mark it as being the correct answer.

Your post is confusing: you installed ODI 12c on Windows and you say you configures OBIEE 12c. Are you talking about ODI or OBIEE? Keep in mind OBIEE is a client-server application: the server can be on any environment, linux or windows, and it doesn't change the features available. If your clients are on Windows you can…

I would look more into jQuery, things like https://jsfiddle.net/awolf2904/pmgn1too/ or one of the various other links returned by Google. That's a purely visual thing done on the fly by the browser. If you want to edit formulas of your columns to add that logic it will be quite messy.

Really not cool to delete part of the thread (with the related reply by cascade effect) and edit the main post to make it look "better". But I see it's common practice to ask people to do your work and send you the final document with all the steps and screen shots once the research and doc reading has been done for you…

Normal styles and fake custom styles (in Administration > Manage Themes) aren't supposed to be mixed. The admin page will generate a partial fake style in the catalog. If you do proper custom styles you don't touch the admin page, if you use the admin page, good luck in guessing what the result will be.

Use MONTH instead of MONTHNAME and add '0' padding in front for months before October. What happen is not an issue, it's simple logic: you have a string and if you sort it A come before J, the fact that A is for April and J for January doesn't matter. A string is a string. You need to either keep the sort column in a date…

Just giving you a hint (as it make little sense to copy/paste a piece of code without understanding it...). $(function() { $("#dashboard_page_0_tab").parent().parent().children().each(function(i) { $(this).css("background-color", "red"); //console.log(i); switch(i) { case 0: // first tab $(this).css("background-color",…

afb86a01-119f-4e75-b10a-e20095835f3f wrote:I want to change only to particular dashboard like Supply chain and not for entire dashboard . That's a bit confusing: you want to change things for a particular dashboard but not the entire dashboard? So you want those colors to be visible only when on a given page of your…

Good to know. Keeping it simple is the best way to go, and at least you are on the latest version currently supported, so all good for future updates etc.

Double post with OBIEE 12c Prompt Format change , close one of the two to not have 2 threads which will end up unfollowed (as you also hardly close threads).

The content of the file doesn't matter if the file isn't loaded. That's the piece you need to debug and fix first of all.