Hi, First let me say that I have no idea of what ONS is as it's related to your DB more than OBIEE ... Could it be Weblogic and not OBIEE? Things like what https://blogs.oracle.com/weblogicserver/ons-configuration-in-wls talks about.

user2074645 wrote:I tried to put color coding with HTML tags. but no luck on it.:) You are trying to make it complicated Keep at as even your browser does it: an on-screen thing done by javascript. If you start adding code into your formulas not only you kill any action-link or other feature working on the value, but you…

You could try by redeploying the default BAR (the file must be stored somewhere in your install, search for any *.bar file). https://gerardnico.com/dat/obiee/admin/12c/bar#from_122141 Beware: this command will probably do more than just resetting the RPD, there are chances it will override and bring back to default other…

Hi, I always stay away as much as I can from OBIEE installed on Windows for ... (good) reasons Any chance you maybe have a Windows firewall bothering you or something like that? That's the thing which once annoyed me last time I installed on Windows (6+ years ago ).

Joel Acha wrote:By the way, is there any particular reason why an unsupported version of OBIEE is being installed? This maybe explain why a SR end up being posted in the forum: MOS kindly said "sorry, your system isn't supported, bye"

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…