Selection in data load from infoprovider
In BPC NW 7.5 we have to load data from infoprovider allowing users to select data (like for dimension TIME) by BPC prompt. We found two solutions solving partially our problem. In fact, users have to modify manually the selections.
To load data we want use the process chain /CPMB/INFOPROVIDER, but we know that it is not possible insert selections in the /CPMB/INFOPROVIDER prompt (as describe in this post Package LOAD INFOPROVIDER, Select input ENTITY).
To select data we can use an intermediate infocube as a BW workaround (as describe in this post BPC 7.5: Delta Load when loading from BI InfoProvider ) to have a source with only the selected data.This could be done by a selection in the DTP between the source infocube and the intermediate infocube. This solution is not dynamic, in fact, in this case users have to modify manually the DTP selection.
How can we allow users to insert this selection in the DTP by a BPC prompt?
To select data we can use a transformation file inserting a selection like
SELECTION = <Dimension1_techname>,<Dimension1_value>.
It is not dynamic, in fact, also in this case users have to modify manually the file selection.
Do you know how to allow these selection by a BPC prompt to avoid these manual changes?
Do you know other solutions?
Thank you for your support.