data management, Aexis Jedox Webinars, Jedox, afternoon session, free webinar, event, bimac, excel, Yakult, Year End Event BIMAC

Customer Case

Project organisation

Business Challenges

RAI Amsterdam organises more than 100 events, exhibitions, shows and international conferences every year. RAI Amsterdam works together with many partners including temporary employment agencies, hotels, organisation agencies and selling agencies. The finance organisation described the working environment as a (quote) ‘True spreadsheet hell’. Each event is budgeted and forecast every quarter in order to reach an accurate year end forecast. All versions are kept for analysis and the budget of coming years.

Solutions, Aexis approach & assistance

In 2005 already RAI Amsterdam and Aexis started using IBM Planning Analytics (TM1).

The data from the primary systems is integrated to realize a detailed P&L per project and to have an consolidated overview of all projects. The annual budget is created in an efficient and automated way on the basis of the previous years' drivers such as number of visitors and square metres.

The solution was later expanded to include commission calculations for agents, reporting model on temporary workers, rolling forecasting and charging of costs.

Results & Benefits

aexis check

An overview with actuals, budgets and different forecast scenarios.

aexis check

Unlimited flexibility in reporting and ad hoc analysis, including many years of history.

aexis check

Self-service: business creates and manages its own reports.

aexis check

Budgeting per event and theme, such as catering, rental, accommodation.

aexis check

Complex methodology for charging of costs.

More information about our solutions?

Download our CPM brochure

Want some more information? Download our brochure and read all about our solutions and product specification. Or directly ask our expert.

cpm brochure download




I agree to receive information from Aexis about their solutions.