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?

Actually it's you that still need to answer 2 of his questions: expected workload and the kind of reports you expect (as you have the definition in the reply of Manoj). And also keep in mind we all have a life and a work next to the forum, so having to wait a day for an answer isn't that much in the end (or the only other…

Hi Ali, For your "question2" keep answering to the thread as you have the right people on it to give you the answer (rmoff for example).

Hi, I would say that it depends, it's not really a YES or NO answer ... If you want to make analysis on your full population of customers all the time (and not miss those without transactions) creating FACT rows for all of them will make your life easier. If on the other hand you mainly do analysis on customers with…