UJA_REFRESH_DIM_CACHE not working as expected

[Former Member]

Hello Experts,

In BW backend I'm loading BPC dimensions via a Process Chain in the following way:

1. Attributes --> loads attributes into the BPC dimensions

2. Attrs change runs --> run attr change runs where applies

3. Texts --> loads texts into the BPC dimensions

4. UJA_REFRESH_DIM_CACHE --> Update dimensions' cache

Everything works ok, except for the step 4. (which ends "green" as well), it is expected that as per the UJA_REFRESH_DIM_CACHE pgm successful execution the staff in BPC end should be able to see the dimension data updated w/o the need of any additional or refresh activity to be performed.

The parameters for the variant when executed are (pipe separated):

Selection Scrns|Field Name|Type|I/E|Option|frm|to

1000|Appset Name|P|||MY_APP|

1000|Refresh server side cache?|P|||X|

1000|Refresh client side cache?|P|||X|

1000|Increase Dimension Version?|P||||

Could you please help to clarify this? Why it seems that the program execution is not performing anything? What could be wrong?

Thanks in advance and best regards,

Bernardo

[Former Member]

Hi Bernardo, have you gotten any answer to this problem?

Im also loading a BPC dimension via a BW Process Chain following the steps you mentioned, and actually Im able to see the master data loaded into my BPC dimension but when I log on into a model that has this dimension assigned, it does not show all the master data I loaded even though it appears into my BPC dimension when I check the dimension in the Admin.

If I add a new member directly in the dimension and process it again from BPC front end, Im then able to see all the members into the dimension when loging on again into the model that has it.

I belive that the program UJA_REFRESH_DIM_CACHE that is executed from back end does not run exactly the same as it runs from BPC front end.

Regards,

Aldrin Liendo

[Former Member]

Hello Aldrin,

I don't have access to any BPC landscape at the moment, but as far as I recall it was related to the variant/parameters selected. I remember there was a particular one which was causing the difference between success and the undesired situation.

My suggestion is: play with the parameters and test the results you get. I hope you find this info useful.

Best regards,

Bernardo

[Former Member]

Thanks Bernardo !!