cancel
Showing results for 
Search instead for 
Did you mean: 

Unformatted rows and duplicate IDs in report

Former Member
0 Kudos

We have a report that upon refresh, it results to a partially formatted and unformatted results. We do a second refresh and the issue doesn't appear anymore.  We tried to clear metadata cache prior to the first refresh but to no avail.


Below are the screenshots:


Prior to refresh -

Upon refresh, we can see that there are unformatted results.  We also identified that there are duplicate ids.

After 2nd refresh the issue doesn’t come up.   No unformatted rows and no duplicate IDs.

For us to fix the issue, we resaved the template after the 2nd refresh. It worked correctly now. But we took a backup of the file with issue to be able to debug. Although there is now a fix, we need to identify the root cause so that we can prevent it from happening moving forward.



Accepted Solutions (0)

Answers (2)

Answers (2)

akos_beres
Contributor
0 Kudos

Francis,

Additionally to Vadim's suggestions ... How is the report built? Does the sheet have multiple reports? Are any of the reports page axis reference each other? Are any of the axis formulas are overridden?

Akos

former_member186338
Active Contributor
0 Kudos

Hi Francis,

Unfortunately your screenshots are too small to be readable...

Anyway, do you use formatting sheet? What is your EPM SP?

Vadim

Former Member
0 Kudos

Hi Vadim,

Apologies for the screenshot size.  Yes, we use formatting sheet.  For my EPM version, see below.

former_member186338
Active Contributor
0 Kudos

Test the same with EPM SP25