The company "Auchan Russia" may open three hypermarkets under the brand "Our rainbow" in the capital of Mordovia, the city of Saransk, the press service of the head of the republic reports ...

On Monday, the head of Mordovia, Vladimir Volkov, and the president of Auchan Russia, Jean-Pierre Germain, discussed the prospects for the development of retail trade in the republic ...

Society | 2015-08-04 20:26:00

"Auchan" demands to refute information about horse meat in minced pork

The Auchan retailer, whose Rosselkhoznadzor found horse meat and other components in the minced pork during a regular check, will demand a refutation from the department, said Maria Kurnosova, director of external communications for Auchan Russia ...

On Tuesday, the Rosselkhoznadzor, during an inspection of the Auchan trading network, found impurities of chicken, horse and cattle meat in the minced pork and, based on the materials of this inspection, will send the materials to the court ...

Economy | 2015-08-11 20:51:00

"Auchan" suspended the work of meat shops in four stores for a day

"Auchan" after inspections of the Rosselkhoznadzor decided to suspend for a day, until 14 ...

“Given the importance of ensuring the sanitary safety of products, and despite the fact that the test reports have not yet been received, Auchan decided to suspend today at 14 ...

Incidents | 2015-08-04 13:41:00

Auchan launched an internal investigation due to inspections of the Rosselkhoznadzor

The Auchan retailer, in whose stores in recent weeks Rosselkhoznadzor specialists have identified several violations of the storage and production of goods, decided to conduct its own internal investigations, said Maria Kurnosova, Director of External Communications of Auchan Russia ...

On Tuesday, the Rosselkhoznadzor, during an inspection of the Auchan trading network, found impurities of chicken, horse and cattle meat in minced pork and ...

Society | 2015-08-31 13:28:00

Rosselkhoznadzor found dangerous bacteria in the products of Auchan and Selgros

Rosselkhoznadzor, in the course of unscheduled inspections of stores of three grocery chains "Auchan", Selgros and "Olivier", found E. coli, listeria and salmonella in semi-finished meat products ...

Since the end of July, the Rosselkhoznadzor has been reporting violations of the Auchan retailer ...

Society | 2015-09-29 16:07:00

Rospotrebnadzor: a claim against "Auchan" filed following the results of scheduled inspections

The Moscow Rospotrebnadzor filed a lawsuit against Auchan after scheduled inspections, the press service of the federal department said, while not making predictions about a possible preventive measure ...

Earlier, the Moscow department of Rospotrebnadzor filed two applications with the Moscow Arbitration Court demanding that the large retailer Auchan be brought to administrative responsibility ...

Incidents | 2016-02-18 22:34:00

Twelve Auchan stores checked after bomb calls

The check after reports of allegedly planted bombs has already touched 12 stores of the Auchan retail chain, 11 of them are being evacuated, a source in the capital's emergency services said ...

"In total, 12 Auchan stores are being checked, at 11 there was an evacuation, in four stores the threat of an explosion has not been confirmed," the agency's interlocutor said ...

Society | 2015-09-29 12:09:00

Rospotrebnadzor sues Auchan for violation of technical regulations

The Moscow Department of Rospotrebnadzor has filed two applications with the Moscow Arbitration Court demanding that the large retailer Auchan be brought to administrative responsibility, it follows from the information on the court's website ...

In this statement, Rospotrebnadzor demands to bring Auchan to administrative responsibility under Part 2 of Article 14 ...

Society | 2015-08-19 16:19:00

Rospotrebnadzor: inspection of Auchan stores is not related to politics

The inspection of the stores of the Auchan chain is outside the political context and was planned back in 2014, the press service of Rospotrebnadzor said ...

Earlier, the head of Rospotrebnadzor Anna Popova said that the department has been conducting a full scheduled inspection of the Auchan chain stores in Moscow since mid-June ...

Incidents | 2015-08-19 14:54:00

"Auchan" challenged the prosecution by the Rosselkhoznadzor in court

On September 17, the Moscow Arbitration Court will consider the application of the large retailer Auchan, in which it demands to declare illegal and cancel the Rosselkhoznadzor ruling on bringing the applicant to administrative responsibility, the court said on Wednesday ...

