Upgrade

Before upgrading, you must install Spreadsheet Server as normal.

• If all required components are not selected during an upgrade, older versions of the previously-installed components will be uninstalled, by default.
• You can successfully upgrade the Spreadsheet Server instance even when running click-to-run office.

Installation

1. If necessary, close all open Excel sessions.
2. Double-click Spreadsheet Server Suite.exe from either the installation CD or from the downloaded and uncompressed .zip file.
3. Select the appropriate setup type and follow installation prompts:
• Spreadsheet Server: only Spreadsheet Server will be installed.
• Application Configurator: only Application Configurator will be installed.
• Cloud Connector: only Cloud Connector will be installed.
4. After successful installation, it is recommended to:
1. Reboot your machine.
2. If connecting to an iSeries or SAP database, ensure the appropriate components (for example, IBM iSeries Access for Windows, SAP Client, or SAP Transport) are installed for connectivity.

Note: As of version 14.5.134, SAP Netweaver 7.0 or higher must be installed in order for Spreadsheet Server to connect to an SAP database.

3. Open the Control Panel and sign into Spreadsheet Server:

Note: When starting Spreadsheet Server, you may be prompted to upgrade the segment list file. If you choose not to upgrade, other options are available for upgrading the segment list file at a later time.

Note: If the General Ledger Type is not defined in Application Configurator, a new window appears. In this window, click Configure Spreadsheet Server. The Select General Ledger panel then appears. In this panel, select the appropriate ledger type and specify the appropriate location of the network security and connections file.

1. If not completed in the previous step, navigate to the Settings > General panel and validate the location of the network security and connection files.
2. Navigate to the Settings > File Locations panel and validate the location of the segment list, ad hoc query, Designer GL definition, and EDQ files.

3. For pre-existing EDASH customers only, navigate to the Settings > Query panel and validate the settings.

4. For pre-existing EDASH customers only, open Query Designer and validate the settings.
5. For pre-existing Distribution Manager customers only, open Excel, start Spreadsheet Server, then navigate to the Distribution Manager Settings panel, and validate the settings. If necessary, install or upgrade the Outlook add-in.
5. Repeat all steps for each user.

Post Installation: Upgrade from V12.5.23 or Lower

This section references the post-installation steps required when upgrading to the latest release from version 12.5.23 or lower.

Important: In version 12.5.1, multi-column drill down grid layouts were modified. All previously-saved multi-column grid layouts must be rebuilt.

Query/Query Designer (previously EDASH)

In version 14.1.1, Query Designer was merged into Spreadsheet Server. To implement this change:

1. Legacy EDASH formulas EXQ, EXD, EXS, and EXI have been changed to GEXQ, GEXD, GEXS, and GEXI respectively. As a result, legacy formulas in each workbook must be converted. To convert the formulas, from the Spreadsheet Server ribbon in Excel, click Tools > Upgrade Workbook.
2. Previously, users had the ability to create ad hoc queries in Query Designer, enabling the user to drill down from the results view of a query to detail data associated with another query. As of version 14.1.1, this feature is being replaced with subquery processing. For assistance with updating existing queries to use subquery processing, contact insightsoftware support.

Designer GL

In version 12.5.2, changes were made to properly set the name tag in the XML file. To implement this change:

1. Navigate to the Settings > Ledger Specifics tab.
2. Click Browse for GL Definition and select the appropriate definition.
3. Click Save Changes.
4. Repeat for each GL definition.

Infinium

In version 14.1.1, SSInfinium was merged into Spreadsheet Server. To implement this change:

1. For each user, navigate to Settings > General, then to the GL Reporting, Infinium, and Quarter panels and validate the settings.
2. Navigate to Segment Lists and import the SSInfinium segment list file(s) into Spreadsheet Server.
3. Legacy SSInfinium formulas GXA and GXU have been changed to GXL, and the GXD and GXE formulas have been modified. As a result, legacy formulas in each workbook must be converted. To convert the formulas, from the Spreadsheet Server ribbon in Excel, click Tools > Upgrade Workbook.

