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

Support for TMSCHEMA tables to test SSAS tabular model #616

Open shiv24saxena opened 3 years ago

shiv24saxena commented 3 years ago

Currently Tabular model metadata is also getting verified against MDSCHEMA tables which are mainly meant for multidimensional model. Tabular model metadata information is stored in TMSCHEMA tables which should be used to test the model.

Thanks

Seddryck commented 3 years ago

You're right but could you be a bit more specific on what's going not well with the current implementation?

shiv24saxena commented 3 years ago

Thanks for responding. Few scenarios where current implementation will not work: 1) In Tabular model to get mapping between Technical column name (Database field example FIRST_NM) and business column name (example - First Name), we need use TMSCHEMA_COLUMNS. Same information can't be retrieved by DBSCEHMA_COLUMNS. 2) To get perspective details in case of tabular model, we need use TMSCHEMA_PERSPECTIVE_TABLES and TMSCEHMA_PERSPECTIVE_COLUMNS table. Same can't be retrieved from MDSCHEMA_DIMENSIONS which I believe is getting used currently, Please let me know if any other information/scenario is required.