43 of the Code of Administrative Offenses of the Russian Federation and further transfer to the court in order to suspend the activities of LLC "Auchan" in terms of processing and release of semi-finished products ...

Economy | 2015-07-30 18:37:00

Rosselkhoznadzor: "Auchan" artificially extends the shelf life of meat

"Auchan" artificially extends the shelf life of chilled meat, manipulating the labeling during its storage, processing and sale, which poses a threat to consumers, the Rosselkhoznadzor said in a statement ...

"It has been established that the Auchan LLC hypermarket chain extends the shelf life of chilled meat raw materials in the process of storage, processing and sale, which may pose a threat to human life and health", -...

Economy | 2015-08-12 17:22:00

Authorities: "Auchan" is able to eliminate the identified violations

The retail network "Auchan", according to the leadership of the Moscow region, is capable of eliminating the identified violations, it is premature to discuss an alternative player to "Auchan" in the retail market, said the Minister of Consumer Market and Services of the region Vladimir Posazhennikov on Wednesday ...

Auchan Extranet module, what is it? What is it for and how to get access to it? How is the reporting formed and what is the general algorithm of the system's operation? Is it possible to contact support regarding the operation of the Extranet system?

Let's preliminarily tell a couple of lines about the Auchan company itself. It is one of the largest players on the Russian trade market, representing one of the international branches in our country. The retail network is represented in most Russian cities, with a total of more than 300 open stores.

The article will be devoted to the Extranet portal.

What is the Auchan Extranet module for?

The module is intended for suppliers, partners of the Auchan company, who cooperate with it in different directions, but first of all, the supply of commercial products.

Features of the module that allow you to receive information about:

• Payments, payment terminals, transactions made to a trading company, suppliers and other partners.
• Auchan's debt to its partners.
• Problematic documents, unpaid payments, etc.
• Debt to Auchan on your part.
• About non-refundable documents and other reports.

We can say that this is a secretary who allows you to control joint activities and get a complete and balanced picture.

With the help of the Extranet, you will be able to generate and prepare reports of different types.

The system works through the official website of Auchan, which is convenient for both the supplier and the network representatives.

How to access the module

A personal account is provided through the website of the Auchan trading network, available at the following link -.

To gain access to the system, you must first register by sending a request to the address - [email protected].

Algorithm for generating reports

Reliable information about the rules for generating reports is available in the Personal Account for each registered person, you just need to use the registration data and enter the profile.

Suppliers and other partners can choose the format of help, reports and other documents that is convenient and suitable for them through the Extranet.

Extranet module technical support

In addition to the general help desk, Auchan has a separate line that deals with the processing of requests related exclusively to work with the Extranet module.

To obtain reliable help and answers to questions, the user can contact the following email address - [email protected].

The response time to the appeal is not more than a day.

This document was compiled at the request of the Auchan Directorate in order to give a general idea of ​​the structure of the documentation for the Auchan business intelligence system developed by Navitek. The document can be used as a reference for easy navigation through the documentation.

The document includes the following chapters:

1. General information about the system. Purpose and purpose
2. The history of the development of the system. Main steps
3. Current system usage statistics

General information about the system.

In today's world, data is a key asset for a company. Company activity data is generated by various participants in the production activity. The analysis and use of the accumulated data is of exceptional value.

The BI system of the Auchan company is designed to provide users with access to analytics on the accumulated data in order to make decisions. The system consists of kernel and application components. The system core components are designed to solve the following tasks

1. Collection of structured and unstructured data on schedule and online from various heterogeneous information systems
2. Long-term storage of accumulated data in storage and data marts
3. Data transformation according to flexible rules based on business requirements
4. Organization of required interfaces (API) for visual data visualization applications
5. Ensuring secure access of users and systems to storages and data marts

BI also includes data access applications. Applications use the components of the core of the BI system to organize safe, fast and reliable access for end users to the accumulated array of information through the standard interfaces of the system. Applications are a window through which users look at data and analytics. All applications that work with the BI system are divided into two broad categories.

1. Standard applications developed by our company
2. Third party applications developed by external companies

