Multiple values in Excel to use in Query parameter

building reports webintelligence
1

I am afraid it is not possible but wondering how you guys handle following issue.

I have a report which I need to run for a list of delivery numbers.
Lets say 100.
(they are random, so not nr 10 to 110, so between is also not a good option)

Now in list I will have to copy paste them all 1 by 1.
Of course this is not what I want to do.

Is there a way or a work around how you can make a report run for 100 (and even more) delivery numbers without having to copy and paste every number by hand?

rpinxt (BOB member since 2019-01-23)

2

Do you have the list in Excel?

If so then could you create a second query on the Excel list and use the results of this query as a filter for the first query?

IE so the first query returns results for only the desired delivery list values

Ross_BOXI (BOB member since 2018-04-17)

3

Well and end user should be able to maintain these values in the main query.

They will not have developer rights.
So don’t think that would work.

rpinxt (BOB member since 2019-01-23)

4

If the “list of items” is in excel, and it could be directly read from that excel, the “user” for this query doesn’t need developer rights.
The excel can be in the repository, query built upon that excel.
The user only (?) needs access to the query with refresh rights, AND access to the excel (within repository) with the rights to replace the excel (sorry: to update it … )
That last one can be done creating a dedicated folder for the excel, putting it there, and granting update rights on the folder content (maybe it’s edit rights? )

I’m not in a place with access to the BI system, so hard to look up the details, but the idea is:

  • user does NOT change the query in the document
  • user can “refresh” contents of the document
  • user has “enough” access to the excel document to use its contents in refreshing (for universes that was “data access” instead of “object access” which permits putting a universe object into the query)
  • user has access to the excel file, knows how to edit it without breaking the query, has a “replace or update” right on the excel file copy inside the BI repository

So IF the selection of parameters works with excel, the updating works as well.

BUT

is the work really simplified, when the user has to encode his parameter list in excel instead of having to check-box a list of prompts/invites ?

RensH :belgium: (BOB member since 2007-06-18)