AnsweredAssumed Answered

optimizes the query generated?

Question asked by Hernan Cobo on Jun 28, 2018

Hi! the conversion of an MDX to relational generate an SQL like
SELECT
   .....
FROM [fact_table], .........
......
if instead of use <fact_table> the SQL is generated as
(SELECT DISTINCT
[dimension_id1],
[dimension_id2], ...
[aggregation_function1] ([measure1]),
[aggregation_function2] ([measure2]),
... ...
) [fact_table]
including only the dimensions and measures contained in the crossing and incorporating the <aggregation_function> that corresponds to each measure becomes much more efficient with large amounts of records.

I’m right? It’s possible?

 

Outcomes