BPC Metadata cache program

[rvvprasad]

Hi Team,

Would like to know what is the difference between

1. Select EPM More Clear Metadata Cache or click the Clear Metadata Cache button in the Edit Connection and Create Connection dialog boxes

2. Program UJA_REFRESH_DIM_CACHE

Are both functionalities are same??

Please explain.

Thanks,

Prasad Rangudu

[former_member186338 · Accepted solution]

"My question is if we execute clear cache from EPM client DOES this internally execute the program UJA_REFRESH_DIM_CACHE in the background." - No!

[rvvprasad · Accepted solution]

Thank you Vadim for your update.

[former_member186338]

First option is related to client side cache (EPM client on the local PC), second option is relates to central cache on the BPC server.

[rvvprasad]

Thanks Vadim for your quick reply.

So i can confirm that there is NO link in between client side cache (EPM) and the program cache (Central).

If possible can you explain when we have to use EPM cache and central cache with a example or scenario.

Thanks,

Prasad Rangudu

[former_member186338]

rvvprasad

Try to search notes for UJA_REFRESH_DIM_CACHE to get info about BPC cache tables.

[rvvprasad]

Thanks for your reply.

My question is if we execute clear cache from EPM client DOES this internally execute the program UJA_REFRESH_DIM_CACHE in the background.

This is the question i had from business and i don't find any information for this query. Can you please confirm?

Regards,

Prasad Rangudu