I have couple of queries on a particular cube that run forever , i rebuilt the indexes for that
cubes fact table and regenerated the queries . some of them started executing pretty quick
whereas the others are still very slow .
The result is similar when i use listcube also
when i check sm66 it it sows that the query reads the cube fact table for a very very long time .
Is there anything that can be done ?
All suggestions welcome !!
cube has no aggregates