Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
MDX Question — Cloud Customer Connect
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

MDX Question

Received Response
15
Views
5
Comments
edited Aug 2, 2018 2:36AM in Essbase 5 comments

Summary

MDX Question

Content

Hello fellows,

I am working on MDX query.

               1. (I want to find no.of stores for all my products which are in Level1 and Sales should be greater than 0 )-1 ;

I have written the script as below but it's not giving exact result. I need help now from experts

With

Member [Measures].[Number Of Stores]

as 'NonEmptyCount

  Filter(Geography.Levels(0).Members, Sales>0 )'

Select

{products.Levels(1).Members} on Rows,

{[Measures].[Number Of Stores]} on COLUMNS

FROM [ASOSamp.Sample]

 

Thanks,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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