Data Warehouse

Data Warehouse jobs produce extracts in CSVClosed Comma Separated Values. A simple file format used to store tabular data, such as a spreadsheet or database. CSV files can collect the data from tables so that it can be input to another table-oriented application such as a relational database application. format. The jobs operate on CMPClosed Converged Monetisation Platform. The MDS Global product that supports customer care and billing for digital service providers. database tables and do not require JSONClosed JavaScript Object Notation. JSON is a lightweight format for storing and transporting data, often used when data is sent from a server to a web page. schemas. For more information on Data Warehouse extracts, see the Data Warehouse section of the CMP Extracts Guide.

The jobs include:

Account Analytics

This job extracts accountClosed In the Cloud Monetisation Platform, a billing entity that can be used to manage payments on one or more subscriptions or payments for services. An account can hold details such as payments or invoices. information and makes it available for a third partyClosed Of software; a reusable component developed to be either freely distributed or sold by an entity other than the original vendor of the development platform. to analyse.

Agreement Analytics

This job allows for agreements to be extracted and made available for a third party to analyse. Each invocation of the job produces an audit outlining the number of agreementClosed In the Cloud Monetisation Platform, the entity that holds the instructions for generating the bills for one or more subscriptions. including the addresses and how often the bill is generated. records that were included in the extract. Typically, this a scheduled job and runs daily.

Billed Usage Analytics

This job extracts billed usageClosed The consumption of services, for example a subscriber using call minutes. information and makes it available for a third party to analyse . Each invocation of the job produces an audit that outlines the billed usage records that were included in the extract as well as the extract file itself. Typically this job is scheduled to run daily.

Hierarchy Analytics

CMP allows for information to be extracted from its database and made available for third party analysis.

Hierarchy information changes over time, for example subscriptions can move to different accounts, or accounts to a different corporate. While CMP stores only the current hierarchy, it is important that a historical view of the hierarchy is also available. This job gathers the customerClosed In the context of the Cloud Monetisation Platform, an individual or organisation who has signed an agreement to take goods and services from a service provider. A customer receives a bill associated with one or more subscriptions, and can be a single end user or a large company with many subscriptions assigned to one agreement. hierarchy information (subscriptionClosed A billing entity that incurs a charge. Examples include a network attached device whose usage you want to measure and charge for, or a monthly software subscription, account, corporate and groupClosed In the Customer Manager Platform hierarchy, the highest level of the structure. The group level can be used to group corporates. Groups can hold financial information.) that was in effect at the time of the most recent billing process.

The job takes a single optional parameter, which is the invoice run number for the extract to be produced. If no parameter is specified, then the latest invoice run will be used.

When the job completes successfully, extract files have been sent via FTPClosed File Transfer Protocol. A standard network protocol used for the transfer of files between a client and server on a computer network. to CXPClosed Customer Experience Platform, or CXP, is MDS Global's self-service app that allows business customers to manage their own accounts and subscriptions. servers.

This job is typically scheduled to run once per day after a billing process.

Invoice Analytics

CMP allows for information to be extracted from its database and made available for third party analysis. This job gathers details of invoices generated during the most recent billing process.

This job performs an extract of invoice data in the required format for processing by CXP. The job takes three optional parameters:

  • Invoice Run Number
  • Extract ID
  • Extract Set ID

If an Invoice Run Number is specified, it is used to generate a new extract. If you specify an Extract ID, you must also supply an Extract Set ID, and these are used to regenerate a specific extract set. If no input parameter is specified, the latest invoice run number is used to generate a new extract.

This job is typically scheduled to run once per day after a billing process.

Invoice Detail Analytics

This job extracts invoice detail information and makes it available for a third party to analyse. Typically, this is a scheduled job and run daily.

Payment Detail Analytics

This job extracts payment details information makes it available for a third party to analyse.

Prepaid Usage Analytics

