Sample Header Ad - 728x90

Improve SSAS Tabular query performance

1 vote
1 answer
1378 views
I'be build a Tabular Cube with FactTable and four dimensions. Fact table has about 2.500.000 of rows (and about 20 calculated measures on the cube level) and dimension tables from 5k-50k of rows. When I connect to the cube from Excel and try to add dimension I have to wait like 15-20 seconds for this. Do you know some ways to improve the query performance of such tabular cube (SQL 2014) ? enter image description here Performance issue not visible (Year consolidated), filtering by Port works fast: enter image description here Performance issue visible (Year expandeding to weeks takes about 15 sec, filtering by Port after next 15 seconds everytime): enter image description here
Asked by Tomasz Wieczorkowski (362 rep)
Dec 14, 2016, 04:14 PM
Last activity: Feb 15, 2025, 07:03 PM