Skip to Content
-1
Apr 27, 2020 at 07:59 PM

EPM Report Refresh- MDX Error

282 Views

Hello Team,

When I am refreshing the EPM report, I am getting the error below:

----------------EPM General Error-------------------

Error In refresh sheet.

Bad request.

Server message: code:UJO_READ_EXCEPTION_018 severity:error description:MDX statement error: Attribute "H001.PRED" cannot be used as a group by attribute. Reason: View attribute "H001.PRED" was not found in schema ... log id:051MgoeK7jgYbzO4XIb130 DATAVALUE:Attribute "H001.PRED" cannot be used as a group by attribute. Reason: View attribute "H001.PRED" was not found in schema ... MDX: V1:Attribute "H001.PRED" cannot be used as a group by V2: attribute. Reason: View attribute "H001.PRED" was V3: not found in schema ... V4:

Also attaching the screen shot of the error mdx-error.png

Attaching the screen shot for SLG1slg1.png

Tried the below steps but could not get the resolution

1. Refreshing the cache and Dimensions

2. MDX Parser Test through SM59-->Connections

Thank you..

Attachments

mdx-error.png (35.6 kB)
slg1.png (36.6 kB)