200 • Developing Essbase Applications: Advanced Techniques for Finance and IT Professionals
{[Curr Year]} ON AXIS(2),
{[Sale]} ON AXIS(3),
{[Cash]} ON AXIS(4),
{[No Promotion]} ON AXIS(5),
{[1 to 13 Years]} ON AXIS(6),
{[Under 20,000]} ON AXIS(7),
{[Memory]} ON AXIS(8),
{[05351]} ON AXIS(9),
{[Stores].levels(0).members} ON AXIS(10)
FROM ASOsamp.Sample
Versus
WITH MEMBER [Measures].[Test1] AS
'CASE WHEN IsLevel([Time].CurrentMember, 0) THEN
CASE WHEN IsLevel([Years].CurrentMember, 0) THEN
CASE WHEN IsLevel([Transaction Type].CurrentMember, 0) THEN
CASE WHEN IsLevel([Payment Type].CurrentMember, 0) THEN
CASE WHEN IsLevel([Promotions].CurrentMember, 0) THEN
CASE WHEN IsLevel([Age].CurrentMember, 0) THEN
CASE WHEN IsLevel([Income Level].CurrentMember, 0) THEN ...