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
Data from pharmacies
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
Archive> p
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