For one of our reporting our requirement is as below. We have different customers and the data belonging to different customers is sitting in different databases. For the initial data load from the databases , we are maintaining an excel with the connection string information , database and table name information and then creating variables in qvw for the data in excel and loop the data load using for loop. So on one click we are getting data for different customers from different sources. We are doing the same in presentation layer calling all the qvds in a loop. My issue here is we are trying to have dimension labels according to the customer. let say I have dimensions like State, City, Region , so when I am loading the data in presentation layer in a loop, for Customer 1 the dimensions should look like CustomerState, CustomerCity, Customer Region, and for customer2 the dimensions should look like MemberState, MemeberCity, MemeberLoaction etc.. Moving forward we are looking to have different themes for different customers.The bottom line is the dimension label should change as per the customer. Please help me if there is a way I can work on this.
you need to create a flag for each source and then use that flag to set the label in a expression. But that would require that you have one customer selected at any time. What when you have all customers visible or customers from different sources? What should the label be?
Thank you very much for the quick reply. Can you please let me know how to create a flag, can you please post a sample qvw. And for the question you asked for what if all the customers are selected , in that case it would be generic labels like state, city, region..
