Problem using custom YTD Measure after transport in Quality environment

[Former Member]

Hello Experts,

I am facing on a following issue. After transporting in Quality environment, the custom YTD Measure does not work where as in DEV, it works well.

Below are the screenshots in EPM of  DEV and a summary.

Periodic Measure

1. Screenshot result Periodic Measure DEV

YTDFISCY Fiscal Year Measure (custom)

02. Screenshot result YTD Fiscal Year Measure DEV

=> Result : YTDFISCY Fiscal Year Measure works since it sums the amount of April 2013 and May 2013 (if we want to have for YTD Fiscal Year for May).

But when I transport in Quality Environment, I don't have the awaiting result after running a EPM report, the YTD Fiscal year measure does not work.

Note : For the transport :

1) I have transported in adapting a doc as how-to

http://scn.sap.com/blogs/ning/2013/03/27/sap-bpc-10-transport-guide

for Environment, Model, Dimension...

Transport is OK

2) As standard BPC transport does not enable to have the table, so I had to transport the table UJA_FORMULA_APPcontaining my YTD Fiscal Year Measure (Custom).

Now I create a report in EPM and run a simple report in EPM.

QUA Environment.

Transport is OK and checking in Quality inUJA_MAINTAIN_MEASURE_FORMULA (se38) => My YTD Measure custom exists.

Below are the screenshots in EPM

Periodic Measure

03.  Screenshot result Periodic Measure QUA

YTDFISCY Fiscal Year Measure (custom)

04. Screenshot result YTD Fiscal Year Measure QUA

Question :

Does someone have any idea to resolve it ?

Result : The report displays "0" for all.

Thank you in advance.

Regards,

Son

[former_member186338 · Accepted solution]

Hi Son,

The reason is simple - you have different technical names for your custom property in DEV and PROD:

CURRENTMEMBER.PROPERTIES("2/CPMB/ATPR1YN")

Correct name in PROD... or stabilize tech names between environments.

Vadim

[Former Member · Accepted solution]

Hi Vadim,

This point (technical name), I have already checked after my transport via Tcode MDXTEST.

I have same technical name between DEV and QUA

Below a screenshot for the technical name in QUA

As you can see, we have the same technical between DEV and QUA.

I don't really know why it does not work in QUA.

Regards,

Son

[former_member186338 · Accepted solution]

And hope that values in MONTHNUMFY are correct?

[Former Member · Accepted solution]

Vadim,

Yes,  Values in MONTHNUMFY of the TIME dimension are same between DEV ans QUA.

Regards,

Son

[former_member186338 · Accepted solution]

Can you show a screenshot of PROD TIME dimension in web admin? No spaces in MONTHNUMFY?

Vadim

[Former Member · Accepted solution]

Vadim,

Below is the screenshot TIME Dimension in Web Admin.

Note : No space in MONTHNUMFY.

I have transported the TIME Dimension as in DEV last time.

So probably, Dimension member are not taken in account. Perhaps, we have to simulate a change for 12 months and then save and process. I will try like that. I will tell the result ASAP.

Regards,

Son

[former_member186338 · Accepted solution]

You may also backup environment in PROD (or QA) with UJBR and restore it with different name in DEV. Then correct technical name and check is it working...

Vadim

[Former Member · Accepted solution]

Vadim,

The problem has been resolved. As I said in my previous post : 

1. I have simulated a change for one month in the column "Month Number FY" (remove "1" and enter "1" again)

2. Save and process it

Now it works in the report.

Thanks in advance.

Regards,

Son

[former_member186338 · Accepted solution]

It means, that may be during transport it was received with space after 1...

Vadim