BPC model Cache - After HANA migration

[SreekanthSurampally]

Hi, we migrated our BW system to HANA data base, also necessary BPC EPM Add in updates are performed. After loading the data to HANA model/cube, we observed that, the data is doubled for the days after HANA migration happened. 

/CPMB cube/model is displaying the values correctly in BW system, but the report in EPM Addin or web, is doubling the amounts for the last 2 days after HANA DB migration. We tried to clear the data in BPC, it gets cleared in the model/cube but not on the front end, still showing up in the EPM report for these 2 days only. We are unable to clear it. the problem exists on multiple user systems.

I think, there is some cache which is not getting cleared on the BPC application server side causing the issue. but not sure, if you can share your thoughts on this that would be helpful.

What we have done so far,

1. Cleared metadata cache from EPM Addin user options -- > more -- > Clear Cache data

2. Checked the RSRCACHE transaction to see any log there, nothing found.

3. Run the UJA Data checker program, no inconsistencies found,

4. Run the UJA DIM Cache program, no luck.

5. Run the program BPC_HANA_MIGRATE_FROM_10, did not work

6. Run the program UJHANA_REFRESH_VIR_CUBE, no luck

7. Run the program UJHANA_SYNC did not work

we are trying all the possibilities, please let us know if there is something we are missing here.

[SreekanthSurampally · Accepted solution]

Hi,  the issue is resolved,   summary of it is,

Actually just after the HANA migration, light optimize was run but it failed first time, upon repetition it went fine. When it failed, there was a request with incorrect DIM ID set up in the fact table, so with that,  display data of cube was not showing the data but EPM report is getting.

selective deletion on the cube to the incorrect request was performed and cleaned up. it is working fine after that.

[lucas_costa3]

It looks like an mdx issue.

Have you turned on the hana bpc configuration parameters?

ENABLE_HANA_MDX and ENABLE_NATIVE_HANA_MODEL?

Cheers,

Lucas

[SreekanthSurampally]

Thanks Lukas, I have gone through the notes 1904344 for ENABLE_HANA_MDX and 1902743 for ENABLE_NATIVE_HANA_MODEL respectively, first one is talking about issues with calculations and second one about using Badi, both may not be applicable to me.

My issue, data is cleared in the back end table of BW cube, but still showing up in the EPM report on that model/cube.

[lucas_costa3]

Yeah, when you activate ENABLE_HANA_MDX the there's lots of checks but the message don't actually tell a lot.

I recommend checking all script logics, member formulas and business rules.

Also check your dimensions if you have special chars like "-"...

And lastly, I do remember having to create a hierarchy in currency dim to finally activate that property.

[SreekanthSurampally]

Thanks Lucas, actually SAP is investigating the issue now, we proposed this parameter, but they said that, it is not applicable to our issue. SAP also saying that, it is something related to MDX issue.

But we will suggest again and see what they have to say to it.  Trying in different other ways, but not helpful.