Infor BI 11 Application Studio: Scripts for filter more than one criteria

unknown

Dear Friends,

 

Regarding I'm developing Infor BI 11.0 report with Application Studio.

Create one filter like Start Year to End Year is fine, for example Year " 2010 " to Year " 2016 ". My bar chart can shown graph correctly.

 

Can anyone suggest how to create a function like summary value(such as Sales amount) from multi-selection of Start Month to End Month, if I want to make a filter more than one criteria like below?

[Filter #1] Year ( choose from Start Year to End Year ) for example " 2010 " to Year " 2016 "

[Filter #2] Month ( choose from Start Month to End Month ) for example, " JAN " to " JUN "

[Filter #3] Region ( choose one of them ) for example, " NORTH " or " SOUTH "

 

Thank you in advance for your kindly help.

 

Regards,

Pornchai

unknown

Further details.

Please see below for defined value filter by Start Year to End Year and graph shown correctly as follows:

How can we make it shown graph correctly follow by filter by Start Year to End Year, then Start Month to End Month?



=ROC("Multidimensional1","Service","[Age Flag].[b Age Desc].[All]","[Branch].[Hierarchy].[All]","[CC Flag].[Cc Desc].[All]","[Condition Flag].[Condition Desc].[All]","[License Type].[Plt Prn Desc].[All]","[Measures].[Amount]","[Month].[Month Desc].[All]",N83,"[Sex Flag].[Sex Desc].[All]","[Time].[Year - Month - Date].[All]","[Training].[Flag Desc].[All]",M84)



Please advise. Thanks.

Pornchai

dp_dEPM-126_01_Introducing the Decision Packages.mp4