Please see ICT's guidance on requesting additional access.

Please speak to your local finance team who will help you determine the codes you need.

An email should be sent to Finance Systems from your Faculty Finance Officer (FFO).

Please contact the ICT Service Desk.

Please contact the Purchasing, Accounts Payable, and Expenses Helpdesk for further support and guidance.

Various issues could be causing this.

Please see this link where the likely issues and resolutions are laid out.

Should this not be the reason for the issue please contact the ICT Service Desk.

You are likely using a payroll code which cannot be used in online journals.

Please speak to your Finance team to determine the correct course of action.

Please contact your local Research Service team.

This occurs when the connection to Essbase server has timed out.

To resolve this, please follow the steps below to disconnect the spreadsheet from Essbase in the first instance and then reconnect using your normal college login.

    Disconnect from Essbase:

1. 1 Click Smart View -> Panel.

2. Click the down arrow on the Smart View Home button

3. Select Disconnect all from the drop down list

   To reconnect worksheet to the database:

   4. Click Smart View -> Panel

   5. Click Private Connections.

   6. Enter/select  the URL https://epmprd.ad.ic.ac.uk/aps/SmartView.

   7. Expand EssbaseCluster-1, then ICRpt, right click on Budget and click Connect. Enter your normal username and password when prompted.

   8. Right click on Budget again, and click Ad hoc analysis.

   9. Click the third option, Reuse sheet contents and POV.
   

 a) Put cursor/focus on a cell that has a value and a format applied
b) In the menu dropdown list, choose "format/cells"
c) At the bottom of the number format list, find "custom", click on it
d) Scroll down to the bottom of the list - upper items are default formats, bottom of list will be custom formats you've created over time, perhaps from every workbook you've ever created
e) Starting at the bottom, highlight a custom format you know you don't need, put a checkmark in the "Delete" box, then click ok.  Repeat for all unused custom formats .

Cause:  Logged into SmartView, using a sheet that had previously been connected.

Action: Select Reuse sheet contents and POV.

Cause:  Excel has crashed and had to be forced to restart

Action: Select No, do not disable add-in

Cause:  Analysis code not in text

Action: Convert the analysis code to text, append ‘ to the code

Cause:  Member of the hierarchy is duplicated within the report (in this example, the Indicator code)

Action: Check for the identified member and remove from the report, if the member name as description, add a space or to differentiate it from a hierarchy member name.

Cause: Missing member name from dimension.

Action: Ensure level 0 members are specified for all dimensions.