<p>Hi,</p>
<p>I’m using Analytics Designer v16 and trying to find a way to set dynamic parameters for a report made from a FastDb data source. I can easily make one in SQL using a query like below and then editing the parameter created from the query.</p>
<p> </p>
<p><strong><span style="color:#7f0055;"><span style="font-family:consolas;"><span style="font-size:10pt;">SELECT</span></span></span></strong><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;"> dbo.Member.MDz_Fund_Name, </span></span></span><strong><span style="color:#7f0055;"><span style="font-family:consolas;"><span style="font-size:10pt;">sum</span></span></span></strong><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;">(dbo.MemberSnapshot.MSf_Balance_Amount) </span></span></span><strong><span style="color:#7f0055;"><span style="font-family:consolas;"><span style="font-size:10pt;">as</span></span></span></strong><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;"> Balance, </span></span></span><strong><span style="color:#7f0055;"><span style="font-family:consolas;"><span style="font-size:10pt;">count</span></span></span></strong><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;">(</span></span></span><strong><span style="color:#7f0055;"><span style="font-family:consolas;"><span style="font-size:10pt;">distinct</span></span></span></strong><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;"> dbo.Member.MDz_Member_Code) </span></span></span><strong><span style="color:#7f0055;"><span style="font-family:consolas;"><span style="font-size:10pt;">as</span></span></span></strong><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;"> MemberCount</span></span></span></p>
<p> <strong><span style="color:#7f0055;"><span style="font-family:consolas;"><span style="font-size:10pt;">FROM</span></span></span></strong><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;"> dbo.MemberSnapshot, dbo.Member, dbo.Date</span></span></span></p>
<p> <strong><span style="color:#7f0055;"><span style="font-family:consolas;"><span style="font-size:10pt;">WHERE</span></span></span></strong><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;"> dbo.MemberSnapshot.MSl_Member_Id </span></span></span><strong><span style="color:#7f0055;"><span style="font-family:consolas;"><span style="font-size:10pt;">=</span></span></span></strong><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;"> dbo.Member.MDl_Member_Id</span></span></span></p>
<p> <strong><span style="color:#7f0055;"><span style="font-family:consolas;"><span style="font-size:10pt;">and</span></span></span></strong><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;"> dbo.MemberSnapshot.MSs_Date_Id </span></span></span><strong><span style="color:#7f0055;"><span style="font-family:consolas;"><span style="font-size:10pt;">=</span></span></span></strong><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;"> dbo.Date.DTs_Date_Id</span></span></span></p>
<p> <strong><span style="color:#7f0055;"><span style="font-family:consolas;"><span style="font-size:10pt;">and</span></span></span></strong><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;"> dbo.Date.DTd_Date </span></span></span><strong><span style="color:#7f0055;"><span style="font-family:consolas;"><span style="font-size:10pt;">=</span></span></span></strong><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;"> ?</span></span></span></p>
<p> <strong><span style="color:#7f0055;"><span style="font-family:consolas;"><span style="font-size:10pt;">Group</span></span></span></strong> <strong><span style="color:#7f0055;"><span style="font-family:consolas;"><span style="font-size:10pt;">by</span></span></span></strong><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;"> dbo.Member.MDz_Fund_Name</span></span></span></p>
<p> </p>
<p><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;">I can also successfully create and use a dynamic filters for a BIRT JBDC Data Source (SQLServer) but when I follow the exact same process for a report using FastDB data source it doesn't work.</span></span></span></p>
<p> </p>
<p><span style="font-size:10pt;">Attached is a document with screenshots of the two </span><span style="font-size:13.3333px;">different</span><span style="font-size:10pt;"> data sources. Any information about dynamic paramaters or filters for Fastdb dat soruces, or if there's any more information revelvant to this scenario that would be much appreciated.</span></p>
<p> </p>
<p><span style="color:#000000;"><span style="font-family:consolas;"><span style="font-size:10pt;">Thanks</span></span></span></p>