Figure 1. General diagram of the components of the BI Russia system

The history of the development of the system. Main steps

The history of the development of the business intelligence system of the Auchan company has 10 years and includes several periods

1. The period is 2006-2008. The beginning of the development of the system. Collecting sales data. Implementation in stores, cost centers, Marketing BI applications Performance and Publisher and basic reports
2. Period 2009-2011. Formation of the system. Collecting advanced data on commerce processes for stores and cost centers, creating Needs and Extranet applications. Establishing data quality control services and processes
3. Period 2012-2014. Improving the system. Implementation of a modern virtual platform to ensure the required availability indicators in connection with the growth of the company. Implementation of master data control processes (BPM Workflow) based on the modern Adobe Livecycle BPM solution. Creation of the international BI EE solution and the beginning of its implementation in Ukraine and Romania
4. The period is 2015-2016. Further expansion of data volumes due to indicators of commerce, HR and finance. Implementation of a modern system for calculating indicators based on business rules - the Margin Management / Rupture application. Implementation of the perfect Oracle Exadata analytics platform. The beginning of the implementation of the Big Data concept - streaming data on sales and commerce indicators.

It is important to note that the development of the BI system in the initial periods of 2006-2012 was largely determined by the balance of opportunities for purchasing licensed technologies and requirements for integrating systems and users. Thus, before the conclusion of the agreement on the unlimited use of BI Oracle technologies in 2012, Auchan relied heavily on applications and modules created by our company in order to reduce the cost of system ownership. A list of BI software components and vendors of this software is given in the table at the end of this document.

System usage statistics

Current system usage statistics are available on the performance app's web portal. Below are the figures in comparison with previous years in the context of the number of users and requests to the analytics system.

Report requests for the last 3 years.

Year	Number of reports total	Number of Extranet Reports
2014	480005	149813
2015	715020	264210
2016	999913	393798

Number of master data management processes in the last 3 years

Year	Number of processes
2014	43692
2015	72396
2016	169863

Number of BI users

Year	Publisher	Performance
2014	3618	4335
2015	4080	4826
2016	4550	5328

System structure. The main components of the system core

As mentioned above, the main components of a BI system are the core of the system and applications. The core of the BI system provides a number of basic services for applications. Below is a brief overview of the components of the kernel of the system, as well as links to detailed documentation for each component. The core of the BI system consists of:

Figure 2: System Core Components

The composition of the core subsystems of BI Auchan-Russia can be studied

Administration, planning and execution subsystems.

This subsystem is responsible for planning and completing all tasks in the BI system. Including tasks of data processing, preparation of reports, tasks of unloading data. The subsystem has a central repository, is integrated with the visual admin console, and also provides an advanced API.

Detailed information on the module can be obtained

The registry of administrative tasks can be obtained from

Subsystems of authentication, authorization and audit

This subsystem is responsible for authenticating users in central directories and issuing authorization to perform tasks and access system functions, as well as a complete audit of user actions. The subsystem has a central repository, is integrated with the visual admin console, and also provides an advanced API

1. Description of the security model can be downloaded
2. The architecture of the solution can be viewed

Data storage and aggregation subsystems

This subsystem is an instance of Oracle's database. The Oracle database was chosen by Auchan as a standard and is used for structuring and storing information. A separate Oracle database module is used to build aggregate data marts. The subsystem provides access to the stored information through the standard Oracle OCI API

1. Instructions for using the Oracle database can be downloaded
2. Instructions for using the Oracle aggregation module can be downloaded
3. Information on setting up and using OLAP in the Auchan company can be viewed
4. The register of data aggregation operations can be viewed

Data loading and transformation subsystems

This subsystem is a complex environment consisting of modules serving to perform data processing tasks. The subsystem meets all modern requirements and allows for batch and online (online) data integration and transformation

The BI system is an open system, therefore it is possible to use any data transformation modules of any vendor in it. In order to reduce the cost and increase the reliability, transformation modules of only 4 types are currently used. Each module of the system, in turn, have environments for process design, execution and configuration of transformation processes.

Below is a list of module types and their card description.

