Validation with data file failed while loading data from BW ADSO

[former_member590808]

Hi

We are fetching data from a customised ADSO in BW to BPC cube. While validating the transformation file I chose 'Transaction data from Netweaver BW inforprovider' and chose the required ADSO. In set selection I am chosing

'BW: Transaction Key = 1 ,

Reversal Indicator = (blank)

when am validating with this selection validation fails with message "Error occurs when loading transaction data from other model Validation with data file failed" and the BPC package executes with Failed. When I put filter only on Reversal Indicator then validation is also successful and package also executes successfully.

Both of them are key fields in ADSO, (attaching screenshot) then why does it fail for one and is successful for another.

Regards,

Neha