Load master data using input schedules

[Former Member]

Hi all,

Does there exist a way to load and modify master data using input schedules?

Regards,

Nithya

[Former Member · Accepted solution]

Hi Nithyapriya,

Chiming in here to 2nd Joost's statement above. As of BPC 5.1 version, it is not possible to update master data from an Input schedule.

Whether that's possible in other products or with BPC 7.0 NW (currently in Ramp-up), is another story. For now, the general answer is that it's not possible.

This is a known area for improvement with BPC at this time, and we're sure to hear more about either integration with NetWeaver or some other methods of making things more dynamic, or with SSIS packages, etc.. in the future.

Edited by: garrett tedeman on Sep 2, 2008 7:20 PM

[Former Member]

Hi Guys,

Thank you so much.

Regards,

Nithya

[Former Member]

Not onl BPC, but even in other planning tools, you cant update master data y such methods. In BPC NW since it is integrated, you should be able to manually add records to master data. But never with input schedules.

Ravi Thothadri

[Former Member]

No this is not possible. The only 2 ways to update masterdata in BPC is via the Administration console or via a SSIS package. Adding members to a dimension via input schedules is not a very good idea since the cube needs to be processed and so it takes the application offline. You don't want to give this ability to all the users, but just to the administrators.

-Joost