Solved

Execution blocking access to cubes

4 years ago
30 September 2019
3 replies
12 views

R

rluyten
Starter
2 replies

Hello,

Since a couple of days I created a second execution package to execute +- 10 tables, some dimension and 1 cube.

After this execution the other cubes are not reachable, I need to deploy and execute them all to get it solved.

Any clue why an execution pack would block access ?

Thanks,

Ronny

icon

Best answer by emily.wynkoop 1 October 2019, 23:22

View original

3 replies

E

emily.wynkoop
Contributor
15 replies
4 years ago
1 October 2019
Answer

Hi Ronny,

SSAS Multidimensional works by calculating all combinations of fact and dimension data. If you are refreshing dimensions used in other cubes, those cubes will no longer contain the proper, full set of calculations, and so they must also be refreshed as well.

I think this is what's probably happening here - if it is, you should be able to get the same error by executing any dimension without executing its associated cube, so it's easy to test out.

I hope this helps!

R