I have a requirement to create a report which has actual, budget spread across different fiscal years. Currently the business users use Excel based workbook to maintain all the information and summarise it into single worksheet with calculations.
The row wise report layout has hierarchical format;
XXXXXXX --> Different Nodes with calculated figures
The data has to extracted to BO using Computron system, I'm not sure the database behind this system.
This is easily achievable in BEx, I'm still new to BO finding ways to complete this task.
Please advise how should I proceed with universe designer and what tools should I use to get the required outcome. Need you urgent response.