Tie out your data to ensure your numbers match by following these steps:
- Check the setup of your spreadsheet
- Confirm dimensions are set up as you expected
- Confirm the data is up to date with the most recent numbers
đ If the tie-out doesn't match a Cube Formula Dimension, re-calculate your formula.
đŁď¸ Drilldowns are your friend when it comes to finding discrepancies within data. Because Cube shows you the line items from your source system, you can see exactly which data is rolling up into a given fetched value.
Check the setup of your spreadsheet
The first thing youâll want to check is the setup of your spreadsheet.
- Use the Validate in your Add-On to ensure that Cube recognizes every dimension within your fetch range - update any dimensions that got flagged as unrecognizable.
- We all know spreadsheets love to try and force values to be dates. For any Time Dimensions on your sheet, youâll want to ensure the spreadsheet didnât convert them to an underlying date different from what you intended.
- Example: Typing âJan-22â into a cell will convert it to a date of January 22nd for the current year; e.g., if you were to do this today, it would convert it to Jan. 22, 2023. Whereas in Cube, the âJan-22â Time dimensions are for January 2022.
- Avoid this by putting a single quote in front of your dates to force them to remain as expected, i.e., âJan-22
- For any dimensions not on your spreadsheet and instead being used as filters, youâll want to confirm the selections match the data you expect to see.
-
- Example: If you are using a filter such as âAll Departmentsâ, youâll also want to check that all of your Department dimensions live underneath that dimension as expected.
If a dimension is missing, it will not be included in the All Departments rollup. - Fix this by re-parenting your missing dimension to the appropriate allocation and refreshing your Add-On to retrieve the updates.
- Example: If you are using a filter such as âAll Departmentsâ, youâll also want to check that all of your Department dimensions live underneath that dimension as expected.
-
Supporting Resources:
- Guide to Formatting Dates in the Cube Add-on
- How to Validate a Range
- How to Re-Parent or Re-Order a Dimension
If everything on the spreadsheet itself is looking as expected, move on to the next step:
Confirm the setup of your dimensions are as expected.
- Check the time rollup settings on your dimensions to ensure they are set properly. Dimensions configured with no time rollup setting will not show data at time rollups (e.g. at the quarterly or yearly levels).
- Confirm that the dimensions you are looking at are in the expected spots in your dimension hierarchy.
E.g. if you expect Accounts Receivable - Other to rollup into Accounts Receivable in the screenshot below, you'd need to move Accounts Receivable - Other underneath Accounts Receivable in the hierarchy
See: How to Re-Parent or Re-Order a Dimension - If any formulas or tags are involved in your data fetch, double-check the formulas are set up as expected.
đ Be sure to check downstream formulas. E.g., if "Net Income" is off, and Net Income references Gross Profit, then you'll want also to confirm that Gross Profit is set up correctly: - Confirm your dimension mappings between your source system and Cube to ensure data is being mapped to where it is expected.
Supporting Resources:
If the spreadsheet and dimension settings look as expected, move on to the final step.
Check the last time the data was refreshed.
This is if you are looking at Actuals data imported from an external source system.
Use the import history for any source systems connections in Cube to see the last time an import was run and for which Time dimensions the data was imported to.
If it has been a while since your last import, and you are comparing the data in Cube to your source system, then a fresh import to ensure Cube has the latest data from your source system.