Members' count


If you’re not familiar with the way to specify a test on members of a hierarchy (or level), read first the page about [members].

Assertion

The assertion consists in a validation of the members’ count, in the hierarchy or level specified. To achieve this, you need to specify an assertion of type count, as described here under.

<test>
    <assert>
        <count/>
    </assert>
</test>

Then you need to specify one of the following option:

  • exactly
  • more-than
  • less-than

It’s also possible to combine more-than and less-than, as shown here under.

<count more-than="5" less-than="10"/>

If you’re validating that the hierarchy named “MyHierarchy” has more than 15 members:

<test>
    <system-under-test>
	    <members>
		    <hierarchy
          caption="State-Province"
          dimension="Customer"
          perspective="Adventure Works"
			    connectionString="Provider=MSOLAP.4;Data Source=MyServer;
            Integrated Security=SSPI;Initial Catalog=MyCube;"
		     />
	    </members>
    </system-under-test>
    <assert>
        <count more-than="15"/>
    </assert>
</test>