Each analytical Document (report, olap, dashboard, etc.) an end-user can access in the user page in Talend Data Quality Portal is based on a released Document template. This template goes through different stages before reaching the ready-to-use state in the end-user page.
A model "template" is usually created by the BI developer using a specific external software. From Talend Data Quality Portal, the BI developer attaches this model to a document template, defines the document template parameters and sets the document template state to Test in order to make it accessible by the BI tester.
The BI tester tests the Document template and if the test results are error free, the Document template state should be changed to Released.
Released Documents are accessible by end-users through the end-user page of Talend Data Quality Portal according to the rights assigned to end-users by the BI administrator. For further information on access rights, see Managing access rights on menus and analytical documents.
Talend Data Quality Portal groups the administrator, developer and tester roles under one unique role: BI administrator. When you access the Portal using the administrator login information, you have the developer, tester and administrator rights at the same time.
Document templates types used in Talend Data Quality Portal are jrxml and dashboard templates. Dashboard templates include jrxml and OpenLaszlo.
As an administrator, you can access a page which lists all the document templates registered in Talend Data Quality Portal if you click the icon and select Functionalities management.
The following procedure explains how to create a new Document template in the BI administrator page.
You have accessed Talend Data Quality Portal as an administrator.
A template "model" has already been created.
To create a Document template in the BI administrator page, do the following:
On the toolbar, click the icon to open the Document browser page.
All the Documents accessible by the tdq_user in the user page have been created by default in Talend Data Quality Portal.
On top of the page, click Create Document > Generic Document.
Define the attributes of the Document template as the following:
the Document unique identifier.
the Document name.
a brief description of the Document.
this field shows if the Document is a Report, an On-line analytical processing (OLAP), a Data Mining model, a Dashboard, etc.
the Engine used by this Document.
the data source from which this Document reads data.
this field indicates the stage at which the Document template is: Development, Test or Released. Moreover, the document template can also be Suspended if it cannot be executed anymore.
the number of seconds used to refresh this Document.
indicates whether the Document is visible when it is in Released state.
a logical expression that can be used to hide this Document.
Click the Browse... button next to the Template field and select the file containing the model of the Document template. This model can be created with an external application suitable for the specific type of the analytical document.
From the Functionalities Tree to the right, select the folder under which you want to insert this new Document template.
If needed, click Show document templates to the right to display a table of the created templates.
From this table, you can manage listed templates.
The new Document is listed in the Document browser page, and a new table opens below the Document Details page.
The next step to finalize the creation of the Document template is to define all the parameters necessary to the template, including the list of values.
In the lower part of the Document Details page, start defining the parameters of the analytical Document as the following:
the title of the document parameter.
the list of values that is applied to this document.
the key of the parameter: the url for the document execution will contain an attribute with key specified by the content of this field and value specified by the parameter value.
If you define more than one parameter for the document, these parameters are sorted by this number.
Define as many parameters as necessary by clicking the New tab.
Click the icon to save the new document or to save the document and go back to the document list.
The new Document is listed in the Document browser page.
For more information, download the SpagoBI quick start guide from SpagoBI Documentation at http://forge.objectweb.org/project/showfiles.php?group_id=204 or check https://wiki.spagobi.org/xwiki/bin/view/spagobi_server/.