Oracle Analytics Cloud and Server

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

Level Base measure in OBIEE

Received Response
1
Views
1
Comments
993000
993000 Rank 4 - Community Specialist

HI All ,

I am having one doubt on level based measure in OBIEE i.e If I created the Level based measure on on measure column against to Year level.suppose If I use the same level based measure value which is calculated at year level with month column in the report what will be results and how it will display .could you please help us .

Thanks

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Since it's a level-based measure on the "Year" level the yearly measure value will repeat per month

    Mth     Rev     Yrly Rev

    Jan     10     100

    Feb     15     100

    Mar     5          100

    etc