My Data Archive

Export a flat database to Excel

Maxime LE MOIGNIC avatar
Written by Maxime LE MOIGNIC
Updated over a week ago

Module name

Trigram: MDA

v2011051528

Tutorial

Screenshot

Value

Export to Excel your sales value, sales volume, market share value and market share volume:

  • Query your database using all your dimensions

  • Possibility of going down to daily sales over 36 months

This module is for you if:

  • You want to download raw data, in order to feed it back into a BI tool or to carry out analysis work in Excel

  • Export raw data to transmit it to your global team

Data sources

Geographic territories

  • Metropolitan France data

  • Corsica

  • DROM-COM: Guadeloupe, Reunion, Martinique, Guyana

Market

  • No limitation on the size of the markets

  • Applicable to human medicinal products, veterinary medicinal products and non-medicinal products

Status

Subscription

Sales & Marketing Essential

Objects found in the sheet

  • Functional cartridge

  • Time buttons

  • Time selector

  • Object 'My Data Archve'

Indicators

Options

  • Day and week timing on option

  • International data on request

Exhaustive listing of Indicators & measures to date in My Data Archive:

N To

N To MS

N Vol

N Vol MS

Fields found in the All Products / MP4U version

AFIPA Category

AFIPA Segments

AFIPA SELFCARE

AFIPA Sub-Segments

ANS ATCVet Level1

ANS ATCVet Level2

ANS ATCVet Level3

ANS ATCVet Level4

ANS ATCVet Level5

ANS Code ATCVet

ANS_Condition Delivrance

ANS_Espece Destination

ANS_Nature

Brand

Company

EphMRA Code Level 1

EphMRA Code Level 2

EphMRA Code Level 3

EphMRA Code Level 4

Family

Freely Available

GTIN

IRI_Brand

IRI_Category

IRI_Company

IRI_Department

IRI_Ray

IRI_Sub-Ray

IRI_Sub-Type

IRI_Type

Line

Network

OHC Classification Level 1

OHC Classification Level 2

OHC Classification Level 3

OHC Classification Level 4

OHC Classification Level 5

OHC_DateInscriptionDTM

OHC_DateInscriptionSRC

OHC_Tech_BDDSource

OHC_Tech_DateHeureExtraction

OMS Code Level 1

OMS Code Level 2

OMS Code Level 3

OMS Code Level 4

OMS Code Level 5

Prescription Type

Product lining

Products

Segment

TECHNICAL CODE 2

THE_Active Substance

THE_Administration Way

THE_CIS Code

THE_Complement Form

THE_Container

THE_Container Name

THE_Container Number

THE_Contenance_Number

THE_Contenance_Unit

THE_Dosage Base Substance Unit

THE_Form

THE_Generic Type

THE_GSP Code

THE_List

THE_Market Authorization first approval

THE_Nature

THE_Packaging Unit Name

THE_Packaging Units Number

THE_Reimbursement

THE_Substance Dosage

THE_Substance Dosage Unit

THE_Substance Father

THE_Substance Label

THE_UCD

THE_UCD Code

THE_UCD Nature

THE_UCD Number

THE_Way

Versions


Current version:

  • Raising the drop-down selector Dimensions to the maximum of available space to facilitate selection

Old versions:

  • Fixed Total wording not displaying correctly (object)

  • Addition of the "Data Input" Warning within the traceability cartridge

  • Addition of 96 conditional display fields for the creation of All Products Apps in a standardized way.

  • Review of the positioning of objects according to the new grid for the implementation of the DOE (Internal Technical Improvement) cartridge

  • Complete review of the sheet in order to have an identical operating mode to the ODT sheet.

  • Change within the table to the caption of the "Product Code" field for "GTIN".

  • Added missing fields based on MP4U, as well as crossover with MPA.

  • Module accepted on version v2004271727 of the standard; no change compared to version v2004161511 of this module

    My Data Archive v2004161511

  • Changed the type of On / Off Prescription selector for Sales With Prescription / Sales Without Prescription (Now allows this selection to be taken into account within favorites)

Datablank target900"70=ank Datablank target9DgijftJtC40 DatablE200

  • Variability of the subscription within the cartridge. (New variable)

  • Modification of the formatting of the "Quarter 'time dimension within the table of the" My Data Archive "sheet in order to perform pivot tables in Excel following a data export.

  • Modification of the formatting of the "Month 'time dimension within the table of the" My Data Archive "sheet in order to perform pivot tables in Excel following a data export.

  • Variabilisation of standard selectors.

  • Correction of your "Success" link following the redesign of the site.

  • Setting up hierarchical fields qualifying the market within the table.

  • Added link to Success site (top right)

  • Replaced Period_MonthName_Short with Period_MonthName (Internal Technical Improvement).

  • Replacement of the sheet icon by a new one recreated.

Limitations

  • Absence of totals and sub-totals

Did this answer your question?