re:blt

[Former Member]

hi,

can any one say what is the exact use of crosstab and web service in the blt.

[Former Member · Accepted solution]

Hi Krishna,

Webservice in BLT is the place where u can expose any of your transaction as a web service using SOAP and HTTP.

U can use the following URL for exposing a transaction as a web service

http://<servername>/Lighthammer/WSDLGen/<transaction name>

In other words u expose your transaction functionality to other applications.

xMII has the capability to consume a web service also

A Cross tab is a function that calculates the subtotals depending on the columns specified.

In case u want to find out the sales for Product A, Product B you can specify Product as column during configuration of cross tab and crosstab groups the columns to give u the subtotal.

Hope this helps u....

Regards,

Ajitha

Message was edited by:

Ajitha Buvan

[Former Member]

Hi,

Cross tab is used for sub totalling. All most the same concept of SUBTOTAL Transformation in Query Templates.

We can use a maximum of four DrillDowns or CrossTab Columns.If we are not giving any CrossTab Columns for CROSSTAB action, it will take the total of all the values.

For example:

A table with four fields , (CATEGORY, QTY , NAME , AMT )

<b>Category</b> contains Fruits, Vegtables, MEAT and Fish

<b>Name</b> Contains type of fruit , Veg etc available.

Now If we want to Subtotal according to <b>Category</b>, we have to call a CrossTab Action and in the <b>configure object</b>, give the desired column name (eg: Category).

Assign the XML output from CrossTab action to any Output Transaction and view the result using Xacute Query.

Hope i have answered.

Regards

Muzammil