search

Seddryck / NBi

NBi is a testing framework (add-on to NUnit) for Business Intelligence and Data Access. The main goal of this framework is to let users create tests with a declarative approach based on an Xml syntax. By the means of NBi, you don't need to develop C# or Java code to specify your tests! Either, you don't need Visual Studio or Eclipse to compile your test suite. Just create an Xml file and let the framework interpret it and play your tests. The framework is designed as an add-on of NUnit but with the possibility to port it easily to other testing frameworks.
http://www.nbi.io
Apache License 2.0
106 stars 37 forks source link

Data Type Support For SSAS Tabular 2017 #608

Open bthakks opened 4 years ago

bthakks commented 4 years ago

Hi I was wondering if the data type test is supported for the SSAS Tabular instance. I have a test similar to one below, and the data type in SSAS Tabular is string, and the test i am testing is for varchar and also string, but both failing the test with the same error message like one below. Not sure what am i doing wrong here. I am on the latest nBI version v1.22 If it does support where will i find the data type that are available in the nbi, i mean if the data type is double, do i put double or decimal or something else.

Error Message

NBi.NUnit.Runtime.TestSuite.Test:
System.ArgumentException : Value does not fall within the expected range.

Test

<?xml version="1.0" encoding="utf-8" ?>
<testSuite name="Acceptance Testing: members ordering" xmlns="http://NBi/TestSuite">
    <settings>
    <default apply-to="system-under-test">
       <connectionString>Provider=MSOLAP.4;Data Source=MYServer; Initial Catalog=Cube; Integrated Security=SSPI</connectionString>
    </default>
    </settings>
  <test name="Test">
    <system-under-test>
      <data-type>
        <column caption="Client" table="Client" perspective = "default" />
      </data-type>
    </system-under-test>
    <assert>
      <is>
        string
      </is>
    </assert>
  </test>
</testSuite>
Seddryck commented 4 years ago

As stated in the documentation, this feature is only available for relational database (so not for OLAP). Could be added in a next release.