Various options are available for Load Local processing. Contact insightsoftware for additional information and instructions.

JD Edwards

In version 14.1.1, SSJDE was merged into Spreadsheet Server. To implement this change:

1. For each user, navigate to Settings > General, then to the GL Reporting, JD Edwards, and Quarter panels and validate the settings.
2. For each user, navigate to the Settings > Designer GL panel, validate the connection assigned to the FXA Designer GL definition, and set the default Designer GL.
3. Navigate to Segment Lists and import the SSJDE segment list file(s) into Spreadsheet Server.
4. Legacy SSJDE formulas GXA, GXAB, and FXA have been changed to GXL, the GXECC formula has been changed to GXE, and the GXD, GXE, and GXSALES formulas have been modified. As a result, legacy formulas in each workbook must be converted. To convert the formulas, from the Spreadsheet Server ribbon in Excel, click Tools > Upgrade Workbook.
Note:

• After converting legacy JDE FXA formulas assigned to multiple host configurations (for example, SSFXA1 or SSFXA2), manual intervention is required to modify the Designer GL definition assigned to the GXL formulas.
• After converting legacy JDE GXE or GXECC formulas, the system will no longer automatically create new spreadsheets when generating GXE or GXECC formulas. As a result, the necessary spreadsheets must be manually added to the workbook

Various options are available for Load Local processing. Contact insightsoftware for additional information and instructions.

Lawson

In version 12.2.10, Chart_Name was added as a new segment to the Lawson account structure. To implement this change:

1. For each user, from the Settings > File Locations panel, determine the current location of ad hocs. If the ad hoc files are stored on a network drive, the Lawson_VSegment5 ad-hoc file must be copied from the Global Software Inc\Spreadsheet Server\AdHocQueries folder to the appropriate location on the network drive.
2. For each user, from the Settings > General panel, click the General Ledger Type drop-down list field and reselect Lawson.
3. Click OK to save the changes.
4. If your Lawson database is structured with only one chart of accounts, all existing Spreadsheet Server formulas and drill downs should calculate and function normally. For databases containing multiple charts of accounts, all existing spreadsheets must be reviewed and modified as necessary. To add the new account segment to the spreadsheet:
1. Insert a column for the new account segment and assign Chart_Name as the column header.
2. On a row containing a GXL formula, click the cell containing Chart_Name, and, from the Spreadsheet Server ribbon in Excel, click Locate Segment.
3. Select the desired chart of accounts and click Insert. Repeat this step as needed for each GXL, or copy the value if appropriate.
4. Click the cell containing a GXL formula, and, from the Spreadsheet Server ribbon in Excel, click Formula Assistant.
5. Modify the GXL to include the Chart_Name segment in the formula, press F4 to lock either the row and/or column value of the cell reference, then click Insert. Repeat this step as needed for each GXL, or copy the formula if appropriate.
6. Click the cell containing a GXD formula, and from the Spreadsheet Server ribbon in Excel, click Formula Assistant.
7. Modify the GXD to include the additional segment in the formula, press F4 to lock either the row and/or column value of the cell reference, then click Insert. Repeat this step as needed for each GXD, or copy the formula if appropriate.

Oracle

In version 12.4, Summary Accounts was added as a new parameter to the GXL formula for Oracle ledgers. All existing GXL formulas will continue to calculate normally. To add the new parameter to a spreadsheet:

1. Insert a column or row for the new parameter and assign Summary Accounts as the header/label.
2. Click the cell containing a GXL formula and, from the Spreadsheet Server ribbon in Excel, click Formula Assistant. Modify the GXL to include the Summary Accounts parameter in the formula, specify the appropriate cell, press F4 to lock either the row and/or column value of the cell reference, then click Insert. Repeat this step as needed for each GXL, or copy the formula if appropriate.

