Existence of an object


The assertion consists in a validation that the object specified in the system-under-test exists (by “exists”, we mean “visible for the end-user browsing your cube or database”).

Assertion

Once we have defined the object that will be validated, we have to define the assertion of type exists:

<test>
<assert>
<exists/>
</assert>
</test>

The whole test will look like:

<test>
<system-under-test>
<structure>
<measure caption="MyMeasure" measure-group="MyMeasureGroup" perspective="MyPerspective"
connectionString="Provider=MSOLAP.4;Data Source=MyServer;Integrated Security=SSPI;Initial Catalog=MyCube;"/>
</structure>
</system-under-test>
<assert>
<exists />
</assert>
</test>

Display-folder for measures and hierarchies

It’s not possible to check that a display-folder for measures or hierarchies exists. But anyway you can validate that a measure (or hierarchy) is effectively available in the expected display-folder. Using the attribute display-folder.

<test>
<system-under-test>
<structure>
<measure caption="MyMeasure"
display-folder="MyDisplayFolder\SubFolder"
measure-group="MyMeasureGroup" perspective="MyPerspective"
connectionString="Provider=MSOLAP.4;Data Source=MyServer;Integrated Security=SSPI;Initial Catalog=MyCube;"/>
</structure>
</system-under-test>
<assert>
<exists />
</assert>
</test>

If you want to specify that the measure (or hierarchy) should be in the root of the measure-group simply apply an empty value for the display-folder.

<test>
<system-under-test>
<structure>
<measure caption="MyMeasure"
display-folder=""
measure-group="MyMeasureGroup" perspective="MyPerspective"
connectionString="Provider=MSOLAP.4;Data Source=MyServer;Integrated Security=SSPI;Initial Catalog=MyCube;"/>
</structure>
</system-under-test>
<assert>
<exists />
</assert>
</test>

If you don’t specify the attribute display-folder then NBi will not take into account the display-folder when looking for your element. It means that if your measure (or attribute) is specified in the root or in a display-folder will not influence the result of the existence test.