Automated MDX library for creating dynamic reports and views using Planning Analytics. The purpose of this accelerator is to allow developers and users to easier create user based dynamic subsets using a pre-built library of MDX expressions and inputs. The accelerator also allows users to create their own custom MDX sets using the SET_CUSTOM subset selection element.

Benefits

1. Flexible user driven dynamic subsets for page, row and column level
2. Pre-Defined MDX standard expression per user
3. Custom MDX expressions per user
4. User level MDX expressions
5. Dimension level expressions
6. Multiple expressions per user and dimension
7. Planning Analytics Subset Selection Portal

Features

1. Subset Control cube to store Dynamic Subset Expressions
2. Subset Selection cube to store Dynamic Subset Selections
3. Subset Control cube pre-built rules engine
4. Ability within Subset Control to create static or dynamic subsets
5. Turbo Integrator process to create pre-built subsets based on subset control definitions
6. Subset Selection cube pre-built rules engine
7. Subset Selection picklist engine based dimension elements, hierarchies and subsets within each dimension
8. Automatic definition of active user

Future Capabilities

1. Add ability to Filter based on cube level data
2. Add additional subset selection rules based on specific requirements