Aggr within set analysis

[somenathroy]

Dear All,

I have some plants taking products from factories. Factories have different production slots(buck) for producing products. Now I have to show in a chart

Plant,Factory, product and production value of max buck/slot.

I am using Aggr(Max(buck),Factory,product) in a set analysis, but it does not work.

Please find the attached qvw file that describes the problem.

Any help would be highly appreceated.

Thanks & Regards,

Som

[Gysbert_Wassenaar]

Try FirstSortedValue(prod_val,-buck). This will work as long as there's only one maximum buck value per plant-factory-product combination.

[somenathroy]

Thanks for your reply.

In our requirement, each factory can have multiple buck/slots(e.g 1,2,3,4,..,n) for production. Plants take products from Factories. Thus we can say  plant-factory-product combination have multiple bucks.

The attached image shows the table structure. 

keyprod : factory + product

keyfact : plant + product

Pls suggest if you think any better table model.

Regards,

Som

[Gysbert_Wassenaar]

You could do some calculations in the script to find the max prod_val of the max buck. See attached qvw.

[somenathroy]

Thanks for your solution. But still I am facing the problem if I have to show :

production(max(buck)) ,  production(max(buck) - 1) and production(max(buck) - 2).

Actually in our real scenario script level calculation would not be acceptable as script level max prod_val calculation grouping over lots of dimensions would be very difficult (in terms of time and also expression writting).

Regards,

Som