cancel
Showing results for 
Search instead for 
Did you mean: 

Integrate Master Data

Former Member
0 Kudos

Dear,

We are on BPC MS 7.5 SP5.

We encounter an error when we try to integrate master data between another data source and BPC. When we run the standard admin_makedim dtsx package, we get an error message: u2018Cannot find TempScheduleMbr<dimension name>: Location (MakeDimension)u2019.

We only get this error message when we select 'Scheduled Members Process' in the dtsx. When we deselect this function, the package runs successfully. Since processing the dimension is required to successfully integrate our master data, we need to be able to run this function using this selection.

Has anyone already encountered this problem?

Any help would be welcome.

Regards

Lander Vanmeenen

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello,

The problem has been solved. There were some issues with the data which I was trying to load.

Regards

Lander

Former Member
0 Kudos

Lander,

As part of your master data process, create a table named TempScheduleMbr<dimension name>, where <dimension name> is the name of the dimension. The structure of this table should be identical to the mbr<dimension name> table. Selecting 'Scheduled Members Process' in the dtsx will then cause BPC to read this "temp" table the same as it would the Excel file in Admin. This means it will be the source master data then applied to the mbr and dim table(s) as part of processing the dimension. The "temp" table will be dropped automatically at the end of processing.

I have never created this "temp" table manually, but we have the BPC admin app create this table and process our dims overnight.

Thanks,

Jason