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?