Column selection based on TIME properties doesn't work

[ivan_blatnik2]

Hi,

Input schedule has more reports with columns selected dynamically based on TIME properties. This worked perfectly till this year. Now by no rule sometimes works OK, other time columns are not according to dynamic selection. Workaround for the problem is Refresh Metadata + Refresh worksheet - then it is OK. I have EPM Add-in version 10.0 SP26 Patch 3 .NET 3.5.

BPC version is

CPMBPC

800

0011

SAPK-80011INCPMBPC

CPM Business Planning and Consolidation

Best regards and thanks in advance!

Ivan

[former_member186338]

Sorry. but the issue is not clearly described and test case is not provided

[ivan_blatnik2]

Hello Vadim,

Now I made a simple example:

Input schedules has two reports:

• Default report with column filters:
  • Category = Actual
  • Measure = Periodic
  • Time: MP = »AY« (2009.TOTAL, 2010.TOTAL, 2011.TOTAL, 2012.TOTAL,      2013.TOTAL)

• Report 005 with column filters:
  • Category = Actual
  • Measure = Year To Date
  • Time: Last month passed = »EL«, »YL«, »Y« (2013.12, 2013.09, 2014.09)

Expected result is this:

Periodic	Periodic	Periodic	Periodic	Periodic	Year To   Date	Year To   Date	Year To   Date
Actual	Actual	Actual	Actual	Actual	Actual	Actual	Actual
2009	2010	2011	2012	2013	Dec 2013	Sep 2013	Sep 2014

But occassionally I get this:

Periodic

Periodic

Periodic

Periodic

Periodic

Year To   Date

Year To   Date

Year To   Date

Year To   Date

Year To   Date

Year To   Date

Year To   Date

Year To   Date

Year To   Date

Year To   Date

Actual

Actual

Actual

Actual

Actual

Actual

Actual

Actual

Actual

Actual

Actual

Actual

Actual

Actual

Actual

2009

2010

2011

2012

2013

Sep 2013

Jan 2014

Feb 2014

Mar 2014

Apr 2014

May 2014

Jun 2014

Jul 2014

Aug 2014

Sep 2014

By using Refresh Metadata + Refresh Worsheet I get exected result.

BR, Ivan

[former_member186338]

Please show screenshot how you set "Time: Last month passed = »EL«, »YL«, »Y« (2013.12, 2013.09, 2014.09)"

[ivan_blatnik2]

 
  This is setting of the filter in report.
 
  And this are values for Time property Last month passed

 

 
  BR, Ivan
 

[former_member186338]

Please check this setting in the user options:

[ivan_blatnik2]

This are my user settings.

[former_member186338]

P.S. Looks like it's not related to your issue!

Can you test different EPM version? For NET 4

[ivan_blatnik2]

I will ask my colleague with 64-bit Office to check.

[former_member186338]

You don't need 64-bit office to work with EPM NET 4!

[former_member186338]

I have now:

and

[ivan_blatnik2]

So I download it from this section?

https://launchpad.support.sap.com/#/softwarecenter/template/products/_APP=00200682500000001943&_EVEN...

I thought this is for 64-bit office.

Isnt BIG VOLUME indication for 64-bit?

[former_member186338]

It will work fine also with 32-bit!

[ivan_blatnik2]

I installed .NET4 - problem is the same.

PS: thanks for hint about this

[former_member186338]

Close Excel and delete PC_NW folder, it will be recreated on EPM launch.

[ivan_blatnik2]

I deleted folder C:\Users\IVAN\Documents\PC_NW. Problem remains. It seems that once it starts working wrong then it keeps going on. And it is also at other users - so it should be a bug. I raised incident at SAP.