In version 12.5, revised Segment ad hoc queries for excluding parent hierarchy values were delivered. To use these modified queries, copy the Oracle_VSegment.xml files from the C:\Program Files\Global Software Inc\Spreadsheet Server\AdHocQueries folder to the appropriate ad hoc folder.

SAP (Standard and Designer GL)

In version 12.5.2, changes were made to modify all SAP ad hoc queries to use the SSRV_SQL_SELECT_OPEN RFC statement while in SAP mode. As a result, ad hoc queries do not support UNION ALL or aliases, and a tilde ( ~ ) rather than a period ( . ) must be used as the separator between Table Name and Field Name. Review and modify ad hoc queries as needed. For assistance, contact insightsoftware support.

Additional Steps

Continue to Upgrade from Version 14.2 or Lower for additional post-installation steps.

Post Installation: Upgrade from Version 14.8 or Lower

When upgrading from version 14.8 or previous, setup requires additional steps after installation. Refer to the following sections for post-installation steps.

• Upgrade from Version 14.2 or Lower
• Upgrade from Version 14.3 or Lower
• Upgrade from Version 14.4 or Lower
• Upgrade from Version 14.5 or Lower
• Upgrade from Version 14.6 or Lower
• Upgrade from Version 14.8 or Lower

Designer GL

In version 12.5.2, changes were made to properly set the name tag in the XML file. To implement this change, only one user must navigate to the Settings > Ledger Specifics tab, click Browse for GL Definition, and select the appropriate definition, then click Save Changes. Repeat this step for each GL definition.

Upgrade from Version 14.2 or Lower

This section references additional post-installation steps required when upgrading to the latest release from version 14.2 or lower.

JD Edwards

In version 14.2.24, ad hoc queries were revised to use the appropriate library name. To use these modified queries, copy the various JD Edwards XML files from C:\Program Files\Global Software Inc\Spreadsheet Server\AdHocQueries to the appropriate ad hoc folder.

Oracle

In version 14.2.24, the HSegment and VSegment ad hoc queries were revised to use the lookup routine OracleQualifiedTableName. To use these modified queries, copy the Oracle_HSegments.xml, Oracle_HSegments_ALT.xml, and Oracle_VSegment.xml files from C:\Program Files\Global Software Inc\Spreadsheet Server\AdHocQueries to the appropriate ad hoc folder.

Additional Post Installation

Continue to Upgrade from Version 14.3 or Lower for additional post-installation steps.

Upgrade from Version 14.3 or Lower

This section references additional post-installation steps required when upgrading to the latest release from version 14.3 or lower.

Query/Query Designer (previously EDASH)

In version 14.3.35, a new Explore icon was added to the Spreadsheet Server ribbon in Excel for listing queries (EDQs) stored in the Explore folder located in the user’s EDQ path, and opens the selector window with the values returned from the selected query (for example, process the GEXS function). To use this feature, move the desired queries into the new Explore folder.

Note: If a user's EDQ path is different than the system default EDQ path, it is the user's responsibility to create the folder, Explore, in the root of their EDQ location, and to move the desired queries into the new folder.

Infinium

In version 14.3.118, the Infinium Load Local SQL Server database was modified. As a result, all existing Load Local INF profiles using a SQL Server database must be rebuilt. Open Profile Scheduler, and, for each existing Load Local INF profile that uses a SQL Server Database Type, edit the profile, and click Replace All Data for this Configuration option, in addition to selecting other appropriate processing options, click OK, then run the profile.

JD Edwards

In version 14.3.84, the BU Cat Code Value Description-related ad hoc queries were revised. To use these modified queries, copy the BU Cat Code Value Description.xml and BU Cat Code Value Description_DD.xml files from C:\Program Files\Global Software Inc\Spreadsheet Server\AdHocQueries to the appropriate ad hoc folder.

SAP

