How to Automatically Test DeepSee Pivots and Dashboards?

Question

Question

Evgeny Shvarov · May 18, 2017

#Change Management #InterSystems IRIS BI (DeepSee) #Testing

Hi, colleagues!

Suppose you have large set of cubes, pivots and dashboards in your DeepSee solution.

Then you change the level, measure or dimension in the cube and is there any way to test that your new input didn't break current pivots, dashboards, etc?

How to test this?

How do you test your DeepSee solutions?

Discussion (4)1

Log in or sign up to continue

Eduard Lebedyuk · May 18, 2017

Here's a few thoughts:

Get list of pivots
For each
- Get MDX
- Try to execute MDX
- If it fails, record the error
Aggregate/display errors

Should be doable. DeepSee API has all the required functions.

0 0

score 0 · Answer 1 · 2017-05-20T12:57:48-04:00

Hi, Ed! Thanks!

I was looking if we have something "out-of-the box" for DeepSee pivots and dashes testing.

Yes, I think it would work for pivots. We have dashboards also. Any thoughts?

score 0 · Answer 2 · 2017-05-20T13:00:19-04:00

Eduard Lebedyuk May 20, 2017 to Evgeny Shvarov

Selenium?

0 0

score 0 · Answer 3 · 2019-06-19T09:41:20-04:00

Raising this again.

Suppose I changed how dimension A works.

How do I sure that none of the pivots were broken because of the change?

Yes, I can manually run all the pivots I have. But maybe somebody did a class for that?