That's the default behaviour of a table / pivot in OBIEE : it will merge dimensions values (if the same). Just keep in mind that to be able to have OP1, OP2 etc. in a "month" column they must be a measure and not a dimension attribute...

Well, of course you lose all these things. But you can't really ask to have OP1 and OP2 acting like independent cells but be into the same cell, at some point you must chose ... All these things (drill, style etc.) happen on the cell as each cell represent a single value. STATUSJAN 16NEWOP1OP2 If you want to keep them…

So you want to use a text column as measure that you can aggregate (concatenate). Well ... depends on the physical DB as for example in Oracle you have LISTAGG and you can call it by using EVALUATE (google for that related to OBIEE and you find many examples even here in the forum).

Hi, You can easily match the "All Column" value in a presentation variable (set by a prompt) in a formula. For example with something like this: CASE IFNULL('@{my_pres_variable}{##null_value##}', '##all_cols##')WHEN '##null_value##' THEN 'nothing selected'WHEN '##all_cols##' THEN 'all columns selected'ELSE 'a value…

What are your OS and browser(s) where you have the issue? Because I already had the same and it's because of the browser and the temporary files / browser cache, so your issue actually seems to really point to the same direction ...

No need But as I don't see any other answer it means that everything is fixed now? Or do you still have the problem?

You mean restarting the client PC (where you have issues with the browser) or restarting the OBIEE server ?

Hi, For the BMM you have an utility in the Admin tool for that: For the Physical layer I would say you have to import your new table (A3 from database B) or copy/paste it from database A to database B and double check the physical joins (you will have to redefine them) and once done you can use the tool to replace the…

Hi, Do you mean the list of entries in the "Data Source" drop down list? If yes they comes from they comes from the BI Publisher administration where you can define data sources.

Hi, The simplest way is to use your hierarchy ... As you can drill down from Product A to Product B it means you have an hierarchy defined. So instead of adding a filter on the "deal amount" add the filter on the "deal amount" aggregated at the "Product A" level. With that kind of filter you will be able to drill down to…

Hi Dilek, +1 Christian, it's often a browser issue where JS stop working fine (can also be related to temporary files containing the JS code having issues). If it's a browser issue you generally "fix" it by deleting the temporary files and cache. (not really a fix, more a workaround)

Hi @yaseennawaz, Relax ... the "silly question" @Joel Acha was referring to was his own about trying on a different browser .... So breath in, breath out and ... give it a try and provide some extra bits like your OBIEE version (in detail), your browser and version and on which OS you are seeing that. Did you try to delete…

Ok, and OBIEE 11g or 12c ? Because in 11g it's OPMN managing the components, but in 12c OPMN doesn't exist anymore. So it's simpler knowing if you are on 11g or already on 12c.

Hi, Isn't it simpler if you post what you try to do and why are you trying it? Because the same answers you got some time ago on still apply ...

Sorry but .... the mails of what? Do you mean mails sent out by agents? Well .... if the service is down it sounds obvious there is nothing running able to send the mails .... If you mean a notification mail telling you that the OBIEE service is down that's what any kind of monitoring tool does ... Of course again OBIEE…

Just there In the expression builder you add your column by selecting it in the left panels and simply add your condition. Post a picture of your physical model and where are you trying to add the condition as it will make it easier to understand what happen exactly ...

It's not in BMM, it's in the physical layer ... In BMM you don't define any join expression, you just set the kind of join (inner, left / right / full outer). If you just want for a special need on your business model to join based on the condition you can also set it in the LTS itself and keep the generic join in the…

Hi, Of course you can, but you must use the "Expression Builder" and not write it directly in the Expression field of the physical join. Doing so it change the the kind of joins from Physical Foreign Key to Complex Join and will accept your extra condition on Status = 'A' .

Hi, If you uninstalled cleanly following the documentation you don't have to uninstall your database. If you uninstalled with a personal and custom process (like deleting the root folder of OBIEE) you must clean up things in the DB ...

Hi, When you change your prompt and click on "Apply" do you see the page reloading objects?