Skip to Content
0

How to mass update BPC dimension table through the web interface

Apr 26, 2017 at 06:26 PM

53

avatar image

Our business recently updated to HANA BW and BPC has suffered from it in my opinion. Previously I could copy 1,000 lines from excel and paste directly to the dimension table to mass update an attribute in a dimension table on the web. Since HANA the web dimension table is very hard to work with and it is hard enough altering one cell, let alone 1,000 in mass. How do I mass update, as an example, an account hierarchy in the web interface dimension table?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Apr 26, 2017 at 06:48 PM
0

For mass update please use import from text file - absolutely easy!

Show 4 Share
10 |10000 characters needed characters left characters exceeded

Are there instructions on where this is located? I do not see that option. Even a screenshot would be enough for me.

0

Sorry, but it's a basic BPC knowledge...

You have standard Data Manager packages in EPM Excel client to export dimension master data to text file.

Then you can open this text file in Excel, correct what you want and save back to csv text.

Then import this file using standard DM package for import from text file.

https://help.sap.com/viewer/ec68e48b18a44a49abb12b8ee8ae306f/10.0.28/en-US/f9c67b536faf1014878bae8cb0e91070.html

https://help.sap.com/viewer/ec68e48b18a44a49abb12b8ee8ae306f/10.0.28/en-US/f9c506c56faf1014878bae8cb0e91070.html

0

Unfortunately I am effectively a business user where we have no consistent support so I do not have all of the common knowledge an admin would have. I see what you are talking about but we must have customized our package list to not include that at the moment apparently. I know what I need to ask our consultant to do though now. Thanks for the help!

0

Then please accept the answer and close the question!

0