Initializing help system before first use

Configuring the Tableau integration

The mirror database schema for an app act like a short-term cache of scenario data in a format that can be consumed by Tableau. The schema is populated with scenario data on demand when a view makes a request. Tableau query and rendering time will potentially decrease as the volume of scenario data in the mirror schema increases. Therefore, Insight aggressively evicts data based on rules that can be tuned with configuration properties.

As a server admin, you can configure the target capacity, Minimum Time to Live and Maximum Idle Time in Seconds settings for the mirror database. To modify these settings, navigate to the Admin page and select Mirror Configuration under the Visualization header. Click edit to make the changes and then save them". If you are a user admin or execution services admin but not a server admin then these settings will not be visible. 

Configuration Property
 
Description
Minimum Time to Live in Seconds

The minimum time the system will persist scenario data before considering it for eviction. Increasing this time may increase the volume of data in the schema and decrease rendering time. Decreasing this may cause the data to be evicted before the user has finished working with it, necessitating a delay while the data is reinstated.

Default is 30 minutes

Maximum Idle Time in Seconds The length of time before the scenario data is automatically evicted from the database.

Prior to this duration being exceeded, the scenario data would only be evicted if the maximum total number of scenarios in the mirror has been exceeded and the scenario data minimum time to live has passed.

Increasing this time will facilitate users returning to reports after a period away without the penalty of waiting for the system to re-mirror the data. However, the total volume of data in the mirror will increase with the risk that Tableau rendering performance decreases.

Default is 2 hours.

Target Capacity The maximum number of scenarios. This maximum will be exceeded to honor the minimum time to live. When this maximum is exceeded, scenario data older than the time to live is a candidate for eviction to reduce the total scenario number to below this target capacity.

Increasing this property will decrease the amount of re-mirroring of the data, and the likely cost of increasing time to render the visualizations. Typically, this property should be set conservatively to prioritize query/render time over mirroring overhead.

Default is 10.

Configuration Properties
Parent Topic Administering the Tableau Integration on FICO Platform

© 2001-2024 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.