Hi Experts
I have two questions:
1)We are trying to put a button on our web template to export the web report in to Excel format. I searched SDN blogs and found that I need to place a button group and add below code to achieve this:
<SAP_BW_URL DATA_PROVIDER='View1' CMD='EXPORT' FORMAT='XLS'>
My question is, I do not see any button group in web template web items, I only see radio button group. I'm sure that it is not the same. Please advice where I can find this button group web item in BEX WAD 3.5
Also, When I place this button where should I write the above HTML code?
2)In Bex Query we have 4 key figure values with decimals rounded to 0, We have a formula which is sum of above 4 Key figures rounded to 0. Now when we run the report all 4 Key figures are showing correct as per the def,
But as the fomula is adding these 4 KFs, it is not giving the correct totals. Example KF1: 3.3 KF2: 4.3 KF3: 5.1 KF4: 6.1
so our report shows
3 4 5 6 as Kf 1...4 and 19 as Formula value. Here the total for fomula is totaled as 18.8, and it is showing 19 to nearest number.But I want to show the formula value as 18 only. Can some one please advice how to achieve this.
thanks