Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SSIS packages to update dimensions

We are having a technical problem with dimension members refreshing after an insert of a new member into the mbr table through an SSIS package

When a new record is inserted into the mbr table, using a sql insert statement and a full process of the application occurs, that member is viewable in Current view BPC Excel after the dimension members are refreshed. However, the new member is not viewable on the Current View of BPC Web, until an individual process of the dimension occurs via BPC Administration (i.e. not a full process of the application).

Do you now of a way to process dimensions rather than applications from ssis tasks

and do you know what SQL layer process is required to get the web POV updated

Former Member
Former Member replied
Not what you were looking for? View more on this topic or Ask a question