Initializing help system before first use

Adding a Visualization Using Tableau for FICO

You can incorporate Tableau visualizations in Xpress Insight apps as custom views that report on scenario data.

Tableau visualizations obtain their data from a relational database. Xpress Insight holds scenario data in a compressed format and mirrors it into a relational database - the mirror database - for Tableau.

The schema and content of the mirror database is managed by Xpress Insight, via the companion file, which defines the mirror tables and specifies how they are populated.

Exposing Mirror Data to Tableau and Configuring a Data Source

Change foliodata.xml so that it now reads: 
<?xml version="1.0" encoding="UTF-8"?>
<model-companion xmlns="http://www.fico.com/xpress/optimization-modeler/model-companion" 
                 version="3.0">
    <database-mirror table-prefix="shares_">
        <mirror-tables>
        <mirror-table name="allocations">
            <entity name="frac"></entity>
        </mirror-table>
        </mirror-tables>
        <data-sources>
            <data-source name="share_source">
                <mirror-table-ref name="allocations"></mirror-table-ref>
            </data-source>
        </data-sources>
    </database-mirror>
    <client>
        <view-group title="Portfolio Optimization">
            <vdl-view title="Portfolio" path="foliodata.vdl"></vdl-view>
            <tableau-workbook title="Optimal allocation" 
                              workbook="investments" 
                              managed="true"></tableau-workbook>
        </view-group>
    </client>
</model-companion>
The <database-mirror> element marks the start of the mirror database configuration. It must be placed before the <client> element. The <mirror-tables> element is a container for potentially several <mirror-table> elements, in which the name attribute sets the table name. Within <mirror-table> elements, <entity> elements associate model entities with their mirror tables. Of course, a table name doesn't need to be the same as the entity on which it's based.

The <data-sources> element begins the definition of (potentially several) data sources from which Tableau can access scenario data. Above, only one data source is defined - share_source - which contains a mirror table reference.

Within the <view-group> element, there's a new <tableau-workbook> element that references the workbook investments, a title of Optimal allocation and sets its managed attribute to true. Workbooks thus marked are automatically published by Xpress Insight on loading an app if the workbook file can be located in the tableau folder of the app archive.

Covered Topics
Parent Topic Building an Xpress Insight App

© 2001-2019 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation (“FICO”). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.