...
Code Block |
---|
USE [cereports]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[a2_mkt_unified_build]
SELECT 'Return Value' = @return_value
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[vw_admissions_summary_build]
SELECT 'Return Value' = @return_value
GO |
Note: This process should be run after ETL and before the daily refresh of the Power BI Communications and Marketing report.