The user data context is set by loading a CSV file onto the server for an ElastiCube.

Here is a sample CSV file content for loading context:

1.       userid - optional (not referenced) ,call it whatever you'd like.

2.       userName@mailProvider.com - name of the user to whom the data context will be
set by the current row properties.

3.       Table.Dimension - dimension naming convention. Each column  represents allowed
members per user. Set as many columns as you wish.

4.       Member1;Member2;… - members separated by semicolon (';'). Members refer to the current row user,
on the current column dimension. You can set an empty cell if you don't the user to be
restricted to any values subset.

For example,  when querying ‘Products’ dimension on ‘US laptop Sales’ table (on the ElastiCube that the Data Context was applied to), member HP NX530 can only exist in the query result for user  userName2@mailProvider.com, while the other two users will not see it.

Good to know:

1. Loading a new file clears all current ElastiCube data context settings.
2. In order to reset ElastiCube data context settings, load an empty (whole file empty or user rows part empty) file.
3. Last user wins – when same user appears more than once, lowermost row is updated.

Import Validations:

1. CSV must be in valid format (same column count for all rows).
2. UserId cannot be empty.
3. Dimension header (name) cannot be empty.
4. CSV file should not be locked by any other program while setting data context.