1. In version 14.3.68, modifications were made to allow for sorting grouped queries. To implement this new feature:
1. Ensure the current transports GL0K900578 - 640, GL0K900570 - NW7+, and GL0K900574 - NW7+ with Table Security or higher have been installed
2. For each user, open Query Designer and click Settings, then select Include SAP “AS” Alias.
3. In Query Designer, open and save each query for which to apply the new feature.
2. In version 14.4.1, Configuration was added as a new Key 3 parameter for SAP GXL and GXD formulas. If you only use one SAP host configuration, all existing Spreadsheet Server formulas and drill downs should calculate/function normally. If you have multiple host configurations, all existing spreadsheets must be reviewed and modified as necessary using the following steps:
1. Insert a row for the new Key 3 parameter and assign Configuration as the parameter header.
2. In the column containing formula parameters, place the cursor in the cell for the new host configuration parameter, and type the appropriate configuration name or number. Repeat this step as necessary for each column of parameters or copy the value if appropriate.
3. Place the cursor in the cell containing a GXL formula and from the Spreadsheet Server ribbon in Excel, click Formula Assistant. Modify the GXL to include the additional parameter in the formula, and press F4 to lock either the row and/or column value of the cell reference, then click Insert. Repeat this step as necessary for each GXL, or copy the formula if appropriate.
4. Place the cursor in the cell containing a GXD formula and from the Spreadsheet Server ribbon in Excel, click Formula Assistant. Modify the GXD to include the additional parameter in the formula, and press F4 to lock either the row and/or column value of the cell reference, then click Insert. Repeat this step as necessary for each GXD, or copy the formula if appropriate.
3. In version 14.4.1, changes were made in Query Designer to properly return values containing any special characters (for example, a period, comma, or dash); however, there are limitations when values contain a vertical line ( | ) as the incoming data from SAP uses this character as a delimiter. To resolve this issue, modify queries returning values containing a vertical line ( | ) to either convert the character or replace it using a calculated field.

Additional Post Installation

Continue to Upgrade from Version 14.4 or Lower for additional post-installation steps.

Upgrade from Version 14.4 or Lower

This section references additional post-installation steps required when upgrading to the latest release from version 14.4 or lower.

Infinium

In version 14.4.46, indexes were added to the Infinium Load Local MS Access database. As a result, all existing Load Local INF profiles using a Microsoft Access database must be rebuilt. Open Profile Scheduler, and for each existing Load Local INF profile that uses a Microsoft Access database type, edit the profile, and select Replace All Data for this Configuration option, in addition to selecting other appropriate processing options, click OK, then run the profile.

JD Edwards

1. In version 14.4.46, JDE FXA Designer GL ad hoc queries were revised for GXE journals processing and the JDE_iSeries_FXA Designer GL definition was revised for Expand Row processing. To use these modified files:
1. Copy the JDE iSeries FXA Details.xml, JDE Oracle FXA Details.xml, and JDE SQL FXA Details.xml files from C:\Program Files\Global Software Inc\Spreadsheet Server\AdHocQueries to the appropriate ad hoc folder.
2. Copy the JDE_iSeries_FXA.xml file from C:\Program Files\Global Software Inc\Spreadsheet Server\CustomGL to the appropriate Designer GL definition folder.
3. Ensure the proper Connection Name is assigned to the JDE_iSeries_FXA Designer GL definition.
2. In version 14.4.158, JDE_iSeries_FXA, JDE_Oracle_FXA and JDE_SQL_FXA Designer GL definitions were revised for removal of the conversion of the FANUMB field. To use these modified files:
1. Copy the JDE_iSeries_FXA.xml, JDE_Oracle_FXA.xml, and/or JDE_SQL_FXA.xml files from C:\Program Files\Global Software Inc\Spreadsheet Server\CustomGL to the appropriate Designer GL definition folder.
2. Ensure the proper Connection Name is assigned to the Designer GL definitions.
3. In version 14.4.158, new Designer GL definitions, JDE_iSeries_FXA_No_Cat_Codes, JDE_Oracle_FXA_No_Cat_Codes, and JDE_SQL_FXA_No_Cat_Codes, were delivered for reporting Fixed Asset data without Business Unit and/or Account Category codes. To use these new files:
1. Ensure the proper Connection Name is assigned to the Designer GL definitions.
2. For each user, set the default Designer GL.
3. Update spreadsheets with the proper Designer GL name.
4. In version 14.4.177, extended category codes, Business Unit category codes MCRP31 to MCRP50, and Account category codes GMR024 to GMR043, were added to the JDE Load Local database. As a result, all existing Load Local JDE profiles must be rebuilt. Open Profile Scheduler and for each existing Load Local JDE profile, edit the profile, and click Replace All Data for this Configuration option, in addition to selecting other appropriate processing options, click OK, then run the profile.

