This project is read-only.

Test the members' count at any level of a dimension or hierarchy

System under test

If you're not familiar with the way to specify a test on members of a dimension, read first the article about Tests on dimension's members.


The assertion consists in a check about the members' count in the hierarchy or level specified.
So we need to specify that we'll perform an assertion of type "count":
The we need to specify one of the following option:
  • exactly
  • more-than
  • less-than
(It's also possible to combine more-than and less-than)
<count more-than="5" less-than="10"/>

If we're checking that the hierarchy named "MyHierarchy" has more than 15 members:
		    <hierarchy caption="State-Province" dimension="Customer" perspective="Adventure Works"
			     connectionString="Provider=MSOLAP.4;Data Source=MyServer;Integrated Security=SSPI;Initial Catalog=MyCube;"
        <count more-than="15"/>

Last edited Jul 15, 2013 at 9:28 PM by Seddryck, version 5


No comments yet.