python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - olap-cube

Mdx Query axis specification

Welcome to everyone. I would be very thanks if anyone help me. I am not too expert writing mdx query. I am working in a software that build a mdx query to get info from a OLAP structure. I get the res...
test-img

erpota

mdx

olap

olap-cube

Votes: 0

Answers: 1

Latest Answer

Finally I resolved my selft traying differents posts like And-Or in MDX queries Select {[Measures].allmembers} on columns , non empty { {([ModelosGers].[CodGer].[A] ,[ModelosGers].[CodModelo].defaultm...
test-img

erpota

Exponential moving average in MDX

I have bellow output of cube date value ---- ----------- 2021-01-06 10 2021-01-07 Null 2021-01-08 Null 2021-01-09 15 2021-01-10 18 2021-01-11 25 My question is, ho...
test-img

Mohammad Reza

mdx

cube

olap-cube

Votes: 0

Answers: 1

Latest Answer

According to The Formula, You Can Try Below Calculated Measures: [A1]: Case WHEN [MeasureName] = Null THEN 0 ELSE 1 END [A2]: CASE WHEN A1 = 0 THEN Null ELSE SUM(Null:[DimDateTime].[Year_Month_Day].Cu...
test-img

Mahboobeh Mohammadkazem

Posts

Questions

Blogs

Jobs