Skip to Content
0
Former Member
Dec 25, 2011 at 08:33 AM

Load master data from flat file or Send variable to Transformation file.

31 Views

Dear Sap Expert,

We are on SAP BPC NW 7.5 SP10.

Background.

Our needs is to load master data from flat file to Entity dimension. But we want that our users be able to update just that ID that available for them on Member access profile. We know that if we will just load master data from file, user can update any Entity ID.

Our solution was to add SELECT in our package, because in this SELECT user can select only that ID that available in Member Access Profile :

PROMPT(SELECT,%ENTITYSELECTION%,,"Select the members","M_ENTITY")

So, then we try to use %ENTITYSELECTION% variable in TRANSFORMATION FILE.

ID=*NEWCOL(%ENTITYSELECTION%)

But we found that our transformation file didn't get %ENTITYSELECTION% variable. System understand this not as variable, it understand as member element(string).

Is it possible to send variable(parameter) to Transformation File in SAP BPC NW 7.5?

We have other workaround solution : we link our package to our script logic, where we run our BADI script, where we load master data.

Please if you know any other solution, could you please provide it?

Thanks,

Kadraliyev Yerlan