NBi icon indicating copy to clipboard operation
NBi copied to clipboard

Data Type Support For SSAS Tabular 2017

Open bthakks opened this issue 4 years ago • 1 comments

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>

bthakks avatar Aug 06 '20 16:08 bthakks

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

Seddryck avatar Sep 13 '20 08:09 Seddryck