Cascading Input Parameters Implementation

General
#1

Hi Team Helical,

I have implemented cascading input parameters by following the blog.

The cascading input parameter is working fine. Based on the “year” selected the “months” are being displayed.

However at dashbaord level when I changed the “Year” to multi-select the “months” filter is not rendering. Below I am also sharing the EFWD file for your reference. Please help me out.

<EFWD>
<DataSources>
<Connection id="10" type="global.jdbc">
<globalId>10</globalId>
</Connection>
</DataSources>
<DataMaps>

<DataMap id="1" connection="10" type="sql">
<Name>Year</Name>
<Query>
<![CDATA[
select distinct Year as Year
from EZX_INVOICE_HEADERS_DIM
ORDER BY Year DESC

]]>
</Query>
</DataMap>

<DataMap id="2" connection="10" type="sql">
<Name>Month</Name>


<Parameters>
<Parameter name="Year" type="String" default="2019"/>
</Parameters>

<Query>
<![CDATA[
select distinct Month as Month	From EZX_INVOICE_HEADERS_DIM
WHERE Year IN (${Year}) ORDER BY Month	
]]>
</Query>

</DataMap>

</DataMaps>

</EFWD>

Thank You.

1 Like
#2

Hello Marc,

When you are passing multiple years to the month filter the filter type of that month filter has to be a collection and not string. The string will work fine when it’s a single select.

Right now in your SQLQuery, it is specified as string only and that’s why it’s not working. Plz change it to the collection and it will work fine for multiple values

Hence change it from
<Parameter name="Year" type="String" default="2019"/>

to

<Parameter name="Year" type="Collection" default="2019"/>

Thank You
From
Team Helical.