SAP Business Objects Webi Issue

[Former Member]

Hi,

Can we use webi Previous() function in crosstab report. When i am using the same in crosstab report the previous value of first coulmn is getting displayed in the last column and it is working fine for all other columns.

Thanks

Swati

[Former Member]

Swati,

The simple answer is NO.

The Previous function is a row based function and works well for a regular non aggregated table but in a cross tab the results are aggregated and the result of one row in cross tab is actually a combination of multiple rows.. So if you use this function it will not work are desired..

[Former Member]

Hi Durga,

I have tested Previous function in crosstab and it's working well over aggregated data. As per my understanding we can use previous function over any value and there is no restriction.

Correct me If I'm wrong.

Regards

Sunil

[Former Member]

Hi ,

When i am using Previous() in crosstab i am not getting the previous value for first column. I have used in horizontal table and its work fine.

Please anyone can explain how it can be used in crosstab report.

Thanks

Swati

[Former Member]

Hi Swati,

First column should be blank. Please post a screenshot of your report and formula you have written in the report.

Regards

Sunil

[Former Member]

HI Sunil,

looks like you are correct here.. looks like previous work just fine cross tab just like a regular table..

I always use relativevalue function in most cases so I have misses this use of previous function.. Thanks for the reminder..  keep up the good work helping the community..

[Former Member]

Hi Swati,

When Previous() used in a crosstab, First value returned by previous will be blank and it does not treat the last value in a row as the previous value of the first value of the next row.

Eg:

                2004        Previous     2005      Previous

A              100                            150         100

B              250                            400         250

C              300                            225         300

Regards

Sunil