OBIEE 11g & Essbase Integration — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 11g & Essbase Integration

Received Response
1
Views
2
Comments
1977947
1977947 Rank 3 - Community Apprentice

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.

Answers

  • green4x
    green4x Rank 1 - Community Starter

    Hi.

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

    vSd7GeS.png

  • 1977947
    1977947 Rank 3 - Community Apprentice

    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