Company: Solvership
Product Title: PI Telco DWH Model 4.0
Frameworx Version: 18.5
Assessment Completion Date: June 2019
Detailed Certification Report: Frameworx 18.5 Final Certification Report for Poslovna Inteligencija PI Telco DWH Model 4.0 v1.0

General Overview

This document provides details of Solvership’s self-assessment and TM Forum’s Conformance Assessment of the PI Telco DWH Model 4.0, against the following Frameworx 18.5 component:

• Business Process Framework (eTOM)
• Information Framework (SID)

The assessment included a review of:

The methodology approach to process modeling against the TM Forum’s Business Process Framework and Information Framework Release 18.5 according to the specific processes submitted in scope for the Assessment.

Product Functionality/Capability Overview

Poslovna Inteligencija Telecommunications Data Warehouse Data Model (PI Telco DWH model ®) is standard industry data warehouse model applicable for both fixed and mobile telecommunications operators, covering traditional Business Intelligence requirements, regulatory requirements including GDPR and IFRS 15, Big Data Analytics and IoT requirements.

Logic of the model is following TM Forum’s Information Framework Shared Information Data Model (SID), as a common reference model that service providers, software providers, and integrators use to describe enterprise management information.

Based on data represented in the model, all standard Telecommunication reporting and analysis Data Marts can be delivered, and ones regularly used are already defined as Subject areas in the model.

PI Telco DWH model ® is based on industry best practices, developed and applied during data warehouse system implementations in telecoms in Europe, Africa and Asia with more than 15 reference implementations. Also, model is open for necessary alterations and modifications required for each telecom customer.

Architectural Approach

The diagram below represents PI Telco DWH model 4.0 architectural approach.

PI Telco DWH model 4.0 – Architectural Approach

Explanation of elements of the architecture and process:

• Source – Different source systems used to load PI Telco DWH model
• Extraction Layer – source data access layer. It may use push, pull or streaming technologies
• Landing / Stage Area – temporary area where source data is staged for further processing. It is recommended to keep N last loads in this area. Table structure in this area corresponds to the structure of tables / views from source systems
• Foundation Area – historical area where all historical changes are preserved. Table structure in this area corresponds to the structure of tables / views from source systems, but with added SCD2 attributes for master data.
• Manual Entry – area where manual entry attributes are maintained for attributes and dimensions that does not exist in source systems such as analytical hierarchies
• Base Layer – part of PI Telco DWH Model that contains tables loaded and transformed directly from source systems
• Performance & Analytics Layer – additional tables for analytical purposes based on aggregated data from Base Layer (Data Marts). Some Data Marts are in separate Subject Areas and some are in the same Subject Area as corresponding Base Layer tables
• Process Control Framework (PCF) – framework designed for running and managing cross-platform data processes. PCF addresses the question of achieving parallelism, performance optimization and dependency management

Business Process Framework Level 2 Process Scope

The diagram below represents PI Telco DWH model 4.0 view of the Business Process Framework Level 2 processes. The red box shows the process elements in scope.

Level 2 process coverage for PI Telco DWH model 4.0

Information Framework Assessment – ABE Scope

The diagram below represents PI Telco DWH model 4.0 view of the Information Framework Level 1 ABEs. The red boxes show the number of ABEs or sub-ABEs in scope. 

Level 1 ABEs coverage for PI Telco DWH model 4.0

PI Telco DWH model 4.0 – Packaging

PI Telco DWH model ® is delivered with following documentation:

• PI Telco DWH model ® in ERWin format that can be exported to other required formats
• Detailed Subject Areas Documentation
• Implementation and Customization Guide Documentation – how to implement model
• Detailed ERWin Model Report Documentation (~500 pages)
• 40 Report and 5 Dashboard Mockups in Excel
• Business Glossary with 400+ definitions
• KPI list with 150+ standard telco KPI definitions
• Source to Target Mapping templates
• Detailed Model content and Methodology Presentation for knowledge transfer (400+ Slides)

Detailed Certification Report: Frameworx 18.5 Final Certification Report for Poslovna Inteligencija PI Telco DWH Model 4.0 v1.0

For more information on PI Telco DWH Model 4.0 and Poslovna Inteligencija D.O.O., please contact:
Dražen Oreščanin
President of the Board
Poslovna Inteligencija D.O.O.
E-mail : [email protected]

For any additional information on this Frameworx Conformance Certification Report, please contact TM Forum at [email protected]

Report Misuse: Frameworx conformance is an important part of enabling the communications industry to maintain profitability as it migrates to new services and new business models. Gaining the conformance mark represents a significant investment by both suppliers and service providers. If you feel a company is misusing the conformance mark then please let us know at [email protected].

Disclaimer: TM Forum has conducted no independent testing of the solution for conformance with its frameworks or standards. Such testing has solely been conducted by the supplier or seller of the product and has been self-assessed by the supplier or seller for adherence to the TM Forum framework or standard in question. Accordingly, under no circumstances will TM Forum be liable for any direct or indirect damages or any costs or losses resulting from the use or reliance by any party of or upon such certification.