BPC Standard- Can you change Attribute Text from Excel EPM?

[former_member778650]

Using BPC Standard 11.1 on S4 Hana -
From an Excel Input form, we'd like the ability to change the text in an attribute for a given member that is then pushed into the data hierarchy and changes the attribute...without going to the Administrator Web app and making that change to the attribute.

As a for instance, assume that there is a Product dimension with Member ID "Widgets" and an attribute for Product called "Country of Origin." From Excel, we'd like to be able to change what is being shown in the "Country of Origin" Attribute of the Product Member "Widgets" from a starting point of Attribute "Canada" to an ending point Attribute of "Australia." The goal is to be able to be able to do this from Excel without going back into Administrator Web App. Wondering if perhaps a clever way to do it using VBA or Data Management Packages.

Any ideas appreciated.

[former_member778650]

Thanks Vadim. I looked through the Master Data on the Fly posts, but was having trouble finding a posting with the BPC Standard 10 or 11 coding. I did see Embedded and Standard w/ Net Weaver. Maybe I can use those? Thanks

[former_member186338]

Sorry, this post is not an answer to your question. Please respect forum rules and use comments instead of "answers"

Master data on the Fly for BPC Standard 10

https://archive.sap.com/kmuuid2/2020b522-cdb9-2e10-a1b1-873309454fce/Master%20Data%20on%20the%20Fly%...

[former_member186338]

Just search for "Master Data on the Fly"!

It's not a perfect solution but nothing else is available.

It's a badi that have to be launched in DM package.