Can you create a custom sql and do a join there of all your tables. Create one parameter for a country and pass that to your sql query and create the rest as filters. Prepopulate all the countrys as a static list of values in your parameter. When you publish, select one country of your choice and publish it. All the other filter values would be populated for that country you select. Basically each time you select a country, that would be the main driver.
Thanks Sirish. I'll give this a shot and let you know if I have any problem. I appreciate the help!
He is what's happening ..I have two sql queries. I'm one I have to get x'oy ( think of select * from table where ...or field =x'oy) so that x'oy is also included. Now think that this query returns one grand total. Remember x'oy is how it is stored in the database. Now the other query had a where condition.. Where a parameter gets passed. So it's failing when x'oy is passed to it as parameter to this query.
Select * from x where field = x'oy works in teradata... So I think i need to basically mimic the same behavior when passed as a parameter for this value.
Sent from my phone.