Import only Balance Sheet transactions from BW Cube

[Former Member]

I'm running a Package to import BW data into BPC Model (Package uses Process Chain

/CPMB/LOAD_INFOPROV_UI)

I'm importing from the BW InfoProvider 0FIGL_C02.

I only want to import data which is marked with X in 0BAL_FLAG (i.e. X = Balance Sheet). See print screen above.

Those which is not marked with X must not be imported into my BPC Model data.

How do I do that in the Transformation File / Conversion File?

[former_member186338]

Incorrect! In the old days the selection statement in transformation was used 🙂 Today with /CPMB/LOAD_INFOPROV_UI it's possible to select based on attributes!

[balaji_neelamaygumsubrama]

You can restrict the balance sheet item in the selection of info provider in DM package . In below screen shot I'm selecting only employee with valid to date = 99991231 and employee status = 3, similarly you can select 0BAL_FLAG = 'X for selecting the balance sheet data from BW cube

Hope it helps,

Balaji

[former_member186338]

Better to have the same screenshot from the topic author 🙂

[former_member186338]

Please show all screenshots related to selection of info provider in DM package run.