Creating a worksheet for the QBE results
After designing your customized query using the QBE tool and interrogating the data mart that stores the analysis results, you can build a worksheet to represent the query results in charts or tables. You can also publish this worksheet and share it with other team members.
For further information on worksheets, refer to SpagoBI documentation.
Due to a limitation in SpagoBI, you cannot create worksheets for the QBE results when the data mart database type is MS SQL Server.
Before you begin
- You have accessed Talend DQ Portal as a user.
- A query has been created and executed on some analysis results in the datamart as outlined in Building a query.
About this task
In this example the query interrogates the results of an overview analysis,
qbx_overview_tbi, in the datamart, retrieves the list of
tables, their names and the number of rows in each.
To build a worksheet for the query results, do the following: