This:
or
it is just a string ("All" or "" might work as well, but I didn't try it).
I would recommend reviewing the Source ID concept in the Design and Reference Guide. The Source ID is determined by the value set in the Data Source and is populated for each data record during the Import process in Stage.
In most cases, data records loaded to the Staging tables are transformed and validated prior to loading to the Cube. If you clear out the data records in Stage, it doesn't mean that you clear data from the Cube. You break the link between the data records from the Stage to the Finance Engine. Therefore, you have data in the Cube but no audit back to the data records in Stage that make up that Cube data. Not sure how you plan on using this function but something to keep in mind
Thank you for your reply. I plan to use the function as a preliminary step before using the ExecuteParseAndTransform function within an extensibility rule.
