Strategy ONE

Configure the Strategy Connector

The Strategy connector allows you to fetch data from reports or cubes that reside on other Strategy projects or environments.

To use the connector, you must first perform the following steps to configure the connector.

  1. Set the Community Connectors Application URL
  2. Modify the whitelist.txt File
  3. Confirm the Connector URL

Set the Community Connectors Application URL

Administrator privileges are required.

  1. In Strategy Web, click the username drop-down and select Preferences.

  2. Under Preferences Level, click Project Defaults.
  3. Enter your Strategy Community Data Connectors application URL in Link to Community Connectors.

    The URL format: https://[HOST_NAME]:[PORT_NUMBER]/CommunityConnectors/

    • The HOST_NAME is the host name of the machine you have the Community Connectors application installed on.
    • The PORT_NUMBER is the port number that your web server listens to. Use only if required.


  4. Click Apply.

Modify the whitelist.txt File

  1. Navigate to your Community Connector server and open the whitelist.txt file.

    This is usually in Tomcat, in the file path [Tomcat]\webapps\CommunityConnectors\WEB-INF\whitelist.txt.

  2. Add a new line and enter your Strategy Web server hostname.

  3. If the connector is deployed with cluster mode, you must add the Strategy Web server hostname to the whitelist.txt file for each connector.

    If your Web server is deployed with cluster mode, then use the web load balancer's hostname in the whitelist.txt file.

Confirm the Connector URL

  • Web
  • Workstation
  1. Open Strategy Web.
  2. Click Create > Add External Data.

  3. Locate the Strategy Connector.

  4. Hover over the connector and click Edit Connector.

  5. Ensure your Connector URL has /mstr-native/ appended to the end. If it does not, add it to your URL.

    https://[HOST_NAME]:[PORT_NUMBER]/CommunityConnectors/mstr-native/

  6. Click Save.
  1. Open Strategy Workstation.
  2. Create a new dashboard.
  3. Go to Add Data > New Data.

  4. Locate the Strategy Connector.

  5. Hover over the connector and click Edit Connector.

  6. Ensure your Connector URL has /mstr-native/ appended to the end. If it does not, add it to your URL.

    https://[HOST_NAME]:[PORT_NUMBER]/CommunityConnectors/mstr-native/

  7. Click Save.

You can now use the Strategy Connector. For steps, see How to Use the Strategy Connector.

Limitations

The Strategy connector creates a cube from a snapshot of data from the original data source, such as a cube or report. It references the original data source it was created from. When you move the connector cube across environments or projects using the package manager, the underlying data source remains unchanged. The main purpose of the connector is to create refreshable snapshots of data. It is not intended to be used as a migration tool.

Supported Authentication Types

The Strategy connector supports standard and LDAP authentication.

Import Support

Reports

Report Type Supported by Strategy Connector?

Freeform SQL

 No

Graph

Yes

Grid

Yes

Grid Graph

 Yes

Intelligent Cube

Yes

MDX Cube

 Yes

SQL

No

Datasets

Type Supported by Strategy Connector?

Dashboard Compound Grid

 No

Dashboard Custom Visualizations

 No

Dashboard Free-form Layout

No

Dashboard Out-of-the-box Visualizations

No

Intelligent Cube Live Connect

 Yes

Intelligent Cube MTDI

Yes

Intelligent Cube OLAP

 Yes

Documents

Documents are not supported by the Strategy connector.

Other

Type Supported by Strategy Connector?

All attribute forms format types

Yes

Note: When you import geo attributes (longitude and latitude), they will not be properly set after import but can be set in the Prepare Data window
All metric types Partial

Consolidations

Yes

Custom groups

 No

Derived elements

 Yes
Edit previously imported data Yes
Page-by reports (All pages) No

Page-by reports (First page)

Yes

Prepare data before import (attributes, metrics, attribute elements)

No

You can only select which attributes and metrics to import, sorting is supported

Preview data before import

Yes

Prompted reports with and without default answers

 No

Reports with system and nested prompts

No

Reports with view filters/reports, derived metrics

 No

Select attribute forms to import

No
Select how attribute form names should be imported (For example, form name only) No
Select totals and subtotals to not import No

Totals and subtoals

No