on 10-15-2014 11:26 AM
Hi Experts,
I checked over different How To, SCN, but did not find any contains.
How can I load automatcally masterdata to bpc 10 ms , for only selected properties,
I mean that some properties are maintained directly in BPC admin,
although, others have to be loaded from the BI,
Any tips to advices,
tks a lot,
Hi Olivia
You can build a Data Manager package or create a package in SSIS that would be scheduled to run automatically and import the information from the system of your choice.
Once the data is imported you will need to process the dimensions and the SSAS cube.
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Olivia,
in addition to Stefan's reply, if you only want to update some property values you can add a "Slowly Changing Dimension Task" to your package and configure it to update only the dimension properties you need.
The "Slowly Changing Dimension" transformation provides the following functionality for managing slowly changing dimensions:
Hope this helps.
Kindest regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.