/
How to Refresh Excel Cubes for Munis
How to Refresh Excel Cubes for Munis
Description of Issue
How do I get today's data in Cubes?
Context
- Microsoft Excel Cubes
- Munis
- SAAS
- OnPrem
- Refresh
Cause
Cubes pulls data once a day by design. Tyler Systems Management typically schedules this to run at 4 am daily.
Resolution
- Login to the server where Cubes is installed
- Launch Microsoft SQL Server Management Studio (SSMS)
- Click the Connect button at lower left of the pop up window
- Expand SQL Server Agent
- Expand Jobs
- Right click on the cubes for the Munis environment you are refreshing
- Select Start Job at Step
- Click on Start at the bottom of the pop up window
- Launch Microsoft SQL Server Management Studio (SSMS)
Note: You may pick a specific Cube (Payroll, Utility Billing, etc.) to refresh however it will also refresh every job in the list. Typically you would choose the default: Step 1
Additional Information
SaaS Clients do not have access to the Cubes Server and should reach out to Tyler Systems Management for the refresh.
Please review the Master Article - Cubes Reporting with Excel for all Cubes related topics.