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,
