SelectColumn()
, SelectTable()
, SelectMeasure()
and SelectObject()
. These methods are useful when creating reusable scripts, such as generic scripts for adding Time Intelligence to a model.Model.Database
):void ExecuteCommand(string tmsl)
IDataReader ExecuteReader(string dax)
DataSet ExecuteDax(string dax)
object EvaluateDax(string dax)
DataTable ExecuteDax(string dax)
causing an error when nullable columns were returned.ExecuteDax
now returns a DataSet
instead of a DataTable
to allow for multiple EVALUATE statements in a single query.Output()
script helper method now supports DataTables, to quickly visualise the result of a DAX expression obtained from ExecuteDax
or EvaluateDax
#r 'library.name.dll'
syntax are now resolved by looking in Tabular Editor's installation folder first and then in GAC.Model.Database
object. These make it possible to programmatically interact with the AS instance when model metadata have been loaded from a database. Expect to see some interesting examples of what these can be used for in the near future:void ExecuteCommand(string tmsl)
IDataReader ExecuteReader(string dax)
DataTable ExecuteDax(string dax)