1

Level Based Measure

Hi,

I created Level Based Measure in the report as below but am getting zero values. Can any one help me?

sum(
    EBS_AR.RA_INTERFACE_LINES_ALL.AMOUNT, 
    groupBy(
        EBS_ITEM_COMMON.ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME, 
        EBS_ITEM_COMMON.ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_CODE, 
        EBS_ONT.OE_ORDER_HEADERS_ALL.ORDER_NUMBER, 
        EBS_ITEM_COMMON.MTL_SYSTEM_ITEMS_B.DESCRIPTION, 
        EBS_ITEM_COMMON.MTL_SYSTEM_ITEMS_B.SEGMENT1, 
        EBS_AR.HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER, 
        EBS_ONT.OE_ORDER_LINES_ALL.LINE_NUMBER, 
        EBS_ONT.OE_ORDER_HEADERS_ALL.ATTRIBUTE8, 
        EBS_ONT.OE_ORDER_LINES_ALL.ACTUAL_SHIPMENT_DATE, 
        EBS_AR.RA_INTERFACE_LINES_ALL.CREATION_DATE, 
        EBS_AR.RA_INTERFACE_LINES_ALL.INTERFACE_LINE_CONTEXT, 
        EBS_AR.HZ_PARTIES.PARTY_NAME, 
        EBS_ONT.OE_ORDER_HEADERS_ALL.FLOW_STATUS_CODE, 
        EBS_AR.RA_INTERFACE_LINES_ALL.BATCH_SOURCE_NAME, 
        EBS_ONT.OE_ORDER_LINES_ALL.ORDERED_QUANTITY, 
        EBS_AR.HZ_CUST_SITE_USES_ALL.LOCATION
    )
)

Regards,

KHK.

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • @KHK -- that is some group by you have there.  There will need to be valid joins across all of those tables for this to work.  I would suggest starting with a single group by and seeing if that works and layering in from there.

    Like 1
  • Khk- one uses level based measure when you want a aggregate measure at a higher grain than what the insight is at . For eg you have country, state in grouping field and revenue as a measure field, now you want to add revenue at a country level , then you create a level based measure for that .  In your case first create a aggregate report On those fields and check the query plan and see if that works .

    Like
Like1 Follow
  • 1 Likes
  • 2 mths agoLast active
  • 2Replies
  • 21Views
  • 3 Following

Product Announcement

Incorta 4.9 is now Generally Available (GA)!!!