Skip to Content

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 a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.