Skip to Content
0
Former Member
Jul 05, 2013 at 07:15 AM

Problem in creating Input parameter

22 Views

Hello folks,

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 .

Attachments

pastedImage_0.png (11.1 kB)