MDX Query : Add filters in mdx query

1
votes

i am new to writing.mdx queries. Trying to add below conditions

Need help in

  • pop2019 larger than 5000

  • GDPgrowth more than 1

Query for sales of each country:

SELECT
{[Measures].[Sales]} ON 0,
{[Dim Company Info].[LOC].ALLMEMBERS} ON 1
FROM [Database]

My schema looks like below: Schema Image

1
mdxmdx-query

1 Answers

1
votes

You basicly want your diemsion attribute members to behave like measure values. Take a look at the following

How to implement "greater than" based on dimension value in MDX