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