0 Replies Latest reply: Nov 5, 2012 8:56 AM by 972564 RSS

    How to filter data in BIP Report fetched from Integration Object

    972564
      Hi,

      I have a requirement where I am extracting data of Account records of a Customer. Customer can have multiple types of Accounts. In BIP report, I want to different types of Customer Accounts in different tables. Is it possible? I tried but Conditional Region and Conditional Format options are not working for me. I am using BI Publisher desktop 10.1.3.4.1 version addon for MS Word.

      I am pasting below sample XML for this.


      <?xml version="1.0" encoding="UTF-8"?><ListofIO
      <ListOfBipStarsFincorpAccount
      <FincorpAccount
      <Id
      1-LZ6-46</Id
      <Created
      05/21/2005 19:15:21</Created
      <CreatedBy
      0-1</CreatedBy
      <ABANumber
      Makkah Main</ABANumber
      <AccountName
      سلامه مصطفى ابراهيم سلامه</AccountName
      <AccountType
      Time Deposit</AccountType
      <Acct_Num_Mid_7_7
      7539940</Acct_Num_Mid_7_7
      <Acct_Num_Mid_1_6
      104142</Acct_Num_Mid_1_6
      <AccountNumber
      1041427539940</AccountNumber
      <AcctGen-PrimaryContactId
      1-K5B-445</AcctGen-PrimaryContactId
      <Currency
      SAR</Currency
      <CurrentBalance
      </CurrentBalance
      <CustomerNumber
      </CustomerNumber
      <IntegrationId
      940784</IntegrationId
      <ProductId
      1-DFPY</ProductId
      <RB1ODS
      8290755</RB1ODS
      <STARSAccountBranchArabicName
      مكة المكرمة</STARSAccountBranchArabicName
      <STARSContactId
      </STARSContactId
      <STARSContactToRelation
      </STARSContactToRelation
      </FincorpAccount
      <FincorpAccount
      <Id
      1-LZ6-227</Id
      <Created
      05/21/2005 19:15:21</Created
      <CreatedBy
      0-1</CreatedBy
      <ABANumber
      Makkah Branch</ABANumber
      <AccountName
      عبد العزيز محمدعلي درويش الصبحي</AccountName
      <AccountType
      Time Deposit</AccountType
      <Acct_Num_Mid_7_7
      469940</Acct_Num_Mid_7_7
      <Acct_Num_Mid_1_6
      104143</Acct_Num_Mid_1_6
      <AccountNumber
      1041430469940</AccountNumber
      <AcctGen-PrimaryContactId
      1-K5B-226</AcctGen-PrimaryContactId
      <Currency
      SAR</Currency
      <CurrentBalance
      </CurrentBalance
      <CustomerNumber
      </CustomerNumber
      <IntegrationId
      941674</IntegrationId
      <ProductId
      1-DFPY</ProductId
      <RB1ODS
      8290758</RB1ODS
      <STARSAccountBranchArabicName
        مكة المكرمة</STARSAccountBranchArabicName
      <STARSContactId
      </STARSContactId
      <STARSContactToRelation
      </STARSContactToRelation
      </FincorpAccount
      <FincorpAccount
      <Id
      1-LZ6-228</Id
      <Created
      05/21/2005 19:15:21</Created
      <CreatedBy
      0-1</CreatedBy
      <ABANumber
      Makkah Main</ABANumber
      <AccountName
      خالد جابر عبدالله الحربي</AccountName
      <AccountType
      Time Deposit</AccountType
      <Acct_Num_Mid_7_7
      1259940</Acct_Num_Mid_7_7
      <Acct_Num_Mid_1_6
      104143</Acct_Num_Mid_1_6
      <AccountNumber
      1041431259940</AccountNumber
      <AcctGen-PrimaryContactId
      1-K5E-241</AcctGen-PrimaryContactId
      <Currency
      SAR</Currency
      <CurrentBalance
      </CurrentBalance
      <CustomerNumber
      </CustomerNumber
      <IntegrationId
      942454</IntegrationId
      <ProductId
      1-DFPY</ProductId
      <RB1ODS
      8290759</RB1ODS
      <STARSAccountBranchArabicName
      مكة المكرمة</STARSAccountBranchArabicName
      <STARSContactId
      </STARSContactId
      <STARSContactToRelation
      </STARSContactToRelation
      </FincorpAccount
      <FincorpAccount
      <Id
      1-LZ6-229</Id
      <Created
      05/21/2005 19:15:21</Created
      <CreatedBy
      0-1</CreatedBy
      <ABANumber
      Makkah Branch</ABANumber
      <AccountName
      غميض مسفر مسيفر الهذلي</AccountName
      <AccountType
      Saving Account</AccountType
      <Acct_Num_Mid_7_7
      1509940</Acct_Num_Mid_7_7
      <Acct_Num_Mid_1_6
      104143</Acct_Num_Mid_1_6
      <AccountNumber
      1041431509940</AccountNumber
      <AcctGen-PrimaryContactId
      1-5W6-1401</AcctGen-PrimaryContactId
      <Currency
      SAR</Currency
      <CurrentBalance
      </CurrentBalance
      <CustomerNumber
      -1</CustomerNumber
      <IntegrationId
      942464</IntegrationId
      <ProductId
      1-DFPY</ProductId
      <RB1ODS
      8290760</RB1ODS
      <STARSAccountBranchArabicName
        مكة المكرمة</STARSAccountBranchArabicName
      <STARSContactId
      </STARSContactId
      <STARSContactToRelation
      </STARSContactToRelation
      </FincorpAccount
      <FincorpAccount
      <Id
      1-LZ6-230</Id
      <Created
      05/21/2005 19:15:21</Created
      <CreatedBy
      0-1</CreatedBy
      <ABANumber
      Makkah Main</ABANumber
      <AccountName
      مرزوق رده راسن السعيدي</AccountName
      <AccountType
      Current Account</AccountType
      <Acct_Num_Mid_7_7
      2909940</Acct_Num_Mid_7_7
      <Acct_Num_Mid_1_6
      104143</Acct_Num_Mid_1_6
      <AccountNumber
      1041432909940</AccountNumber
      <AcctGen-PrimaryContactId
      1-K5E-269</AcctGen-PrimaryContactId
      <Currency
      SAR</Currency
      <CurrentBalance
      </CurrentBalance
      <CustomerNumber
      </CustomerNumber
      <IntegrationId
      942794</IntegrationId
      <ProductId
      1-DFPY</ProductId
      <RB1ODS
      8290762</RB1ODS
      <STARSAccountBranchArabicName
      مكة المكرمة</STARSAccountBranchArabicName
      <STARSContactId
      </STARSContactId
      <STARSContactToRelation
      </STARSContactToRelation
      </FincorpAccount
      <FincorpAccount
      <Id
      1-LZ6-231</Id
      <Created
      05/21/2005 19:15:21</Created
      <CreatedBy
      0-1</CreatedBy
      <ABANumber
      Makkah Main</ABANumber
      <AccountName
      سلطان سلمان عليان المطرفي</AccountName
      <AccountType
      Current Account</AccountType
      <Acct_Num_Mid_7_7
      9409940</Acct_Num_Mid_7_7
      <Acct_Num_Mid_1_6
      104143</Acct_Num_Mid_1_6
      <AccountNumber
      1041439409940</AccountNumber
      <AcctGen-PrimaryContactId
      1-K5E-325</AcctGen-PrimaryContactId
      <Currency
      SAR</Currency
      <CurrentBalance
      </CurrentBalance
      <CustomerNumber
      </CustomerNumber
      <IntegrationId
      944194</IntegrationId
      <ProductId
      1-DFPY</ProductId
      <RB1ODS
      8290768</RB1ODS
      <STARSAccountBranchArabicName
      مكة المكرمة</STARSAccountBranchArabicName
      <STARSContactId
      </STARSContactId
      <STARSContactToRelation
      </STARSContactToRelation
      </FincorpAccount
      <FincorpAccount
      <Id
      1-LZ6-232</Id
      <Created
      05/21/2005 19:15:21</Created
      <CreatedBy
      0-1</CreatedBy
      <ABANumber
      Makkah Branch</ABANumber
      <AccountName
      محمد بابكر محمد بابكر</AccountName
      <AccountType
      Current Account</AccountType
      <Acct_Num_Mid_7_7
      9529940</Acct_Num_Mid_7_7
      <Acct_Num_Mid_1_6
      104143</Acct_Num_Mid_1_6
      <AccountNumber
      1041439529940</AccountNumber
      <AcctGen-PrimaryContactId
      1-K5E-68</AcctGen-PrimaryContactId
      <Currency
      SAR</Currency
      <CurrentBalance
      </CurrentBalance
      <CustomerNumber
      </CustomerNumber
      <IntegrationId
      944444</IntegrationId
      <ProductId
      1-DFPY</ProductId
      <RB1ODS
      8290769</RB1ODS
      <STARSAccountBranchArabicName
        مكة المكرمة</STARSAccountBranchArabicName
      <STARSContactId
      </STARSContactId
      <STARSContactToRelation
      </STARSContactToRelation
      </FincorpAccount
      <FincorpAccount
      <Id
      1-LZ6-233</Id
      <Created
      05/21/2005 19:15:21</Created
      <CreatedBy
      0-1</CreatedBy
      <ABANumber
      Makkah Main</ABANumber
      <AccountName
      عمر احمد آل عبدالمحسن القناوي</AccountName
      <AccountType
      Current Account</AccountType
      <Acct_Num_Mid_7_7
      759940</Acct_Num_Mid_7_7
      <Acct_Num_Mid_1_6
      104144</Acct_Num_Mid_1_6
      <AccountNumber
      1041440759940</AccountNumber
      <AcctGen-PrimaryContactId
      1-5W6-1257</AcctGen-PrimaryContactId
      <Currency
      SAR</Currency
      <CurrentBalance
      </CurrentBalance
      <CustomerNumber
      -1</CustomerNumber
      <IntegrationId
      944594</IntegrationId
      <ProductId
      1-DFPY</ProductId
      <RB1ODS
      8290770</RB1ODS
      <STARSAccountBranchArabicName
      مكة المكرمة</STARSAccountBranchArabicName
      <STARSContactId
      </STARSContactId
      <STARSContactToRelation
      </STARSContactToRelation
      </FincorpAccount
      <FincorpAccount
      <Id
      1-LZ6-8</Id
      <Created
      05/21/2005 19:15:21</Created
      <CreatedBy
      0-1</CreatedBy
      <ABANumber
      Makkah Main</ABANumber
      <AccountName
      بهاء عبد الله عبد الحفيظ مليح</AccountName
      <AccountType
      Current Account</AccountType
      <Acct_Num_Mid_7_7
      109940</Acct_Num_Mid_7_7
      <Acct_Num_Mid_1_6
      104108</Acct_Num_Mid_1_6
      <AccountNumber
      1041080109940</AccountNumber
      <AcctGen-PrimaryContactId
      1-K52-162</AcctGen-PrimaryContactId
      <Currency
      SAR</Currency
      <CurrentBalance
      </CurrentBalance
      <CustomerNumber
      </CustomerNumber
      <IntegrationId
      920224</IntegrationId
      <ProductId
      1-DFPY</ProductId
      <RB1ODS
      8290590</RB1ODS
      <STARSAccountBranchArabicName
      مكة المكرمة</STARSAccountBranchArabicName
      <STARSContactId
      </STARSContactId
      <STARSContactToRelation
      </STARSContactToRelation
      </FincorpAccount
      <FincorpAccount
      <Id
      1-LZ6-234</Id
      <Created
      05/21/2005 19:15:21</Created
      <CreatedBy
      0-1</CreatedBy
      <ABANumber
      Makkah Branch</ABANumber
      <AccountName
      عمر صدقة عمر قطب</AccountName
      <AccountType
      Current Account</AccountType
      <Acct_Num_Mid_7_7
      5769940</Acct_Num_Mid_7_7
      <Acct_Num_Mid_1_6
      104146</Acct_Num_Mid_1_6
      <AccountNumber
      1041465769940</AccountNumber
      <AcctGen-PrimaryContactId
      1-5WC-201</AcctGen-PrimaryContactId
      <Currency
      SAR</Currency
      <CurrentBalance
      </CurrentBalance
      <CustomerNumber
      -1</CustomerNumber
      <IntegrationId
      972664</IntegrationId
      <ProductId
      1-DFPY</ProductId
      <RB1ODS
      8290782</RB1ODS
      <STARSAccountBranchArabicName
        مكة المكرمة</STARSAccountBranchArabicName
      <STARSContactId
      </STARSContactId
      <STARSContactToRelation
      </STARSContactToRelation
      </FincorpAccount
      <Login
      SADMIN2</Login
      </ListOfBipStarsFincorpAccount
      </ListofIO
      Regards,
      Prashant