Data Warehouse

The Data Warehouse jobs take extracts from CMPClosed Converged Monetisation Platform. The MDS Global product that supports customer care and billing for digital service providers. and make it available for 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. analysis. The jobs include:

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 party to analyse.

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 and run daily.

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.

CMP 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. This job is typically scheduled to run once per day after a billing process.

This job gathers details of invoices generated during the most recent billing process. This job is typically scheduled to run once per day after a billing process.

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.

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

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

The Statement Analytics job extracts statement details and writes the information extracted to a 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. 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.

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.

This job extracts package purchase information 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.

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.

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.

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.

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

This job extracts unbilled usage data and makes it 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 is a scheduled job and run daily.

For more information on jobs, see the CMP 8.1 Batch Jobs and 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 Guide. Alternatively, in the Administration ConsoleClosed An operations web console that allows batch jobs to be scheduled, run manually and monitored. The console also provides for viewing and modification of business and user applicable system configuration., navigate to Daily Operations > Jobs. Click any job in the Jobs List for more details. For more information on extracts, see the CMP 8.1 Extracts Guide.

The following daemons are associated with Data Warehouse:

Type Category Activity Details
Transmission Data Warehouse To DataWarehouse Daemon that is responsible for transferring the data warehouse extract to a specified location. This daemon handles the output for all Analytics jobs.

 

For more information on daemons, in the Administration Console, navigate to Daily Operations > Daemons. Click any daemonClosed A computer program that runs as a background process, rather than being under the control of an interactive user. in the Daemons Listfor more details.

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

Stage Category Name Type Description
Extract Prepaid Analytics 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.
Extract Postpaid Analytics 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.
Batch Statement Analytics 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.
Extract Statement Analytics 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.

 

For more information on probes, in the Administration Console, navigate to Daily Operations > Probes. Click any probeClosed In the Administration Console architecture, a mechanism which allows for the execution of predefined queries and for the comparison of the results of those queries against pre-configured targets. Probes can be reviewed and managed via the Admin Console. in the Probes List for more details.