1

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

pythonlearner
  • 85
  • 2
  • 10

1 Answers1

1

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

MoazRub
  • 2,881
  • 2
  • 10
  • 20