Skip to Content
0

Epm Excel report doesn't recognize one dimension in the model,says invalid dimension member

Oct 13, 2016 at 08:10 PM

190

avatar image

Hi Experts,

I have a epm excel report , when I try to save data it says invalid Entity dimension member and it shows as blank. The Entity dimension member is part of page axis and when you check epm properties of a given cell in report , it shows the correct entity dimension member.

For resolution I have tried the following :

1) Created a dummy report and tried saving data, but same error.

2) Reprocessed the entity dimension again.

3) Went to SE38 and refreshed cache for entity dimension.

I am getting the same error. Any suggestion.

Regards,
SHUBHAM

10 |10000 characters needed characters left characters exceeded

Screenshot of the very simple input form and the error screenshot are required.

0

Hi Shubham,

Is this resolved? Can you provide more info like a screen shot or Fiddler trace?

Thanks,

0
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Priyanka Jagtap Oct 14, 2016 at 05:53 AM
0

Also..try removing Entity dimension from page axis and use another dimension instead......and then save data! Is entity dimension a secure dimension? Any security issue?

Screenshots please!

Regards,

JP

Share
10 |10000 characters needed characters left characters exceeded
Harsha Jalakam Oct 18, 2016 at 10:20 AM
0

Hi Shubham,

I had the similar issue too. Clearing off local Metacache data from EPM and deleting the report saved on the PC_NW folder had resolved the issue

Also check if your entity dimension is a time dependent, please do clear off cache from the UJXO_CLEAN_TDH_DIM_CACHE.

Regards,

Harsha

Share
10 |10000 characters needed characters left characters exceeded
SHUBHAM VERMA Nov 28, 2016 at 11:04 AM
0

Guys apologies for so late reply. Write back was configured in the model which was playing with the dimension members.

In one of the cases ENTITY was somehow going blank and thats' why it was showing this error.

Thanks ,
SHUBHAM

Show 3 Share
10 |10000 characters needed characters left characters exceeded

You are talking about incorrect code in write back badi?

0

Yes the code was wrongly changing the entity dimension member in Write Back badi to "".

0

Now it's clear!

1