Hi,
We are new to BPC and currently working in a test environment. We are having issues with importing measure data against dimensions that we are attempting to automate via SSIS. I will apologize in advance for the long post, but want to give as many details as possible.
Here is the scenario:
We installed BPC v. 5.1 SP1 on SQL Server 2005, but have since installed SP2 and SP3.
We created our own app set as a copy of AppShell. We added some user defined dimensions and created a custom application as a copy of Finance.
For initial testing, we loaded members into all dimensions via the Admin console and the Excel member sheets. We also used the Import function in data manager to upload measure data into our custom application.
We are now trying to automate the population of members for some of our dimensions (Entity and 4 user defined dimensions).
All of our data is mastered in SAP (we're on ERP 2005/ECC 6.0) with replications to our BI system (7.0). We are using custom ABAP programs to create flat files for 3 of the dimensions. For 2 dimensions, we are extracting from BI via Open hub.
We have created SSIS packages to load data from the files into the relevant mbr tables. We're taking things one step at a time and currently are processing the dimensions manually via the Admin Console - making sure that "Process members from member sheet" is unchecked.
In our first attempts at loading dimension data via the SSIS package, we tried loading only a subset of the member data (forgetting about the measure data that had previously been loaded). Because we were missing members in the load files for which measure data existed, we received data integrity errors upon processing the dimensions. Once we loaded the full member data, the dimensions processed successfully.
Our issue comes now when we're again importing measure data. Before starting to "automate" our dimensions, I had successfully loaded several months worth of measures. I had also tested clearing out one month of data. Now, I am trying to reload that month of measure data. I am using the same file as I had used previously, but the Import function is now rejecting all records. The dimension members it is rejecting are valid dimension members, but they are all from dimensions we are attempting to automate.
Has anyone encountered an issue like this before? Even if you haven't, do you have any thoughts on what our issue might be? Any help would be greatly appreciated!
Thanks!
Shannon