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

Register | Login 

 
Realtime CMS Reporting from Infolytik (Opens a new window)  

General Notice: No events within the next 45 days.

Variable with dynamic inlist


 
Search this topic... | Search WebIntelligence XI... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> WebIntelligence XI  Previous TopicPrint TopicNext Topic
Author Message
BI.User
Senior Member
Senior Member



Joined: 22 May 2007

Posts: 81



PostPosted: Wed Oct 14, 2009 4:53 am 
Post subject: Variable with dynamic inlist

I have a Column in Infoview like below..
Table values:
Col1
wwwwAAA
xxxxAAA
yyyyAAA
zzzzAAA
wwwwBBB
xxxxBBB
yyyyBBB
zzzzBBB



All the values ends with either AAA or BBB and these will be given as prompt. So if user selects ‘AAA’ in prompt I need to select all Col1 values where it ends with AAA.

Can anyone help me how to create variable for this.
Back to top
dessa
Forum Enthusiast
Forum Enthusiast



Joined: 29 Jan 2004

Posts: 2333


flag
PostPosted: Wed Oct 14, 2009 5:02 am 
Post subject: Re: Variable with dynamic inlist

Use the "Matches Pattern" function in your prompt.
_________________
BOXI 4.0 SP2 FPx
Oracle
Netezza
SQL Server
Back to top
BI.User
Senior Member
Senior Member



Joined: 22 May 2007

Posts: 81



PostPosted: Wed Oct 14, 2009 5:24 am 
Post subject: Re: Variable with dynamic inlist

Dessa, Thanks for your reply.

But in prompt AAA will not be directly giving, i have description for AAA and BBB in different LOVs. Say if AAA description wll "All Accounts". So in variable I am trying to do the below logic.


=[Col1] where ([Col1] inlist(concatenation(substr([Col1];1;4);if(userresponse("Select Values")="All Accounts";"AAA";"BBB"))))


Above the code is not correct, I am just trying to explain the requiremnet.


Thanks
Back to top
dessa
Forum Enthusiast
Forum Enthusiast



Joined: 29 Jan 2004

Posts: 2333


flag
PostPosted: Wed Oct 14, 2009 6:37 am 
Post subject: Re: Variable with dynamic inlist

Is your requirement to find all values with "AAA" or is it to place an "All Values" option in the prompt?

The first scenario should work with Matches Pattern, the second scenario is covered by a stick topic in the Universe forum.

Or do you want to change the LoV to sat "AAA" "BBB" etc?

_________________
BOXI 4.0 SP2 FPx
Oracle
Netezza
SQL Server
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> WebIntelligence XI  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.0715 seconds using 17 queries. (SQL 0.0266 Parse 0.0348 Other 0.0101)
CCBot/2.0 (http://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