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'
------------------------------------------------------
