Product:TIBCO Spotfire Server
Versions:All
Summary:
This article explains how to make materialized query tables or views visible in Information Designer by adding them to the setting in a data source template.
Details:
By default, materialized query tables or views are generally not visible in TIBCO Spotfire Information Designer
Resolution:
What table types should be retrieved/visible for a specific data source type in Information Services is controlled by the <table-types> setting in the data source template. You can edit data source templates using the TIBCO Spotfire Server configuration tool (for more information about that, see "Adding a data source template with the configuration tool" in the references below). The changes will take effect after the next TIBCO Spotfire Server (service) restart.
For Materialized query tables, modify the <table-types> setting in the data source template as shown below.
From:
To:
Note: The above example is taken from the IBM DB2 data source template which is included in the TIBCO Spotfire Server installation.
For Materialized views, modify the <table-types> setting in the data source template as shown below.
From:
To:
Note: The above example is taken from the PostgreSQL data source template which is included in the TIBCO Spotfire Server installation. By default, the value of the table?types setting is 'TABLE, VIEW'.
Versions:All
Summary:
This article explains how to make materialized query tables or views visible in Information Designer by adding them to the setting in a data source template.
Details:
By default, materialized query tables or views are generally not visible in TIBCO Spotfire Information Designer
Resolution:
What table types should be retrieved/visible for a specific data source type in Information Services is controlled by the <table-types> setting in the data source template. You can edit data source templates using the TIBCO Spotfire Server configuration tool (for more information about that, see "Adding a data source template with the configuration tool" in the references below). The changes will take effect after the next TIBCO Spotfire Server (service) restart.
For Materialized query tables, modify the <table-types> setting in the data source template as shown below.
From:
<table-types>TABLE, VIEW, NICKNAME</table-types>
To:
<table-types>TABLE, VIEW, NICKNAME, MATERIALIZED QUERY TABLE</table-types>
Note: The above example is taken from the IBM DB2 data source template which is included in the TIBCO Spotfire Server installation.
For Materialized views, modify the <table-types> setting in the data source template as shown below.
From:
<table-types>TABLE,VIEW</table-types>
To:
<table-types>TABLE,VIEW,MATERIALIZED VIEW</table-types>
Note: The above example is taken from the PostgreSQL data source template which is included in the TIBCO Spotfire Server installation. By default, the value of the table?types setting is 'TABLE, VIEW'.