Sure. Thanks for the tip.

Thanks again Cesar! It looks like we might be able to do something similar to the first option for our solution. Thanks for sharing the information. Cheers.

Hi Cesar, Thank you kindly for the detailed answer. We had recommended a table similar to what your are describing above to be built but that solution was turned down. The concern is that the data level security should be defined within Essbase only and maintained within Essbase. We would like to utilize SSO in the Essbase…

So I discovered that if you rename the essbase cube in the physical layer you wont see the option "convert measure dimension to flat measures." So, yeah, don't change the name

Thanks for the link Christian. Luckily for me, the cubes have already been built and for now I just need to consume them in OBIEE. So far, so good.

Lol. Thanks Christian. This is my first rodeo with Essbase as a source so I guess I'll have to learn it on the fly. Cheers

Thanks Gianni, Is there a specific feature that you can enable with the cube so you don't need to references dims that are not used. Cheers