Skip to Content

Aggregation level Macros

Hi all,

Can any one explain me the logic for the below statements used in aggregation macros,

searched on SCN but looking for a detailed explanation.

AGG_LEVEL ('Characteristic') = 0

PLOBS_FOR_LEVEL(1)

Regards,

Sanjay

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 23 at 05:38 PM

    Hi Sanjay -

    AGG_LEVEL function is used to check mostly in interactive macros if a user has drilled down the selection in the planning book to a characteristic level that is maintained in the AGG_LEVEL function. This is usually used along with IF statements.

    So, if I have loaded the data in a planning book at product level and drilled down to multiple customers for this product - then, the AGG_LEVEL('CUSTOMER') = 0. If I maintained to show the data only at product level in the planning book but didn't drill down to customers (meaning, it shows Customer characteristic = Total) - the AGG_LEVEL('CUSTOMER') = 1.

    Inference: 0 represents FALSE and 1 represents TRUE.

    PLOBS_FOR_LEVEL(1) represents the number of objects that count in the level 1 aggregation. So, if you loaded the data at customer group, this function will return you the total number of customers under this customer group - this is not frequently used though.

    Hope this helps?

    Thanks,

    Regards - Guru

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 24 at 11:18 AM

    Hi Guru,

    Thanks for the detailed explanation.

    I have an issue where I loaded 4 objects to PB say product level here, when I drilled down to Detail all level I cant see all the loaded objects,some of those got hided with above logic, am confused on what condition it happened.

    Regards,

    Sanjay

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Sai, this is indeed confusing. Are you saying that you can see 4 products in your selection window and then if you load all into your planning book, and drill down from 'Total' to 'Details All' - you are not able to see those 4 products?? This is not possible by any means is all what I can say. Anyways, please detail the issue in another post if required.

      Thanks,

  • Oct 24 at 11:48 AM

    Hi Guru,

    Exactly, when I drill down from Total to Details All I can see only two out of 4

    Add comment
    10|10000 characters needed characters exceeded