Optional Parameter in MDX
Hi, I have a parameter "Customer" in which the user can enter a customer number and hit "view Report" and the report looks up data for this specific customer. In the same report I also a multiple customer selection parameter which I would like incoporate in with the above. (I am using a OLAP cube and Report Builder 3.0) So what I want: 1) If the user enter a customer number it should still look up data for this specific customer 2) If the Customer parameter is blank - the dataset should then return all data - so that the user can use the multiple customer selection instead I have attached a part of the Where clause below (where @Customer is the parameter of the Customer specific number lookup as mention in 1) STRTOSET(@LastUpdateLastUpdate, CONSTRAINED), [LastUpdate].[LastUpdate].currentmember ), [ProjType].[ProjType].[All ProjType] , StrToSet(@Customer ))CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS How to incorporate a solution for this...? Thanks in advance.
June 9th, 2012 3:37am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics