Posted by [IP Address: 209.115.235.6] 'Kevin ' on September 21, 2001 at 10:07:35 EST:
In Reply to: ProjectSystem Cube - Selection Conditions posted by [IP Address: 209.115.235.6] 'Viki' on September 19, 2001 at 21:13:27 EST:
: Hello All:
: I am working on BW2.1C, trying to make the Business Content for WBS work. The system uses infosource 0CO_OM_WBS_1 which reads all Project/WBS from the source without any usefule selection conditions. I want to add additional fields as selection conditions for transaction data upload namely field PROJECT TYPE and LEVEL in HIERARCHY. These fields are actually present in the master data of WBS. Would be grateful if someone can throw more light on this.
: thanks and regards
: Vivek
The infosource you are looking at is for transaction data only, so it is looking at the CO tables which do not contain the information you would like. That information would be in the WBS element master data infosource.
If you want to do selections on transaction infosources, you have several options, like enhancing the datasource on the R/3 side to include those fields, then using a user exit on R/3 to eliminate that data which you don't want to bring over.
Or, if you don't mind sending all data over to BW, but only want certain data in the cube, you could use transfer rules and/or update rules to remove data.
Finally, you could send all data to the cube, but put in filters that will eliminate the stuff you don't want.
Regards