Mobilix/Orange, 2000-2003


System Developer (Decision Support Programmer)

Timeframe and context

Period
June 2000 through June 2003.
Work form
On site.
Location
Amager.
Role
System Developer (Decision Support Programmer).
Interfaces
Primarily the rest of the data warehouse project, as well as business users (including customer service).

Pitch

In the period from June 2000 through June 2003, on-site development was delivered at Mobilix (later Orange) on Amager, where the work was anchored in the data warehouse project and consisted of developing and maintaining reporting on the data warehouse. This was primarily achieved via Business Objects with universes and reports, while simultaneously expanding the data model with new fact tables targeted at customer service needs, ensuring that reporting logic and the data foundation could remain aligned and adapt continuously without becoming a fragile setup.

Key outcomes

Work in detail

Background and goals

The task was solved at Mobilix (later Orange) during the period from June 2000 through June 2003, aiming to deliver an operational decision support solution based on the data warehouse. This ensured that reporting could be built consistently and maintained over time, rather than ending up as a collection of standalone reports that only functioned as long as everyone remembered the unwritten rules.

Data warehouse and data model (fact tables for customer service)

The work was anchored in the data warehouse project, and a central part involved expanding the data model with new fact tables targeted at customer service needs. This allowed reporting to be based on a data foundation that actually supported business questions, rather than forcing existing structures to answer new needs with increasingly fragile logic.

Business Objects, universes, and reports

Reporting on the data warehouse was handled primarily with Business Objects, where universes and reports were developed and maintained. The focus was on keeping definitions, relationships, and the data foundation consistent so that reports did not begin to diverge in meaning simply because they were created by different people at different times.

WebIntelligence, appearance, and intranet integration

Part of the delivery also involved customizing the appearance of WebIntelligence (which was done without the use of GUI tools because the business did not want to pay for that specific component). Consequently, the customization had to be solved by configuring and adjusting in a way that still provided a coherent user experience, making the solution resemble the intranets of Mobilix and Orange and ensuring it did not stand out when users logged in.

Delivery format

The work was performed on-site at Amager, and the task was tied to a data warehouse project where changes in reporting and changes in the data foundation had to align, avoiding situations where reports pulled in one direction and the model in another.

Technologies

Primary

Secondary

Company

Mobilix was a Danish mobile phone company established as a subsidiary of France Télécom (which changed its name to Orange in 2001). The Danish Orange business was subsequently sold to TeliaSonera (Telia) in 2004, and Telia's Danish business later became part of Norlys.

Official site: https://www.orange.com/