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

[henk_hoogerbrug · Accepted solution]

solution has been provided by SAP via oss note 2685500.

[henk_hoogerbrug]

Within the BPC audit settings we see FIM as a separate option:

Within UJ_VALIDATION the FIM upload is part of DM

Within FIM we don't have that much settings, but here you see that we are using webservice UJO_WS_FIM:

[former_member186338]

From FIM help:

"When you import data, that is, when the business planning and consolidation application is your target, there is no loading option. You can load data at the leaf level only. Loading data in the financial information management application is equivalent to loading with the Data Manager using the Merge option in the planning and consolidation application."

I can recommend you to write very simple write back badi with endless loop at the beginning of code. Then debug it during FIM load (using SM50). Look on the data passed to write back badi.

[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?