OBIEE 11g & Essbase Integration

Question

I am integrating Essbasse with BI. In the physical layer, I tried to convert measure dimension to flat measures. But when I right clicked my Essbase cube I am unable to find the

convert measure dimension to flat measures option My BI machine version is 11.1.1.7.

I have also tried changing the following in the dimensions first for Accounts and then for Scenario as follows:

Dimension Type: Measure

Hierarchy Type: Value

Even when I do this I do not see the option for convert measure dimension to flat measures when I right click on the cube.

Thanks in advance.

1977947 · Answer

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

green4x · Answer

Hi.

Do you mean that clicking on a cube table (not on catalog for cube) you don't see the option?