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
Mayank Gupta replied
Wrong forum. Refer thread - SAP Business Planning and Consolidation Topics (BPC)