EPM Agent SQL parameters — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

EPM Agent SQL parameters

We have this source query which is working well (see below), but we need to add a bit to update the period value.

For example, if the EPM period (~Period~) is 02 then @Period needs to become 5; 03 becomes 6 and so on and so forth.

Assuming we don't have access to a SQL Server Developer to assist in this case, is there some SQL we can apply here to update the @Period variable on the fly?

USE [SPDW]

BEGIN

DECLARE @return_value int

EXEC @return_value = [dbo].[sp_GRP_TrialBalanceUploadORA]
@Site =~Entity~,
@FY =~Year~,
@Period =~Period~

SELECT 'Return Value' = @return_value

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!