Skip to Content
0
Former Member
Mar 26, 2009 at 05:38 PM

SSIS Pkg to Process Members from Member Sheet

21 Views

BPC 5

Is there a way to process dimensions with Data Manager which mimics the Process members from member sheet option available in the Admin console? I have tried the provided Admin_Makedim package but it will not run without supplying a table name. According to the documentation, I thought that if a table wasn't provided, it would use the member sheet. However, I think the documentation is outdated.

I realize that I can create tasks to clear the mbr table and then load the data to there as I am doing that with some dimensions where I get flat files from BI. However, there are other dimensions where we want our users to maintain in Excel outside of BPC. I simply want to replace the membersheets in the adminapp directory and then process those dimensions.

Thanks,

--Brent