How can i use CREATE SET in Essbase
Summary
How can i use CREATE SET in EssbaseContent
I have a number of MDX statements that use complex crossjoins with large amounts of duplication between the statements. I need to make some changes to these statements. Being a lazy I would like to reduce the amount of replicated code and was looking to the "CREATE SET" command to create some names sets that could be used across statements.
The tech ref states the syntax is as follows:
CREATE SET set name AS ' set ' [WHERE [<slicer_specification>]]
and gives this example:
CREATE SET [My Favorite Customers] AS '{ TopCount ([Customer].Individual).Members, 3,
0