Skip to Content
0
Former Member
Nov 22, 2006 at 11:22 AM

Cumulative value in Web query reporting

29 Views

Hello Gurus,

I have been noting a wrong functionality using Web Query Designer regarding the display of cumulative value of a key figure.

In particular I created a very simple query with the key figure Amount in the columns and Posting Period in the rows.

But it is not possible to display the cumulative value of this key figure executing the query on the Web. The result for all the period is always zero for all the period.

I try to find a workaround for this problem in the following ways:

- I try to change the calculation direction but with the same result

- I try to create a calculated key figure using cumulative in the calculations tab of the properties.

The important fact is that if I execute the same query using business Explorer analyzer the query gives the right cumumulated value.

So I think mean the problem is only on the web front end.

Have you any suggestions?

Best regards

Massimo