1. Oracle Warehouse Builder is the 2000 generation Oracle Warehouse Batch Integration Module. The documentation for the module can be obtained from
2. Oracle Data Integrator is a 2010 and older Oracle Batch Integration Module. The documentation for the module can be obtained from
3. Oracle Golden Gate Module - Oracle 2010 and older operational (online) integration module. The documentation for the module can be obtained from
4. JAPI module - a package integration module from Navitek. The documentation for the module can be obtained from
5. A registry of all data integration tasks is available
6. Descriptions of SOA / MFT modules and their API can be viewed

Subsystem of modeling and indicator catalog

This subsystem is fairly new in the BI system. The subsystem solves the problem of building a federated catalog of indicators, as well as providing a standard API for Oracle reporting tools such as Oracle Visual Analyzer and Oracle Dashboards. The indicator catalog is available in the subsystem visually. The subsystem appeared recently due to the high cost of the license for this component. It was only thanks to the conclusion of the ULA agreement that it became possible to simulate the indicator catalogs in this system.

1. Detailed documentation on the subsystem can be read
2. The Oracle documentation for the Oracle BIEE and Oracle VA product can be read and

System structure. Brief description of applications

Performance app

BI Performance app is designed specifically for stores. Available using browsers Chrome / Internet Explorer. It provides users with a fast, easy-to-use interface to view key indicators for Sales, Stocks, Margin, Loss, Write-off and Ruptures. The application allows you to group analytics by different periods, compare product groups and stores

Publisher app

BI Publisher was designed to provide complex reports with many parameters. Available using browsers Chrome / Internet Explorer. Initially, it was used only by qualified users, but then the circle of users increased. The application allows you to actually generate any report in any format on schedule or immediately. Supports complex forms of parameters. Provides access and data access control. Today, the system has created and uses more than 200 different reports.

Application documentation can be downloaded

Workflow app

The Workflow application is designed to provide transparency for key business processes of master data management. It allowed:

• Define and measure KPIs for master data management processes;
• Establish a correspondence between the KPI and the business rules of the company;
• Provide analytics regarding the business activity of the company's employees;
• In combination with BI, get the necessary analytics when making a decision;
• Speed ​​up the processing time of processes;
• Eliminate paperwork when interacting with suppliers.

At the moment, all processes of working with articles and tariffs (purchase prices) are automated, namely:

1. Changes in tariffs;
2. Creation of articles;
3. Rotation of articles;
4. Closing articles;
5. Changing the supplier of articles;
6. Reactivation of articles;
7. Modification of articles.

A process for reviewing applications from potential suppliers is currently being implemented.

Instructions and presentations for users can be viewed

Process diagrams can be viewed

Workflow documentation can be viewed

Extranet Application

The BI Extranet application was created specifically to provide secure access to data for Auchan's counterparties. Including banks, factors and suppliers use it in order to access analytics on mutual settlements. The application provides a counterparty's office, is available via the Internet and allows you to generate reports of any complexity both in batch and online. The capabilities of the visual interface of the Adobe Flex environment allow you to generate any visualization. In the application today, it is possible to install more than 26 different reports with financial and commercial indicators. Security settings allow you to control access to data and reports, manage subscriptions, audit user actions

Application documentation can be downloaded and

Video tutorials available

Cockpit app

The BI Cockpit application is a new application created after the merger of Auchan-Retail with the aim of analyzing data on the results of the consolidated company. The application forms a federated catalog of Auchan-Retail sales indicators, receives data in streaming mode from cash register systems and provides analytics on any mobile device and work computer via the Internet. For security purposes, the BI Russia authentication and authorization environment is used. Full connection audit is in progress

System architecture available

Margin Rules Management Application

BI Margin Management Application is an innovative application for analyzing and solving problems with the management of margins and sales prices. The application contains the configuration according to 12 key rules of the wide discount policy and allows the management of the company, the store and the segment manager to see and control the situation in real time according to the compliance of the established margin with all the pricing rules of the Auchan Retail company. It is important to note that the configuration of the rules can be performed by key users based on the wide catalog of attributes from BI.

Application documentation can be downloaded

System architecture available

Goods Components Control App

