on 10-22-2018 2:30 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Guru,
Exactly, when I drill down from Total to Details All I can see only two out of 4
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
User | Count |
---|---|
11 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.