Auto Dimension Issue

Symptom:
Auto-dimension feeds do not update the EPM client with the new dimension info even though feed processes successfully.   All the BPMC (ETL_DimName_FILT & mbr_Preload_DimName) and BPC backend tables (mbr_DimName & dim_DimNameH1, H2, etc.) update correctly to reflect the data in the feeds, but the EPM client does not display this information. User has to manually initiate an EPM Client-side Dimension Refresh to see this information.

Cause:

This is due to an issue in the Auto Dim functionality, where the EPM version is not updated in the BPC backend table that holds version information. Specified version numbers need to be incremented to notify the EPM Client to do an auto refresh, thereby avoiding the need to do a manual refresh.

This issue affects Pack 323 & 324.

Solution:

Copy and paste the SQL code below to the External Process of the Auto Dim Feed.

SQL Code to be Added:

-----------------------------------------------------

declare

                @ADMIN_DIM_CACHE decimal(20,3)

                , @VERSION decimal(20,3)

                , @XLVERSION decimal(20,3)

set @ADMIN_DIM_CACHE = (select cast(value as decimal(20,3)) + 0.001

from [!dst_apset].[dbo].[tblDefaults]

where Userid = '_Global' and KeyID = '!dst_app' and type = 'ADMIN_DIM_CACHE')

set @VERSION = (select cast(value as decimal(20,3)) + 0.002

from [!dst_apset].[dbo].[tblDefaults]

where Userid = '_Global' and KeyID = '!dst_app' and type = 'VERSION')

set @XLVERSION = (select cast(value as decimal(20,3)) + 0.002

from [!dst_apset].[dbo].[tblDefaults]

where Userid = '_Global' and KeyID = '!dst_app' and type = 'XLVERSION')

--print @ADMIN_DIM_CACHE

--print @VERSION

--print @XLVERSION

update [!dst_apset].[dbo].[tblDefaults]

set Value = @ADMIN_DIM_CACHE

where Userid = '_Global' and KeyID = '!dst_app' and type = 'ADMIN_DIM_CACHE'

update [!dst_apset].[dbo].[tblDefaults]

set Value = @VERSION

where Userid = '_Global' and KeyID = '!dst_app' and type = 'VERSION'

update [!dst_apset].[dbo].[tblDefaults]

set Value = @XLVERSION

where Userid = '_Global' and KeyID = '!dst_app' and type = 'XLVERSION'

------------------------------------------------------