Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 30, 2008 at 03:12 PM
    Add comment
    10|10000 characters needed characters exceeded