We have an Analytical view named as "AN_WARRANTY" whose data preview is as below-:
We are trying to create one Calculation view on top on Analytical view where we require to use "Fiscal_Year_Week_Name" attribute in where clause. and the requirement is when the user input the value of "Fiscal_Year_Week_Name" then it will show the previous 5 week data in advance means.
For example if user input FY10W03 then in the output it should show the detail of previous 5 week data ie. FY10W02,FY09W03,FY08W49,FY08W44,FY08W41.
But the problem is when we tried to create the variable for user input that will filter the value to 1 value only and when we use input parameter then it will not shows us attribute value("Fiscal_Year_Week_Name") as an option to select the values .