OLAP Named Sets | Kyubit Business Intelligence

User Named Sets

While analyzing data with grid analysis, any user could use OLAP database defined Named set or create ad-hoc “User Named Set” that will be stored in Kyubit Business Intelligence application and could be reused in different analyses and shared with other users using Kyubit BI software.

Steps to create ad-hoc user Named Set

To create ad-hoc “User Named Set” drag dimension hierarchy to any of grid axes, click dimension hierarchy arrow and from hierarchy context menu select “Create Named Set”. After saving User Named Set, Cube metadata tree will be refreshed to include new User Named set.

Create Named Set by picking members. To create named set with static members of certain dimension hierarchy, select “Select named set members”, click “Pick members” and browse through dimension hierarchy or use search members to find members for named set.

Create Named Set by expression. To create dynamic set of named set members, select “Set named set expression” and enter MDX expression that will be used to dynamically return members evaluated by expression. Select “Test expression” to validate MDX expression input. After saving named set, every time named set is used, expression will be executed in the analysis scope to return members and use within analysis.

Edit existing User Named Sets.

While in grid analysis, authorized users could edit existing User Named Sets by right mouse click on User Named set in Cube metadata structure tree or in Main Menu -> Shared Items -> User Named Sets.

All created User Named Sets, could be managed and shared in OLAP Shared Items application section.