Stack Overflow
Stack Overflow

Questions tagged [mdxstudio]

MDX Studio is a tool for write a MDX query

MDX Studio is a tool for write a "Multidimensional Expressions" (MDX) query.

The IDE have a code formatting feature, an embedded system to analyze query performance and many other features for writing MDX queries.

Download and info here

21 questions
0
votes
1 answer

Better syntax for MDX

if there a better way to write the MDX SELECT { [Measures].[Label], NonEmpty [Measures].[UniqueName], NonEmpty [Measures].[TargetName], [Measures].[Place] } ON COLUMNS , NON EMPTY …
Nomitha patel
  • 1
0
votes
2 answers

Replacing blank with "NA" or "MISSING" text

I am trying to replace blank spaces in data with the "MISSING" or "NA" text. CoalesceEmpty([Product Type].[All Product Type].[ ],"MISSING") I have tried the above code, with or without quotes around MISSING. Getting the following…
in_user
  • 1,948
  • 1
  • 15
  • 22
0
votes
2 answers

How to generate mdx query using C#?

I am new to mdx query and I am very curious about mdx query generation using C# so I searched for any demo or open source then I found Ranet.olap (https://ranetuilibraryolap.codeplex.com/) which is providing what I need. After taking the dlls I…
ironman
  • 946
  • 14
  • 23
0
votes
1 answer

Unable to retrieve the month from date parameter using vba function in mdx

I am trying to retrieve month from parametrized date , by using : vba!month(${parDate}) or vba!datePart(m,${parDate}) or vba!format(${parDate},'mmm') None of the above is working.Can you guide, what is the right approach to do this?
sam140
  • 219
  • 1
  • 5
  • 27
0
votes
1 answer

HEAD function inside aggregation function SUM

How do I change this script so that HEAD is not inside the aggregation function SUM? The reason I'd like to do this is that I'm being warned that: Function 'Head' was used inside aggregation function - this disables block computation mode WITH …
whytheq
  • 34,466
  • 65
  • 172
  • 267
-1
votes
1 answer

I need a quick help on the below mdx query

I want to filter the data on the measure and dimension at a time case when [measure].[frequency] >3 and [poa].[segment].&A then 'red' when [measure].[frequency] <3 and [poa].[segment].&A then 'yellow' when [measure].[frequency] =3 and…
Adi
  • 232
  • 1
  • 9
1
2