Skip to Content
0
Former Member
Dec 04, 2008 at 03:57 PM

New Dim Members not being recognized by BPC

63 Views

Hi Experts,

Recent development. New members are added to a Project dim used in a Revenue appset and processed. Default logic is then run in that appset that pushes select data to the Finance appset. So far so good.

When validating the data, we determined that we had a delta equal to the value in the Revenue appset that is associated with the new member that was added. Project: PRJ1358. It almost appears as though running default logic is looking at the Default.lgx instead of the lgl. I processed the default logic which updated the lgx with the new Project member, reran default logic and now the data ties.

*Calculate_Difference = 0

*Destination_App = Finance

*Skip_Dim = Project

*Skip_Dim = ProdVideo

*Select(%VidProd_Acct%,"[ID]","ProdAcct","ToFinance<>'' ")

*MEMBERSET(%VidProd_DataSrc%,"Descendants([DataSrc].[Total_DataSrc],999,LEAVES)")

*MEMBERSET(%VidProd_Project%,"Descendants([Project].[AllProjects],999,LEAVES)")

*MEMBERSET(%VidProd_ProdVideo%,"Descendants([ProdVideo].[TtlVidProds],999,LEAVES)")

*XDIM_MEMBERSET ProdAcct = %VidProd_Acct%

*XDIM_MEMBERSET RPTCurrency=LC,USD,EUR

*XDIM_MEMBERSET Project = %VidProd_Project%

*XDIM_MEMBERSET ProdVideo = %VidProd_ProdVideo%

*WHEN Category

*IS = "ACTUAL","Forecast","Budget"

*Rec(Factor=1,ProdAcct =ProdAcct.ToFinance)

*ENDWHEN

*Commit

A second example, is our SSIS package that loads data to the Revenue appset. It runs a stored procedure that removes any records from the Fact table if the member for the Project dim is not in the application's DBO.MBRPROJECT table (of course the offending member is added to a kickout table). The package then goes on to fail with the message The attribute key cannot be found: Table: dbo_tblFactVideoProduct, Column: PROJECT, Value: PRJ1358 which seems to indicate that the project IS in the DBO.MBRPROJECT table, since the record was not deleted, but BPC does not recognize PRJ1358 as a valid member.

Why would BPC not recognize the new member??? Any thoughts? Thanks in advance!