NBi
NBi copied to clipboard
Data Type Support For SSAS Tabular 2017
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>
As stated in the documentation, this feature is only available for relational database (so not for OLAP). Could be added in a next release.