Oracle

In version 14.4.96, VSegment ad hoc queries were revised to use language processing. To use these modified queries, copy the Oracle_VSegment.xml files from C:\Program Files\Global Software Inc\Spreadsheet Server\AdHocQueries to the appropriate ad hoc folder.

Additional Post Installation

Continue to Upgrade from Version 14.5 or Lower for additional post-installation steps.

Upgrade from Version 14.5 or Lower

This section references additional post-installation steps required when upgrading to the latest release from version 14.5 or lower.

Post Installation

In version 14.5.139.13, saved grid layouts were modified to properly save column sort order for all drill down panels. insightsoftware recommends reviewing and resaving, or deleting and recreating all saved grid layouts.

Query/Query Designer (previously EDASH)

1. In version 14.5.112.1, a new File Type of I was added for image fields in Query Designer. To implement this change in existing queries referencing tables containing an image field, open the existing query in Query Designer and click Refresh Field Names for Database.
2. In version 14.5.131.1, the tables selection process was updated to use Configurator Query Designer Object Security options for listing tables, views and/or synonyms. To implement this change, open one existing query in Query Designer for each connection type, click the Tables panel, then click the Refresh.

JD Edwards

1. In version 14.5.1, the JDE_iSeries_FXA and JDE_iSeries_FXA_No_Cat_Codes Designer GL definitions were revised to properly trim the Business Unit field. To use these modified files:
1. Copy the JDE_iSeries_FXA.xml and JDE_iSeries_FXA_No_Cat_Codes.xml files from C:\Program Files\Global Software Inc\Spreadsheet Server\CustomGL to the appropriate Designer GL definition folder.
2. Ensure the proper Connection Name is assigned to the Designer GL definitions.
2. In version 14.5.116.1, the FXA Designer GL ad hoc queries were revised for improved security processing and converting text and graphic character data to VARCHAR. The JDE_iSeries_FXA and JDE_iSeries_FXA_No_Cat_Codes Designer GL definitions were revised to convert text and graphic character data to VARCHAR. Additionally, the JDE_iSeries_FXA, JDE_Oracle_FXA, and JDE_SQL_FXADesigner GL definitions were revised to properly pad the Business Unit field when processing in Designer GL mode and for improved security processing. To use these modified files:
1. Copy the JDE iSeries FXA Details.xml, JDE Oracle FXA Details.xml, and JDE SQL FXA Details.xml files from C:\Program Files\Global Software Inc\Spreadsheet Server\AdHocQueries to the appropriate ad hoc folder.
2. Copy the JDE_iSeries_FXA.xml, JDE_iSeries_FXA_No_Cat_Codes.xml, JDE_Oracle_FXA.xml, and JDE_SQL_FXA.xml files from C:\Program Files\Global Software Inc\Spreadsheet Server\CustomGL to the appropriate Designer GL definition folder.
3. Ensure the proper Connection Name is assigned to the Designer GL definitions.
3. In version 14.5.117.1, the JDE_iSeries_FXA_No_Cat_Codes, JDE_Oracle_FXA_No_Cat_Codes, and JDE_SQL_FXA_No_Cat_Codes Designer GL definitions were revised to properly pad the Business Unit field when processing in Designer GL mode. To use these modified files:
1. Copy the JDE_iSeries_FXA_No_Cat_Codes.xml, JDE_Oracle_FXA_No_Cat_Codes.xml, and JDE_SQL_FXA_No_Cat_Codes.xml files from C:\Program Files\Global Software Inc\Spreadsheet Server\CustomGL to the appropriate Designer GL definition folder.
2. Ensure the proper Connection Name is assigned to the Designer GL definitions.
4. In version 14.5.130.1, saved grid layouts for GXL (Account Balances) and GXSALES drill down panels were separated. insightsoftware recommends deleting and recreating GXSALES grid layouts using the steps below:

