Solve order property in crosstab

[yogeswari]

Hi,

Could anyone tell me an explaination what is the use of "Solve Order" property in crosstab.
Since i am beginner, i learnt about this from one article, but i could not understand what is the purpose of that post.

The article that i read is url: http://www.ibmpressbooks.com/articles/article.asp?p=1761785&seqNum=3

Please help me.

Thanks,
Yogeswari.

[MFGF]

Hi,

When a crosstab is rendered, the columns are populated first, then the rows, then the measure cells. Imagine you wanted to add a calculation to the columns area but have the calculation performed after the other columns and the rows and the measure cells had been derived. How could you defer the evaluation of your calculation until then? This is what the Solve Order property is for - it allows you to define in what order things are "solved" when an object (such as a crosstab) is rendered. The higher the solve order of an object, the later it gets evaluated in the processing flow of the report.

Cheers!

MF.

[yogeswari]

Thank you so much for your responses :) :) :).

I got it.

Thanks,
yogeswari.

[rajvivan]

Solve Order is mostly used in Crosstab to solve the data items, calculated member or calculated measure in order. The lowest solve order value is solved first.
For Eg. If you want calculation like Value/Total to be performed only after all the values are fetched in the report and not to perform calculation prior.In this case you can assing solver order 2 to this data item. There may be another data item that may use this calculation for that , you can assign Solve order=3 and so on.
In this way a Solve Order property helps to execute the data items as per the requirements.