The MINTEK application was created for the CPC department in order to collect information and control inflation of composite products. In-app analytics are available in the IPON / PPP BI application and are used in negotiations with suppliers to validate claims for price increases for composite products

Application documentation can be downloaded

System architecture available

Functional task available

Rupture Management Application

The rupture analysis application was created for the company's stores in order to collect the classification and analyze the causes of the occurrence of events of the absence of goods on the shelves. The application provides a convenient interface for the store manager and segment manager and allows you to track the dynamics of the situation for missing goods on a daily basis, both upon scanning empty shelves by employees, and by analyzing other events, for example, the absence of goods on stock (Hidden rupture)

Application documentation can be downloaded

Functional task available

The architecture of the application can be viewed

PPP (Supplier Performance) application

The PPP application is an analytical system for tracking supplier productivity. It contains over 100 metrics and is tightly integrated with the existing repository and Qlick View platform. Analytical online reporting is based on Oracle Business Intelligence Enterpise Edition.

The system is deployed in Russia, Ukraine, Romania and Hungary.

Application documentation can be downloaded

The architecture of the application can be viewed

List of core components of BI systems Russia

		Name	Description
			Oracle database. Basis for storage and data aggregation subsystem
			Oracle database option. The basis for the data aggregation subsystem
		Oracle Partitioning	Oracle database option. Basis for the storage subsystem
		Oracle Warehouse Buider	Oracle database option. A 2000-generation batch integration and data transformation environment. The basis of the batch loading and transformation subsystem
		Oracle Data Integrator	2010 generation batch integration and data transformation environment. The basis of the batch loading and transformation subsystem
		Oracle Golden Gate	An environment for online integration and data transformation of the 2015 generation. The basis of the subsystem of operational loading and transformation
		Oracle BI Server / Suite	An environment for building a catalog of indicators with the ability to federate systems. The basis of the modeling subsystem and the indicator catalog
			Heterogeneous batch data integration module. Designed to reduce licensing burden and create an efficient batch integration environment. The basis of the batch loading and transformation subsystem
		Intelli Reports Scheduler / Processor	Planning and execution module. Serves for scheduling all tasks in the system. Has advanced scheduling, parameter passing and execution auditing tools with a user-friendly graphical interface. The basis of the batch loading and transformation subsystem
		Intelli Reports Security	Security management and system audit module. Allows you to use different methods and schemes of authentication / authorization. Has developed tools for auditing implementation. The basis of the planning and execution subsystem

Auchan is a French corporation whose online store is represented in Russia. This is one of the largest retail chains (grocery hypermarkets - inclusive). The name translated from fr. - "Upper Fields" (a quarter in the north of France, where the debut store was founded).

The year of foundation is considered to be 1961, and its founder is Gerard Mulier. 1996-99 distinctive in that the brand hypermarkets crossed the border - appeared in Poland, China, Luxembourg, Hungary. But the first in the Russian Federation - in 2002. In subsequent years, the turnover increased, and in November 2015 there was a transformation: from “Auchan Group” to Auchan Holding. The latter consists of 3 independent organizations for real estate, trade and banking services.

According to confirmed data, as of December 2010, the chain has 2,964 stores around the world. But on the official website of the Russian Ashan.ru. the buyer can buy almost everything: from groceries, appliances, household goods and ending with cosmetics, cabinet furniture, toys for children. To quickly place an order, see its status and more, it is better to fill out the registration form. It gives the right to enter the user's personal account.

Features of the Auchan personal account

A buyer who has completed a simple authorization procedure will be able to see in his personal account: the history of his orders, correct data (for example, delivery address, etc.), instantly find out if the goods have arrived at the specified place or are still on the road (if the status does not change for a long time, you need to call by calling the hotline).

The account makes it possible to monitor data from the sections "Orders", "History", "Addresses", "Data" at any time of the day and day of the week. Also, near the account login form, there is a signature window for the company's shares. This way you will be able to receive the most advantageous offers, therefore, significantly save on everyday and large purchases.

Contacts of the Auchan company

Hotline phone number: 8-800-700-5-800

E-mail address: [email protected]

Legal address of Auchan: 141014, Moscow region, Mytishchi district, Mytischi, Ostashkovskoe highway, 1