CODEWITHSUNDEEP
testingssisssas
Gidil
Gidil

Reputation: 4137

How to fail SSAS cube process

In order to test part of my SSIS process, I want to simulate part of the SSAS process failing.
The Package runs several processing steps in OLAP and we want to be sure that it will run even in the case of a partial failure. How can I simulate this?

Upvotes: 0

Views: 58

Answers (2)

MrHappyHead
MrHappyHead

Reputation: 442

Depending on how you trap errors you could remove some dimension keys from the fact table.

Upvotes: 0

Tab Alleman
Tab Alleman

Reputation: 31785

Since I'm assuming you aren't doing this testing in your production environment, you could temporarily drop one of the tables/views that your cube depends on.

Upvotes: 1

Related Questions