Answer the question
In order to leave comments, you need to log in
How to change MDX query to get required result?
Good afternoon.
There is a table with the following structure:
(This table is a fact table for an olap cube) You
need to write an MDX query to get the following result:
I wrote a query, but there is not enough grouping so that it does not sum up the values in col6 and col7. Tell me how to supplement my request in order to get what I want:
select {[Measures].[col6], [Measures].[col7]} on 0
, NonEmpty(CrossJoin({[Dim1].[col1].[col1], [Dim2].[col2].[col2], [Dim2].[col3].[col3]})) on 1
from [Cube]
where ([Dim1].[col1].&[value1])
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question