Note: Unless grid layouts are shared (for example, in a stored in a network location), each user must perform this clean up procedure.

1. Drill down on a GXL formula and delete all existing grid layouts previously meant for GXSALES.
2. Drill down on a GXSALES formula and recreate new grid layouts as desired.
5. In version 14.5.131.1, all six of the JDE_FXA Designer GL definitions were revised to remove the trim and instead left pad the Business Unit field with spaces, to enable the segment lookup to process more efficiently, and to use &LIBL to retrieve the database library when in JDE mode. To use these modified files:
1. Copy the appropriate JDE_FXA.xml files from C:\Program Files\Global Software Inc\Spreadsheet Server\CustomGL to the appropriate Designer GL definition folder.
2. Ensure the proper Connection Name is assigned to the Designer GL definitions.

Lawson

In version 14.5.116.1, VSegment ad hoc queries were revised to retrieve and use the fully qualified table name. To use these modified queries, copy the Lawson_VSegment.xml files from C:\Program Files\Global Software Inc\Spreadsheet Server\AdHocQueries to the appropriate ad hoc folder.

SAP

In version 14.5.126.1, the option Include SAP “AS” Alias was moved from the Query Designer Settings function to the SAP tab on an open query, allowing the user to specify the setting for each individual query. insightsoftware recommends opening each SAP connection type query and reviewing the Include SAP “AS” Alias option setting to ensure it is set as desired.

Additional Post Installation

Continue to Upgrade from Version 14.6 or Lower for additional post-installation steps.

Upgrade from Version 14.6 or Lower

This section references additional post-installation steps required when upgrading to the latest release from version 14.6 or lower.

JD Edwards

1. In version14.7.0, the JDE_HSegments.xml file was removed from the installation setup program. If the pre-existing JDE_HSegments.xml file is not being used, the file may be manually deleted from the appropriate ad hoc folder to reduce processing time when starting Spreadsheet Server.
2. In version 14.7.0, the ad hoc query JDEdwards_VSegment2 was revised to remove leading spaces from the Business Unit in order to retrieve the proper description of Business Units during drill down and expand by segment processing. To use this modified query, copy the JDEdwards_VSegment2.xml file from C:\Program Files\Global Software Inc\Spreadsheet Server\AdHocQueries to the appropriate ad hoc folder.

SAP

In version14.7.1, the special ledger SAP_CONS definition was revised to remove segments Prod Group, Cust Group, and Distr Channel. To use this modified definition, copy the SAP_CONS.sap file from C:\Program Files\Global Software Inc\Spreadsheet Server\CustomGL to the appropriate Designer GL definition folder.

Additional Post Installation

Continue to Upgrade from Version 14.8 or Lower for additional post-installation steps

Upgrade from Version 14.8 or Lower

This section references additional post-installation steps required when upgrading to the latest release from version 14.8 or lower.

Profile Scheduler

In version 14.8.4, logic was added to update the path used by scheduled jobs in Profile Scheduler. To implement this change, after upgrading Spreadsheet Server, open Profile Scheduler and then edit and save (click OK) each scheduled job.