Master Article - Cubes Reporting with Excel
- Knowledge Assistant
Owned by Knowledge Assistant
Description of Issue
I am looking for all information related to Cubes reporting in Excel.
Context
- Excel
- Cubes
Cause
Informational.
Resolution
General:
- How to log into Excel Cubes for Enterprise ERP
- How to Refresh Excel Cubes for Munis
- How to grant permissions for user to access Cubes
- Excel Formula and Munis Cubes
- Cubes - Showing more or less data than expected for User
General Troubleshooting:
- New cubes users cannot see data in Cubes - Tyler Reporting Views Permissions need to be granted
- User is Able to Log into Cubes but is Unable to View Any Data
- Cubes- Pivot table only displaying first 10000 records
- Data from only certain years showing on Cubes
Payroll Employee Cube:
- Payroll Cube is not showing any data
- Payroll Cube doubling accrual balances
- Project Codes Not Pulling Into Payroll Cube
- Unable to see Job Class and Grade in Payroll Cubes
- Adding additional fields to the Payroll Cube
- Project Title in Cubes Report
General Ledger Cube:
- Budget Projection Cube amounts are doubling, tripling, etc. compared to what shows in Munis
- All Cubes Except Budget Projections Cube Are Available
- Actuals amount in GL Cube does not match Account Inquiry or YTD Budget Report - Cube filtered by Account Status
- Unposted Actuals in the General Ledger Revenue and Expense Cube
- Budget Projection Cube - Summary and Detail Amount available Years
- Budget Projection Cube Does Not Display Budget Levels Higher Than Five
- General Ledger Cube showing no data for user with limited data access in programs other than Account Inquiry
- Budget Projection Cube - Summary and Detail Amount available Years
- Account not displaying in Cubes - No record on table holding master balances
- Current year percentage of budget used column is blank - Revenue and expense cube
- Project Accounting Cube - Missing project code
- Project Ledger Cube excluding unposted transactions
- Budget Projection(s) missing on Budgeting Cubes
- Next Year budget amounts are incorrect in Cubes
- Journal Description (Comment) field missing from Assets and Liabilities Cube
- Starting and Ending balances are incorrect in the Asset and Liability Cube
Enterprise Assets Management:
Expense and Revenue Cube:
- Summary values in Revenue and Expense Cube not changing with Time Period
- Property Tax Cube fails at Load TxPropertyDim
- AR cube report missing value options after upgrade from 11.3
Position Cube:
Inventory Cube:
- Inventory Cube does not show any values for On Hand Balance
- Cubes failing on truncation error of initmmst.init_item and intrhist.intr_item
- GL accounts are showing up as UNKNOWN in Inventory Cubes
Tyler Hub:
Additional Information
Please reach out to the support team closest related to your specific Cubes process with any additional questions.
Connect 2023 - Reporting with Excel Intermediate - Financials