Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Using Longview Add-In With A Tidemark Data Source

The Longview Add-In for Office can also connect to a Tidemark Data Source. Connecting to a Tidemark Data Source is equivalent to connecting to a Tidemark Application. Once connected, data security, hierarchy and member selections will be restricted to those available in the Tidemark Application to which you are connected. Some, but not all the functionality is available for Tidemark Data Sources. Any functionality unavailable for Tidemark Data Sources will appears disabled in Longview menu options within Microsoft Excel.

This guide will describes how to use these features. However, note that there may be some slight differences in terminology. Most notably, Longview Data Sources use the term "symbol" and Tidemark Data Sources use the term "member".

The main features available for Tidemark Data Sources include retrieving data, refreshing data, and retrieving metadata.

The following lists the features applicable to Tidemark Data Sources:

  • Data Query
  • Data Extract
  • Symbol Query
  • Refresh Worksheet
  • Refresh Workbook
  • Convert to Values
  • Longview Functions: LVCELL, LVDESC, LVCHILD, LVDIMDESC, LVDIMNAME, LVIDENTIFIER, LVPARENT, LVREFRESHDATETIME, LVSUBMIT, LVSYMBOLSELECTOR, LVUSER, LVUSERDESC

    Caution: The following caveats apply when connecting to a Tidemark Data Source:

  • Longview Add-In for Office is only supported on Windows operating systems.
  • The link to download the Longview Add-In for Office is available from the Tidemark main menu. Once the Add-In is installed, you may subsequently launch the Longview Add-In for Office from the Tidemark main menu or by launching Microsoft Excel from your desktop and navigating to the LONGVIEW tab.
  • Longview Add-In for Office queries are made directly against Tidemark data. Data security is enforced through a Tidemark data security profile that customers must configure in each Tidemark application they want to make available to users from Longview Add-In for Office. The security profile must be named ExcelProfile. Users cannot connect to Tidemark applications unless the ExcelProfile is present and configured properly.
  • Single Sign-On is not supported for Tidemark Data Sources.
  • Longview Add-In for Office can handle a maximum of 64 dimensions when connecting to a Tidemark Data Source. If your Tidemark Data Source has more than 64 dimensions, then you will be unable to use the Longview Add-In for Office to connect to it.
  • When retrieving data using Data Query, Data Extract, or LVCELL() and LVSUBMIT(); you must specify a co-ordinate for each dimension
  • Some messages, tooltips and user interfaces may be Longview-centric. For example, in some cases, you may see the term "symbol" instead of "member". You may think of these two terms as equivalents.
  • Automation APIs are not supported for Tidemark Data Sources.
Published:

Using Longview Add-In With A Tidemark Data Source

The Longview Add-In for Office can also connect to a Tidemark Data Source. Connecting to a Tidemark Data Source is equivalent to connecting to a Tidemark Application. Once connected, data security, hierarchy and member selections will be restricted to those available in the Tidemark Application to which you are connected. Some, but not all the functionality is available for Tidemark Data Sources. Any functionality unavailable for Tidemark Data Sources will appears disabled in Longview menu options within Microsoft Excel.

This guide will describes how to use these features. However, note that there may be some slight differences in terminology. Most notably, Longview Data Sources use the term "symbol" and Tidemark Data Sources use the term "member".

The main features available for Tidemark Data Sources include retrieving data, refreshing data, and retrieving metadata.

The following lists the features applicable to Tidemark Data Sources:

  • Data Query
  • Data Extract
  • Symbol Query
  • Refresh Worksheet
  • Refresh Workbook
  • Convert to Values
  • Longview Functions: LVCELL, LVDESC, LVCHILD, LVDIMDESC, LVDIMNAME, LVIDENTIFIER, LVPARENT, LVREFRESHDATETIME, LVSUBMIT, LVSYMBOLSELECTOR, LVUSER, LVUSERDESC

    Caution: The following caveats apply when connecting to a Tidemark Data Source:

  • Longview Add-In for Office is only supported on Windows operating systems.
  • The link to download the Longview Add-In for Office is available from the Tidemark main menu. Once the Add-In is installed, you may subsequently launch the Longview Add-In for Office from the Tidemark main menu or by launching Microsoft Excel from your desktop and navigating to the LONGVIEW tab.
  • Longview Add-In for Office queries are made directly against Tidemark data. Data security is enforced through a Tidemark data security profile that customers must configure in each Tidemark application they want to make available to users from Longview Add-In for Office. The security profile must be named ExcelProfile. Users cannot connect to Tidemark applications unless the ExcelProfile is present and configured properly.
  • Single Sign-On is not supported for Tidemark Data Sources.
  • Longview Add-In for Office can handle a maximum of 64 dimensions when connecting to a Tidemark Data Source. If your Tidemark Data Source has more than 64 dimensions, then you will be unable to use the Longview Add-In for Office to connect to it.
  • When retrieving data using Data Query, Data Extract, or LVCELL() and LVSUBMIT(); you must specify a co-ordinate for each dimension
  • Some messages, tooltips and user interfaces may be Longview-centric. For example, in some cases, you may see the term "symbol" instead of "member". You may think of these two terms as equivalents.
  • Automation APIs are not supported for Tidemark Data Sources.
For an optimal Community experience, Please view on Desktop