This job extracts prepaid usage information and makes it available for a third party to analyse. Each invocation of the job produces an audit outlining the prepaid usage records that were included in the extract. Typically, this job this is a scheduled job and is run daily.

Purchases Analytics

This job extracts package purchase information and makes it available for a third party to analyse. Each invocation of the job produces an audit outlining the purchase records that were included in the extract.Typically, this job would be on a schedule and run daily.

The job can be run in Full or Partial mode:

  • If the job runs in Full mode, all records from Purchase and Purchase Product tables are included.
  • If the job runs in Partial mode, records are only be considered if they have been created or changed since the last execution of the job.

Statement Analytics

The Statement Analytics job extracts statement details and writes the information extracted to a CSV file, which can then be encrypted based on the encryption requirements configured. The job can run in both Full mode and Partial mode:

  • In Full mode the job extracts all statement information up to the end of the previous day.

  • In Partial mode the job extracts statement data from the previous date up to which the job extracted data.

Subscription Analytics

This job gathers subscription information to be extracted and makes it available for a third party to analyse. Each invocation of the job produces an audit outlining the subscription records that were included in the extract. Typically, this is a scheduled job and run daily.

Subscription Features Analytics

This job extracts subscription feature information and makes it available for a third party to analyse. Each invocation of the job produces an audit outlining the subscription feature records that were included in the extract. Typically, this job would be on a schedule and run daily.

The job can be run in Full or Partial mode:

  • If the job runs in Full mode, all records from Purchase and Purchase Product tables are included.
  • If the job runs in Partial mode, records are only be considered if they have been created or changed since the last execution of the job.

Subscription Service Analytics

This job extracts subscription service information and makes it available for a third party to analyse. Each invocation of the job produces an audit outlining the subscription service records that were included in the extract. Typically, this is a scheduled

job and run daily.

Transaction Detail Analytics

This job extracts sales ledger transaction information and makes it available for a third party to analyse. Each invocation of the job produces an audit outlining the transaction records that were included in the extract. Typically, this is a scheduled job and run daily.

Unallocated Usage Analytics

This job gathers unallocated usage information and makes it available for a third party to analyse. Typically, this is a scheduled job and run daily.

Unbilled Usage Analytics

This job allows for unbilled usage to be extracted and is made available for a third party to analyse. Each invocation of the job produces an audit outlining the number of usage records that were included in the extract. Typically, this a scheduled job and runs daily.

The following probes can be run against jobs and daemons in the Data Warehouse suite:

Name Type Description
Prepaid Analytics Extract Completed Alert An alert probe that checks if all the data warehouse jobs (i.e. Subscription, Subscription Service, Subscription Feature, Account, Agreement, Purchase, Payment, Prepaid Usage, Unallocated Usage) relating to the prepaid consumer process have run today and produced files. The probe is expecting a total of 9 files. If this query returns a value less than 9, this indicates some or all of the jobs have not run today and an alert will be sent to the recipients configured on this probe.
Postpaid Analytics Extract Completed Alert An alert probe that checks if all the data warehouse jobs (i.e. Subscription, Subscription Service, Subscription Feature, Account, Agreement, Unbilled Usage, Billed Usage, Unallocated Usage, Invoice Detail, Payment Details, Transaction Detail, Purchase) relating to postpaid consumer have run today and produced files. The probe is expecting a total of 12 files. If this query returns a value less than 12, this indicates some or all of the jobs have not run today and an alert will be sent to the recipients configured on this probe.
Statement Analytics Batch Completed Alert Alert probe that returns the number of times the Statement Analytics Job has run today. If the probe identifies that the job has not run today then an alert will be sent to the recipients configured against the probe.
Statement Analytics Extract Completed SLA SLA probe that returns the number of files produced by the Statement Analytics Job today. If the probe identifies that the job has not produced any outbound files then the SLA has been breached. Since this is an SLA probe, there is no email alert issued.