Problem in creating Input parameter

[Former Member]

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 .

[Former Member]

Hi Ruchi,

Little confused here, what is the logic used while deciding which 5 previous weeks data has to be displayed? As per the example you have given the previous 5 weeks are not in any particular order.

Did you mean for input as FY10W03, the output shown should be for FY10W02,FY10W01,FY09W53,FY09W52 and FY09W51?

Regards,

Rudrabhupal PB.

[Former Member]

Hi Jain,

According to your explanation, I think that you need to create one calculation column "FYWEEK" base on "Fiscal_Year_Week_Name" as well,

such as "FY10W03" convert to 1003, then you fetch top 5 from analytic view or calculation view where "FYWEEK" <1003 order by FYWEEK desc.

Regarding as input parameters, you can create static list or base on column to input parameters.

hope this can help you.

Regards,

Jerry