6       DataSets (Queries)

BI Studio provides Dataset (formerly Queries) module to execute pre-defined database specific queries. Dataset file is used from other visualization components as a data source.  The dataset file is stored in project file.


Dataset definition allows defining more than one data source query and executes the query one by one.  The query result tables will be stored one .Net Dataset (In-Memory Database). 


Dataset module supports currently SQL and MongoDB queries. BI Studio provides you a query setup dialog to add new SQL and MongoDB (JSON) queries.


Dataset Definition:

#Name: Orders

Select * from Orders;


#Name: Orders

Select * from [Order Details];


#Name: Sales

Select * from Sales;



This query definition will return a set of table results in a .Net Dataset.

powered by Nucleon Software