YTD reporting in BEx on BPC Virtual Cube(Planning_B)

[msmith123]

Hello,

I have strange problem - maybe somebody will be able to help.

We are during upgrade 10.0 -> 10.1 Standard.

We have BEx queries based on BPC Virtual Cube(Planning_B).

In those queries we key figures based on /CPMB/YTDDATA so "YTD cumulated"

But when I look at results in BEx Analyzer it shows single period values!

The same query on non-migrated (10.0) system shows correct values - YTD.

Looking fwd for your advice!

Thanks!

ms

[former_member186338]

Need more details with screenshots...

No issues in my system.

[msmith123]

Hi,

already disconnected from system, I will try to add screenshots Monday but it looks like that:

for given account and month I have following values when I display records from virtual cube through RSA1 -> view data :

Account Time /CPMB/YTDDATA /CPMB/SDATA /CPMB/PERDATA

A100 2020.03 300 100 100

Based on that cube I have defined BEx query where I display:

Account, Time, /CPMB/YTDDATA

and in Analyzer it is showing me following result :

A100 2020.03 100

not 300!

Regards,

ms

[msmith123 · Accepted solution]

Hello,

in the end it occured to be a bug - note 2986528 solved a problem.

Regards,

ms

[baiming_gao]

Search SAP Notes with keyword 'VP_TQ_NO_AGGR', and you might be able to find a solution.