Data consolidation
Combine and unify data from multiple systems for centralized planning.Map & transform data
Cleanse and connect data to your Cube structure.-
Best practices for managing dimensions
-
How to Bulk Edit Dimension Members
-
Map a Source System to Cube
-
Reparent or reorder a dimension member
-
Check dimension mapping
-
Opening Balances in Cube
Perform calculations in Cube
Use formulas and logic to calculate values directly in Cube.-
Mix Calculated and Manual Values With SKIP
-
Write Conditional Formulas With IF
-
Add Criteria to a Formula Reference
-
Reference Table data in a formula
-
Common formulas and supported operations
-
Guide to formulas rollup logic