Subtotal Transformation and Interpolated Values Transformation

[Former Member]

Hi All,

Can someone please guide me how to work on <b>SubTotal Transformation</b> and <b>Interpolated Values Transformation</b>. (With example)

Thanks in Advance

Muzammil P.T

[Former Member · Accepted solution]

Hi Muzammil,

First of i like to explain Sub Total Transformation:

If you are using inline transformation the formatting,aggregation, or other manipulation of a dataset takes place for each dataset in the table.That means it changes for each and every row.But if u r using Sub Total Transformation u can restrict Inline transform for only certain rows based on condition like category=foods or like that.

For Interpolated Values Transformation:

If i am querying a database across like say between two timeperiods i may not get data.Then in that case i need to show some value for tht particular row as value like rowvalue=NA for that row.If i havent used this it wont show the row for tht timeperiod.This is just an example this can be used in many ways depends on our usage.

Please revert back in case of any queries in above.........

regards,

ravi kumar

[Former Member · Accepted solution]

Hi Muzammil,

Sub Total Transformation : In any queries if you want to change the output format you need to use XSL files residing in the server which will change the style sheets. In this way you can also manipualate the outputs of your query. For example in xMII you will get the schema of the output of a query template in a standard format. They are applied through these type of XSL files only.

Interpolated Values Transformation : I will explain this one with example. You have two query outputs one with 10 lines and second one with 5 rows against time. But your requirement is to draw plot for the both of them in single plot. Then you need to interpolate the results of the both templates and then you will get the estimated values for all the time periods.

Hope this will help to you.

Thanks,

Rajesh.

[Former Member]

As with my previous recommendation regarding AggregateQuery, I would avoid using XSL transformations and instead, use the business logic services to perform these functions. The performance is much better, as is the ease of use and overall capability.

Both of these are legacy features of xMII that are no longer being developed or enhanced, and have been replaced with BLS.

- Rick

[Former Member]

Hi all,

Thanks for ur help

Regards

Muzammil

[jamie_cawley]

Hi,

The xMII documentation provides an example and explanation for each of these. Take a look at

http://help.sap.com/saphelp_xmii115/helpdata/en/Advanced_Topics/Predefined_Inline_Transformation_Ove...

Regards,

Jamie