dMine Dashboard - Create Business Views

Creating Business views or Queries is as simple as drag and drop and can be easily done by business users using a simple wizard. The user can define simple to complex queries using multiple tables from multiple data sources.

Once the data sources have been created the admin team needs to create Business Views or Queries by connecting to the available Data sources. This can be achieved by right clicking on the data source name and selecting Connect. After connecting to the Data source, user would once again have to right click on the Data source and select the Add Business View Option which would provide the list of available Data source views. Now a new Business View can be created by adding the Title and Description.

For creating Business Views or queries, tables can be dragged and dropped from the list of tables in the data source. Multiple tables can be selected from the list and Columns that are not required can be deleted. The join conditions between the tables are automatically created by the wizard depending on the design of the tables. The SQL code can also be viewed by clicking on the SQL Code option and the query can be validated and executed using the Validate Query and Run Query option. Queries can be easily parameterized using the wizard and these parameters can be accessed at runtime. Finally the Query needs to be saved so that it can be accessed in future.