Data gets loaded into a datasource (LOAD). Data is moved from datasource to rowsource via a stagemap (STAGE).But we are facing issues while loading incrementally the row sources.
1. When new data is loaded into data source that the row source is built on, the new rows are not loaded into the rowsource
irrespective of using replace/update with load command.
User override takes precedence over loaded values. It does change the loaded value, but you can't see the change until you delete the override.2. Also if the row source measure has been updated in the planning sheet, but that measure details have changed in data source, it does not get over written in >>the scenario/row source.
Data is stored in the rowsource. You would need to remove it from the rowsource if you want the value to not be stored in the rowsource.3. When rows are deleted from the data source, tehy are not deleted from the row source.
It is not normal to delete members from a dimension, as doing so deletes any data associated with any intersection of that dimension member.4. Also we got a warnign while trying to load BOM Dimension which is a variable(row source) based dimension. Are we right in assuming, since it is based on the >>row source, we do not need to load dimension again?. Also members are not being deleted from the dimension.