cancel
Showing results for 
Search instead for 
Did you mean: 

Aggregation level Macros

0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

gurucharanscm
Contributor

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

Answers (2)

Answers (2)

0 Kudos

Hi Guru,

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

0 Kudos

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

gurucharanscm
Contributor
0 Kudos

Hi sai.sanjay, 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,