cancel
Showing results for 
Search instead for 
Did you mean: 

Error when using Base Level Time members with YTD Measure

Former Member
0 Kudos

Hi All,

I've been searching around and found several threads and notes that slightly match my issue, but not found anything that seems to match exactly.

We've recently upgraded our SP levels from CPMBPC 801 SP 3 to 801 SP 10 on BW 7.31 using BPC 10.0 NW and since our Production system was patched have found that when executing any EPM Reports in Excel using the PERIODIC Measure, the Time Dimension can be used at Base Level and all Parents with no issue. If we try the same thing with the YTD measure it gives an error (see below). However, the error is restricted to the Production system only and only on one Environment. When using YTD on another Environment the Base Level members can be included without error.

code: UJO_READ_EXCEPTION_018

severity: error

description: MDX statement error: Value 2017.01 0HIER_NODE for characteristic /CPMB/EMD9S9O unknown

I'm not sure if it's related at all, but I found that for this Environment only and only in Production that there is an extra entry in the UJ0_PARAM_APP table for the Models within this Environment called "ACCOUNT_TYPE_ALIGNED". I'm not sure why this is in this table or when it got there, but it is a difference between this and other (working) Environments and systems. Some of the Models are marked "X" and some blank, but the error appears to be in all of the Models of this Environment (NB: QTD is effected in some but not others). Is this likely to be the root of the problem? Should I delete these from the UJ0_PARAM_APP table and if so can I do this without other consequences?

I've also seen some discussions suggesting that changing the UJO_PARAM table entry for "ENGINE_TYPE" to "CL_UJO_QUERY_BASE" may work. The current value that I have for this in Dev, QA and Production is "CL_UJO_QUERY_MDXPTD2" and as I've said already the Dev and QA systems are working fine, as are the other Production Environments - it's only the one Environment in our Production system that has the problem. As such, I don't think this the right solution, but willing to be convinced otherwise.

NB: Our Models use Storage Type PER (PERIODIC).

Many thanks in advance.

John

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Just to clarify (as I don't think I was 100% clear) I can execute a query using any of the PERIODIC, QTD or YTD Measures using TIME Dimension Parent Members, but as soon as I try and use a Base Level Member it shows the error mentioned above.

PERIODIC works perfectly and has no problems, QTD shows errors in some but not all Models and YTD always seems to have errors in all of the Models of this one Environment.

I've checked for differences in the MDX formulae for PERIODIC, QTD and YTD of one of these Models against a correctly working Model in another Environment, but the same system and there was no difference.

The only difference I've found to date is the inclusion of "ACCOUNT_TYPE_ALIGNED" in table UJ0_PARAM_APP. I'm tempted to remove this to see if it makes a difference, but I'm not sure if removing it will create other issues?

Regards

John

former_member186338
Active Contributor
Former Member
0 Kudos

Hi Vadim,

I had come across that note in my search, but re-reading it again it seemed like something that needed to be done. I have now worked through this in all systems, checking at each stage to see if the same problem occurred in either our Dev or QA systems, but no change there and now also into our Production Environment, but still the problem persists.

Any other ideas?

Regards

John

former_member186338
Active Contributor
0 Kudos

BW SP17 ?

former_member186338
Active Contributor
0 Kudos

Hi John,

What is your BW 7.31 SP level?

Vadim

former_member186338
Active Contributor
0 Kudos

P.S. By the way, the latest are:

SAPK-80112INCPMBPC - BPC SP12

SAPKW73117 - BW SP17

Vadim

Former Member
0 Kudos

Hi Vadim,

We're on BW 7.31 SP16.

John

former_member186338
Active Contributor
0 Kudos

I do not know the exact reason for the issue you have but in past I managed to solve the same with upgrade to the latest SP of BW...