You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How can i use CREATE SET in Essbase

edited Aug 2, 2018 2:36AM in Essbase 3 comments

Summary

How can i use CREATE SET in Essbase

Content

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!