cancel
Showing results for 
Search instead for 
Did you mean: 

Is it possible to create a selection file from an excel

Ravi-B
Participant
0 Kudos

Hi,

I am loading data from a standard BW cube, and I have a requirement to restrict the load to BPC on several cost centers. I am using the DM package with UI to do the selections. But its huge list where I can't use ranges either. I am looking at the following possibilities.

1. if its possible to convert the list of cost centers into the selection file format used by BPC     OR

2. is it possible to mention the list of cost centers to exclude from selection any where. Transformation or Conversion file.

Thanks for any kind of help.

thanks,

ravi.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Ravi,

There are multiple ways of providing the selections.

1. Use the SELECTION statement in the transformation file

2. Provide the selections if you are using the UI process chain.

3. Use the *SKIP in the conversion file.

4. Use start routine in the transformation file.

4. Load all the data, and then use use end routine to reject the unwanted records.

You can use any of them in any combination. You need to identify the best match for your requirement.

Answers (2)

Answers (2)

Ravi-B
Participant
0 Kudos

Hi Nilanjan, Vadim,

Yes all of them will meet the requirement. The problem I have is its huge list of 2 sets of 300 cost centers for two companies. I can do that using ranges and *SKIP statement in conversion file.

That's the easiest way for a developer.However this will have to read much more data than required for performance point of view.

Including them in the SELECTION, or UI maintaining is cumbersome

Filling BW infocube , I would like to avoid one more step for support activity.

However I appreciate your help. Full marks.

thanks,
Ravi.

former_member182766
Contributor
0 Kudos

Hi Ravi! In case Nilanjan's recommendations are not enough - you could always create new InfoCube in BW and fill it with data the correct way and then bring everything in from the new cube into BPC.