I´m trying to load data inot BPC cubes with data manager in BPC and when I run packkage the status shows this:
1. Convert Data: completed in 0 sec.
2. Load and Process: Failed in 13 sec.
3. Import: completed in 13 sec.
Record Count : 45
Accept Count : 45
Reject Count : 0
Skip Count : 0
ActiveX component can't create object
What I conclude from this is that the data in the flat file is ok but can be writen to the cubes because of an error with the ActiveX component. I have read diffrent threads about ActiveX components errors but I havent found any solutions that works for me. The Workstatus for the dimensions are all set to No and when I run the package I have chooose the settings Merge data and Dont check workstatus, I have even tried to set the settings to Replace and Clear data.
Do anyone have another suggestion of solution?