I have a Factgroup of Sales with the Dimensions Customer, Product, Time. A Query on 1 Productgroup, 1 Month and all Customers to return the Cell-Value I want to drillthrough needs 4 sec after a restart of SSAS. From relational DWH I know there are ca. 50.000 rows to return from drillthrough and sql-server needs 10 sec to fetch them. But the drillthrough needs 80 sek for default maxrows=10.000 rows and it needs more than 30 minutes for maxrows=50.000.
In Performance Monitor I see a lot of time spent caching. MdxStudio tells me the time is spent serializing.
Now I have a cube working fine for selects but doesn't work for drillthrough and it is MOLAP storage mode. Has anybody an idea what could be the cause, what I should check? I didn't find much about SSAS-performance when drilling through in the internet.