Clients are changing their fiscal year to the calendar year and are needing to modify/update data connections, data integration, and reports to ensure reports/reporting tools are able to accommodate this change.
Setting
- Hyperion Essbase on prem with integrated with Lawson
- Roughly 8 cubes in their cube farm, in the process of upgrading Essbase and taking advantage of more Automation
- SQL Server databases
- SQL- Stored procedures and SSIS
- VB and Excel
Requirements
- Visual Studio – SSIS integrations
- Visual Basic coding
- SQL queries
- Hyperion/Essbase
- Data loading
- ASO Cube Calculations
- BSO Cube Calculations
- Drill down concepts
- Debugging incorrect data