UJ_VALIDATION on FIM upload only

[henk_hoogerbrug]

Hello,

We are using FIM 10.0 to load data into BPC 10.1 (classic) and we are wondering if there is any possibility to validate the data loaded via FIM.

Within UJ_VALIDATION there is an option to activate validations on DM packages. Unfortunately this will not only validate the FIM upload, but also other packages (like consolidation or any reclass).

Example: we will use FIM to upload local data, so only SCOPE=cNone and CURRENCY=LC. When a users want to create data on CURRENCY=EUR, the validation rule should return an error message.
But when we run the consolidation package, we don't want to get the error message, because the combination SCOPE=cNone and CURRENCY=EUR is a valid result from the currency translation step.

Is it possible to check if data is created via FIM or not? Within the webclient audit report it is possible.

So does anybody know if this is possible in the UJ_VALIDATION BAdI, or the bpc write back BAdI?

Best Regards,
Henk

[former_member186338]

"data loaded via FIM" - can you explain the process in details?

[henk_hoogerbrug]

Hello Vadim,

We use SAP Financial Information Management to get the financial data (e.g. balance sheet, P&L) into SAP BPC.

Simple example:
We want the FIM data only on AUDIT_TRAIL ID "INPUT_FIM" (and not on "LOCAL_ADJ"), so we want to create a validation rule to check if data is loaded/created via FIM. If so, only "INPUT_FIM" is allowed. If not, "LOCAL_ADJ" is allowed.

Best Regards,

Henk

[former_member186338]

I have never used FIM with BPC. Please explain, how data loading is processed? What chain is used, etc...

[henk_hoogerbrug]

I don't know the technical details about FIM. It is a web based tool, so I think it will use a web service to load data into BPC (I can't find a FIM related process chain in our system), but maybe it will use a standard BPC process chain.

[former_member186338]

What about data audit? What do you have in the audit details for loaded data?

For data manager - do you see some packages running to load data?

[former_member186338]

Can you provide details with screenshots about your FIM job configuration?