Pass Multiple Prompt Values Dynamically in a Publication

[Former Member]

Hello

I have a dynamic list for list for my Publications of a Web Intelligence Document. The dynamic list has the following columns names

ID

Name

Email

Zone

and the Web Intelligence document has the columns:

Zone

Sales Value

I can't use Profiles because some of the recipients in the dynamic list do not have a BOE account

Lets say I use the following values

ID = 1   

Name = Sally 

Email = Sally@mytown.com

Zone = USA

This works fine and if I change the value of the Zone to another single value, (maybe Sally has been reallocated to a different Sales Region) for example:

ID = 1   

Name = Sally 

Email = Sally@mytown.com

Zone = UK

then this also works fine and the output from the Publication shows the correct value.

However, when I try and do the following, I run into problems:

ID = 1   

Name = Sally 

Email = Sally@mytown.com

Zone = USA;UK

The resultant output is blank!!! The prompt that is in my document that I want to burst is set to optional. I've tried using:

semicolons: for example USA;UK

commas: for example USA,UK

brackets and semicolons: for example (USA;UK)

brackets and commas: for example (USA,UK)

but nothing works and the resultant output is empty

Also, passing in a blank value for the optional prompt to return everything but this does not work either and the resultant output is empty.

I can't believe that this is not possible and would welcome any suggestions.

Thanks in advance.

Julian

[Former Member]

Julian,

Did you ever find a solution for this? I ran into the same issue where I am trying to send reports to a Location ID, where users can be in multiple locations and would need one report containing data from both locations.

Thanks,
Dustin

[arijit_das]

Did you try having two rows in the webi ?

ID	Name	Email	Zone
1	Sally	Sally@mytown.com	USA
2	Sally	Sally@mytown.com	UK

[Former Member]

ZHello Arijit

Because that is just 2 individual values I know that would work, but its not going to be suitable for my needs. In reality, my dynamic list will look more like below and will contain a lot more people too.

ID	Name	Email	Zone	Region	Item
1	Sally	Sally@mytown	USA
2	Mary	Mary@mytown.com	USA	California
3	Jim	Jim@mytown.com	UK	North	Coats
4	Bill	Bill@mytown.com			Coats
5	Fred	Fred@mytown.com	USA;UK		Jeans;Belts

My Web Intelligence Report that needs to be burst/published has the columns

Zone

Region

Item

Sales

Zone, Region and Item are also Optional Prompts so, in the case of "Sally" above, she should get all items for all regions in USA, Bill should get Coats in all Zones and all regions etc etc

Thanks

Julian