Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Level Based Measure Issue

Received Response
1
Views
1
Comments
User_BX73H
User_BX73H Rank 1 - Community Starter
edited Aug 13, 2024 5:55PM in Oracle Analytics Cloud and Server

Hi,

I have created a level based measure . When I create a report by including the level based measures and other dimension (Dimension not pinned at the content level),

it creates a query with group by the dimension selected. is it that when ever we create level based measure we have to include the dimension member against which it

is pinned at the content level.

My requirement is that whenever we select the level based measure , it should create a seperate query with group by dimension member with which it is pinned at the content level.

Is there any setting I need to add.

Thanks.

Answers

  • Martin van Donselaar
    Martin van Donselaar Rank 6 - Analytics Lead

    Not sure what you want exactly

    A level Based Measure always returns data at the grain (level) that you set it to.

    Example of how your report will look like where Sales by region is a level based measure:

    pastedImage_1.png

    Sales By region is summed by region (Oracle usually uses analytical functions to calculate this). That is what you want, isn't it?