Forum Discussion
rocky09
8 years agoSolution Sage
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,
2 Replies
- v-yuta-msftCommunity Support
Hi rocky09,
For details about Dynamic Data Masking in Query Parameter, please refer to this blog:
Regards,
Jimmy Tao
- rocky09Solution Sage
Thank you for the reply. I will check . So, there is no alternative for this situation?