Well, I don't have anything come to my mind about that. But your example is simple: your fragmentation condition is based on car, boat, bike. And in your 3 tables you don't seems to have these values, so what you can do is to create a logical column for that and you assign to it a fixed (hardcode) value for each one of the…

+1 Christian And your user hasn't access to that part of the home there are chances you also don't have access to only editing of RPD, so the admin tool will not help you a lot... If you just look to open the RPD offline what there is inside you can also open it with a newer admin tool. You will not be able to reuse it if…

Hi, In theory you can do it with a presentation variable defining the forecast. If you change the formula of the forecast column to use the variable to select the right forecast column everything else must work without changing anything else. Not sure why you are trying to do a UNION report here ....

Hi, These 3 tables must not be linked together. If you link them the result would be to have the sales of cars next to the sales of boats next to the sales for motorcycles. Your case is more a multiple logical table sources using the "fragmentation" function of OBIEE to say that all the 3 tables contains sales. This one is…

Hi, No luck for that ... There is not a single permission managing that. Once you have "edit" permissions on a dashboard page you can add anything you want, all you can try to do is to limit the access to the catalog for these users, so they can't select any object from the catalog to be added to the page.

Hi, It will of course depend on how your model looks like but you can also play on hierarchies levels etc.

Well ... You can set an aggregation rule like MAX or MIN and it still return the text ;-)

As you saw it's about pieces of JS / CSS. Many posted the same questions on here and I can't remember a single one coming back to post his piece of code (if they did it). So it's up to you to get your hands into the code. (As far as I remind it isn't too complicated...)

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…