SSAS cube verification

How can we verify if a cube from SSAS is correct? How can we support our claim in front of users?
Please kindly provide full answer here without links to aricles. Thanks.
ksfokAsked:
Who is Participating?
 
carsRSTConnect With a Mentor Commented:
>>How can we verify if a cube from SSAS is correct? How can we support our claim in front of users?

Connect to the cube with Excel 2007 or greater.   Pull back the data and have them validate some of it.

0
 
PedroCGDCommented:
what you mean by "verify if a cube from SSAS is correct"?
Are you refering to data?

How are you processing the SSAS OLAP DATABASE!?
0
 
msheskeyConnect With a Mentor Commented:
Well the easiest way for non-technical people to accept the cube is to do side by side reports or pivot tables. In my experience people don't care/understand where the data comes from as long as it is accurate and they can continue on as is. Generate 100 or so reports and let the end users spot check
0
 
ksfokAuthor Commented:
OK
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.