Hi Experts,
i got a problem. I got a query with 4 key figures inside. Only the first key figure need to be changed by following command urls:
<SAP_BW_URL DATA_PROVIDER='DATAPROVIDER_1' FILTER_IOBJNM='3YSBR1GNTYTR14XTUYC7QS488' FILTER_VALUE_1='3YSBR3T5MJGJQ0VRN51YTDQ3S' FILTER_VALUE_2='3YSBR2BDXT8L3N3MIALKUZZ3C' FILTER_VALUE_3='3YSBR2J2GRUAM9N2O4NX51XT4' FILTER_VALUE_4='3YSBR2QQZQG04W6ITYQ9F3WIW' CMD='ITEM=CHART_2&CAPTION=0'> ==> Current month
<SAP_BW_URL DATA_PROVIDER='DATAPROVIDER_1' FILTER_IOBJNM='3YSBR1GNTYTR14XTUYC7QS488' FILTER_VALUE_1='3YSBR40U5I298NF7SZ4B3FOTK' FILTER_VALUE_2='3YSBR2BDXT8L3N3MIALKUZZ3C' FILTER_VALUE_3='3YSBR2J2GRUAM9N2O4NX51XT4' FILTER_VALUE_4='3YSBR2QQZQG04W6ITYQ9F3WIW' CMD_3='ITEM=CHART_2&CAPTION=1'> ==> Last month
Only FILTER_VALUE_1 is interesting for me. If i use the filter command the filtering itself works fine BUT BEx removes the first key figure and added the new value for FILTER_VALUE_1 at the end of the structure.
Example:
before filtering:
"""current month""" - last year - year to date - actual year
after filtering:
last year - year to date - actual year - """last month"""
Is it possible to change the order within a keyfigure structure or is there a mistake in my command url?
Best regards,
Adem