Skip to Content
avatar image
Former Member

Passing only selected accounts into the report

Hello folks,

I'm trying to create a webi report based on customer master data and am required to fetch information regarding selected accounts only (approx 200,000 accounts), Had it been few handful accounts, i'd use query filter to just bring results for desired accounts but this is way too much info to select from the list of values manually. I'm positive there's a better efficient way to achieve this result which I can't seem to figure it out at all. Can some one please help me with this ?

btw, I've been provided with an excel sheet containing list of accounts required for the report. Can you create two queries (one for customer master data from universe and the other for only required customer accounts from excel) and merge them to filter the report, is that possible ?

I'd really appreciate any insight/thoughts on this .


Thanks

Gaurav

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 15, 2015 at 10:23 PM

    Hi Gaurav,

    Yes you can create report which will have two data providers

    first will get data from Excel sheet & second one will get data from universe and then you can merge both the results.

    But as you are dealing with huge data I will suggest you to insert the excel data into database table and then join that table with the master customer table & apply filter condition on universe directly which in turns fetch less data & performance will be good.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thanks Swapnil, I appreciate your reply.

      I realized I'd need to pre filter the data so only those required accounts make it to the report and not everything. Prefiltering those random accounts is the main concern here, I've been provided with an excel sheet containing those accounts and there is no way I can use query filters to pass these values.

      Another alternative that we are looking into now is using the bex query to bring the required data on Bex analyzer or Analysis for office and take it from there.

      Hopefully, excel will come to our rescue here :-)

      Thanks again

      Gaurav