You are most welcome!

Also - if this 'Bombay mix' grouping is a genuine corporate business need (sic) then I would create it as a new dimension in the business model / presentation layers and keep the case logic in the rpd.

I am not following your precise requirement either, but if hierarchical columns is not what you are looking for with its asymmetric 'drilling' then possibly you might want to look into using 'Bins' or case logic to create groupings for your purpose, and have the custom grouped analysis as the target of your drill.

Yes, that is the right place.

Apologies and points not needed but appreciated. It can get you down trying to help people who don't have the courtesy to reply, but this was more a general observation at an ongoing trend with newbies rather than a specific complaint aimed at you. All of that is a poor attempt at me saying 'sorry', hope no offence was…

Thanks Christian and Martin for the words in support I fear though that we may again be preaching to the converted as 'Skull' has not acknowledged our input... I think I am now #3 of #3 for replying and no answer, mark, or signs of life from the asker...

Martins answer +1. Also, try not to use views, I have seen too many OBIEE implementations where people used to databases quickly latch onto opaque view as the solution to everything. The same is true of people who have migrated from discoverer, where sql folders become prevalent. The truth is opaque view will not be as…

I don't think I have long enough to go into the why of it, the list is lamentably too long by a country mile...

You might want to give this a look -> https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/1988357_1.htm… Not sure if it is the latest version, I am not the biggest fan of OBIA...

Okay, breaking it down, do you have a Previous Month Measure in your rpd, if so you are using that to calculate month - previous month, if not then you first need to create the equivalent (look into AGO functionality) and then apply that to three columns. My logic in the first post is basically explaining how to do it for…

Create a formula based column as; month - previous month (full syntax from the formula browser, I usually copy one column and then just minus the other by copying its formula in) Create a conditional format based on this column which changes the format on the other column based on the value <=0 >0 (or whatever) Hide the…

In all things licensing talk to your Oracle Account Manager. But - I have never been aware of anyone being asked to pay separate license fees for the use of java with OBIEE, I am not a java specialist but I was under the impression that it was only J2EE territory where licensing considerations apply with java.

Posted twice and both times in the wrong space, try moving your post here instead; -

Geoff's suggestion is exactly how it has been done on many, many projects. The only other way I have seen it done is more database-centric and relies on you have access to the underlying DBs so you can store all of the environment specific data that way. Finally, some like to apply the environment specific stuff as a patch…

Hi, if all things are the same then the result should be the same, whatever is different must be the worth exploring, and really do not see how the problem can be at the OBIEE end...

Comedy gold the both of you...

For me, others may see it otherwise, Writeback stands out as the single most disappointing feature of OBIEE. I remember the original literature back in 10g days, then the implementation, very limited. It is useful for very limited requirements, like writing back free text comments for things like variance analysis, but any…

Sure, look at the rights that the OBIEE user has on the folder / file in question.

The syntax is no different to a stand insert statement, hence as Christian rightfully says you can reference OBIEE variables (for the user) and database variables sysdate or the local equivalent in the db you are writing back into. Don't make the mistake of trying to build full form functionality with writeback, if you…

Amen!