i got a query that consists of a cross join between 3 dims .
dim1- has 15,000 members
dim2- this is the organisation hierarchy
dim 3- has 30,000 members
this is the query:
as you can imagine -this is a huge cross join but i have to do this ...
i tried functions like "filter" and "non empty" but it doesnt help...it takes more then 30 minutes...
how can i improve it so it will run in a short time?