what is SSAS cube testing and how it is performed and what is re concillation

Question

Hi

i would like to know what is cube testing and how it is perfomred . also i want to know the difference between testing and reconcillation of cube. appricate iof some one can give some information on this .

also i want steps for cube testing if there is some thing like cube testing .

Answer 1

Hi,

You test that the data is correct in the cube by running SQL queries on the source.

The other kinds of tests are if the responsetime for queries and processing time for the cube are within expectations.

The third kind of test is user acceptance. Is the cube in accordance with expectations or not?

Thomas Ivarsson

Answer 2

Hi Srinivas,

You can get more Details on Below Link hope it will help you.

SSAS Cube Testing 1

SSAS Cube Testing 2

Suhas Kudekar

---

Mark as Answer if this resolves your problem or "Vote as Helpful" if you find it helpful.

My Blog

Follow @SuhasKudekar