USP_OLAPREFRESHPARAMETER_GETOLAPDATASOURCEID

Retrieves the OLAP data source ID for the OLAP refresh process.

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy



CREATE procedure dbo.USP_OLAPREFRESHPARAMETER_GETOLAPDATASOURCEID

/* 
Retrieves the OLAP data source ID for the OLAP refresh process.
*/

@ID uniqueidentifier

as

set nocount on;

select
    [OLAPDATASOURCEID]
from
    [dbo].[OLAPREFRESHPROCESS]
where 
    [ID] = @ID;

return 0;