L
L
lrv2018-10-01 22:09:15
SQL
lrv, 2018-10-01 22:09:15

How to change MDX query to get required result?

Good afternoon.
There is a table with the following structure:
5bb26daee2d8b003702801.png
(This table is a fact table for an olap cube) You
need to write an MDX query to get the following result:
5bb26e5c85dc3248099834.png
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 question

Ask a Question

731 491 924 answers to any question