BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

[Webi 4.x] Multiple values in Excel to use in Query parameter


 
Search this topic... | Search Web Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Author Message
rpinxt
Senior Member
Senior Member



Joined: 23 Jan 2019

Posts: 53



PostPosted: Wed Jun 12, 2019 2:45 am 
Post subject: Multiple values in Excel to use in Query parameter

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?
Back to top
Ross_BOXI
Senior Member
Senior Member



Joined: 17 Apr 2018

Posts: 55



PostPosted: Wed Jun 12, 2019 6:44 am 
Post subject: Re: Multiple values in Excel to use in Query parameter

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
Back to top
rpinxt
Senior Member
Senior Member



Joined: 23 Jan 2019

Posts: 53



PostPosted: Wed Jun 12, 2019 6:46 am 
Post subject: Re: Multiple values in Excel to use in Query parameter

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.
Back to top
RensH
Principal Member
Principal Member



Joined: 18 Jun 2007
ASUG Icon
Posts: 147


flag
PostPosted: Thu Jun 13, 2019 6:00 am 
Post subject: Re: Multiple values in Excel to use in Query parameter

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 ?

_________________
Transitioning to : XI 4.2 (SP3)
(Mostly WebI docs using universes, no voyager etc -yet- but (very few) dashboards )
LDAP eDirectory , repository on oracle.


Phasing out : BI 4.1 SP5 . Mostly Webi.
Phased out : BO-XI 3.1 SP6 . Mostly Webi.
Phased out : BO651, full clients. No Webi.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0275 seconds using 17 queries. (SQL 0.0027 Parse 0.0008 Other 0.0239)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo