Forum Discussion

rocky09's avatar
rocky09
Solution Sage
8 years ago

Passing Multiple parameters to Oracle Query

I have this below Oracle Query using in PowerBI.  I need to Pass two Parameters to the Bold Highlighted.

 

 

With mgnno As
   (Select Plan_Number From ALLSub.Z_MGT_Roylce_Log@KGN_OP
    Where MGT_Source = 'USB' and Year_Month = 201805 -- Recent Year Month
    Minus
    Select Plan_Number From ALLSub.Z_MGT_Roylce_Log@KGN_OP
    Where MGT_Source = 'USB' and Year_Month = 201804) -- Previous Year Month
Select Distinct substr(M.Year_Month,0,4) || '-' || substr(M.Year_Month,5) Ld_Yr_Mth,
    M.account_name, M.Subscriber_name, M.Address, M.Country, Substr(M.Plan_Status, 10) Status
From ALLSub.Z_MGT_Roylce_Log@KGN_OP M
inner join mgnno l on l.Plan_Number = z.Plan_Number

 

I have created Two Parameters. One is RecentYearMonth and other is PreviousYearMonth.

 

My question is, how do i pass the above Parameters to the above query.  Also, I want this to be dynamic. I want to compare the data with two given months.  , Any idea, how do i achieve this.

 

 

 Phil_Seamark MFelix Anonymous Zubair_Muhammad

 

Thank you in advance,