on 09-20-2013 9:24 PM
Hi All
I am on MII 12.2.I am using different data sources (ECC,SQL) to obtain 3 xml's which i finally merge together to get the desired data something like this :
Plant | Actual Quantity | Planned Quantity |
1001 | 1500 | 15000 |
1002 | 500 | 1000 |
1002 | 10000 | 15000 |
1004 | 0 | 12000 |
Now i want to do a group by on plant so that i achieve a total of quantities as per plant like this :
Plant | Actual Quantity | Planned Quantity |
1001 | 1500 | 15000 |
1002 | 15000 | 16000 |
1004 | 0 | 12000 |
I want my BLS transaction to return an XML like this.Can some one please guide how to do a group by in a BLS transaction.
Hi Shweta,
Why dont you create a local MII table with these 3 columns and store data.
So you can anytime do group by on that table data and fetch data?
Regards,
Padma
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
6 | |
1 | |
1 | |
1 | |
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.