Auchan is a French corporation whose online store is represented in Russia. This is one of the largest retail chains(grocery hypermarkets - inclusive). The title is translated from French. - "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 are distinguished by the fact that hypermarkets trademark crossed the border - appeared in Poland, China, Luxembourg, Hungary. And here are the first Russian Federation- in 2002. In subsequent years, the turnover increased, and in November 2015 a transformation took place: from Auchan Group to Auchan Holding. The latter consists of 3 independent organizations real estate, trade and banking services.

According to confirmed data, as of December 2010, the network has 2964 stores worldwide. But on the official website of the Russian Ashan.ru. the buyer can purchase almost everything: from products, 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.

Auchan personal account features

The 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 arrived at specified place or is still on the road (if the status does not change for a long time, you need to call 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 box for the company's shares. So you can get the most advantageous offers, therefore, significantly save on everyday and large purchases.

Auchan Contacts

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

The address Email: [email protected]

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

The Auchan Russia company can open three hypermarkets under the Nasha Raduga brand in the capital of Mordovia, 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 development prospects retail 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, during the next inspection, found in minced pork horsemeat and other components will require a refutation from the department, said Maria Kurnosova, director of external communications at Auchan Russia...

On Tuesday Rosselkhoznadzor during the inspection trading network"Auchan" found impurities in minced pork meat of chicken, horse and large cattle and, based on the materials of this check, 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 by 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 test reports have not yet been received, Auchan has decided to suspend today at 14...

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

Auchan launched an internal investigation due to Rosselkhoznadzor checks

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

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

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

Rosselkhoznadzor found dangerous bacteria in Auchan and Selgros products

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

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

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

Rospotrebnadzor: a lawsuit against Auchan was 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, without 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 are checked after calls about bombs

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 emergency services of the capital said ...

"In total, 12 Auchan stores are being checked, 11 stores were evacuated, and the threat of an explosion has not been confirmed in four stores," the source said.

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

Rospotrebnadzor sued Auchan for violating technical regulations

The Moscow department of Rospotrebnadzor filed two applications with the Moscow Arbitration Court demanding that the large retailer Auchan be held administratively liable, follows from the information on the court's website ...

In this statement, Rospotrebnadzor demands that Auchan be held administratively liable under part 2 of Article 14...

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

Rospotrebnadzor: Checking Auchan stores is not related to politics

Checking Auchan stores is out of political context and was planned back in 2014, the press service of Rospotrebnadzor said...

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

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

"Auchan" challenged in court the prosecution by Rosselkhoznadzor

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 decision of the Rosselkhoznadzor to bring 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 Auchan LLC in terms of processing and production 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 by 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 network of hypermarkets of Auchan LLC extends the shelf life of chilled raw meat during its 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 trading network "Auchan", according to the leadership of the Moscow region, is able to eliminate the identified violations, it is premature to discuss an alternative to "Auchan" player in the retail market, said 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 reporting formed and what does the algorithm of the system work in general consist of? Can I contact support for extranet issues?

First, we will tell a couple of lines about the Auchan company itself. This is one of the largest players in the Russian trading market, representing one of the international branches in our country. The trading 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 Extranet Auchan module for?

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

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

• Payments, payment terminals, transactions made to trading company, suppliers and other partners.
• Auchan's debt to its partners.
• Problematic documents, payments not made, etc.
• Debt to Auchan on your part.
• On non-returnable documents and other reporting.

It can be said that this is such a secretary that allows you to control joint activities and get a complete and balanced picture.

With the help of the Extranet, you can generate and compile reports of various types.

The system works through the official website of Auchan, which is convenient for both the supplier and 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 corresponding request to the address - [email protected].

Algorithm for generating reports

Reliable information about the rules for generating reports is available in Personal account for each registered person, you only 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

Auchan, in addition to the general help desk, has a separate line that processes requests related exclusively to working with the Extranet module.

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

The response time to the appeal is no 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. Goals and purpose
2. The history of the development of the system. Main stages
3. Current system usage statistics

General information about the system.

IN modern world data is a key asset of a company. Company activity data is generated by various participants production activities. The analysis and use of accumulated data is of exceptional value.

Auchan's BI system is designed to provide users with access to analytics based on accumulated data in order to make decisions. The system consists of kernel components and applications. 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 transformations according to highly customizable rules, taking into account business requirements
4. Organization of required interfaces (APIs) for visual data visualization applications
5. Ensuring secure user and system access to data warehouses and data marts

The BI system also includes data access applications. Applications use the core components of the BI system to organize secure, fast and reliable access for end users to the accumulated array of information through standard system interfaces. Applications are the 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 system Russia

The history of the development of the system. Main stages

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

1. Period 2006-2008. The beginning of the development of the system. Collection of sales data. Implementation in stores, CPH, Marketing BI applications Performance and Publisher and basic reports
2. Period 2009-2011. The formation of the system. Collection of advanced data on commerce processes for stores and CSPs, creation of Needs and Extranet applications. Establish data quality services and processes
3. Period 2012-2014. System improvement. 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 modern solution Adobe Livecycle BPM. Creation of an international BI EE solution and the beginning of its implementation in Ukraine and Romania
4. Period 2015-2016. Further expansion of data volumes due to indicators of commerce, HR and finance. implementations modern system calculation of indicators based on business rules - Margin Management / Rupture applications. 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 to purchase licensed technologies and the requirements for integrating systems and users. Thus, prior to entering into the 2012 Oracle BI Unlimited Agreement, Auchan made extensive use of applications and modules created by our company in order to reduce the cost of ownership of the system. The list of BI software components, as well as the 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 web portal of the performance application. Below are the figures compared to previous years in terms of the number of users and requests to the analytics system.

Report requests for the last 3 years.

Year	Total number of reports	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 the BI system are the system core 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 core system, and links to detailed documentation for each component. The core of the BI system consists of:

Figure 2: System Core Components

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

Administration, planning and execution subsystems.

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

Detailed information on the module can be obtained

The register of administrative tasks can be obtained

Authentication, authorization and audit subsystems

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

1. Description of the security model can be downloaded
2. You can see the architecture of the solution

Data storage and aggregation subsystems

This subsystem is an instance of the Oracle database. The Oracle database was chosen by Auchan as a standard and is used to structure and store information. A separate Oracle database module is used to build aggregative data marts. The subsystem provides access to stored information through standard Oracle OCI APIs.

1. Oracle Database User Manual can be downloaded
2. Instructions for using the Oracle aggregation module can be downloaded
3. Information on setting up and using OLAP at Auchan 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 of employees for performing data processing tasks. The subsystem meets all modern requirements and allows you to perform batch and operational (online) integration and data transformation

The BI system is an open system, so it can use any data transformation modules of arbitrary vendors. In order to reduce cost and increase reliability, only 4 types of transformation modules are currently used. Each module of the system, in turn, has environments for designing processes, executing and configuring transformation processes.

Below is a list of module types and their short descriptions.

1. Oracle Warehouse Builder is Oracle's 2000 generation batch integration module. The documentation for the module is available
2. Oracle Data Integrator Module - Oracle 2010 and later batch integration module. The documentation for the module is available
3. Oracle Golden Gate module is Oracle 2010 and later online integration module. The documentation for the module is available
4. The JAPI module is a batch integration module from Navitek. The documentation for the module is available
5. A registry of all data integration tasks is available
6. Description 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 report design tools such as Oracle Visual Analyzer and Oracle Dashboards. The catalog of indicators is available in the subsystem in a visual form. The subsystem appeared recently due to the high cost of the license of this component. Only thanks to the conclusion of the ULA agreement, it became possible to simulate the catalog of indicators in this system

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

System structure. Brief description of applications

Application Performance

The BI Performance app is built specifically for stores. Available using Chrome browsers/internet explorer. It provides users with a fast, simple and user-friendly interface to view key indicators for Sales, Stocks, Margins, Losses, Write-offs and Ruptires. The application allows you to group analytics by different periods, compare product groups and stores

Application Publisher

BI Publisher was designed to produce complex reports with many options. Available using Chrome / Internet Explorer browsers. Initially, only qualified users used it, 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 parameter forms. Provides ID and data access control. Today, the system has created and uses more than 200 different reports

Application documentation can be downloaded

Workflow Application

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

• Define and measure KPIs for master data management processes;
• Establish a correspondence between KPI and 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 process processing time;
• Eliminate paperwork when interacting with suppliers.

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

1. Tariff changes;
2. Creation of articles;
3. Article rotation;
4. Closing articles;
5. Change supplier of articles;
6. Reactivation of articles;
7. Article modification.

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

Instructions and presentations for users can be viewed

Process diagrams can be seen

Workflow documentation can be viewed

Extranet app

The BI Extranet application was created specifically to provide secure access to data for Auchan's counterparties. Including banks, factors and suppliers use it to access analytics on mutual settlements. The application provides an account of the counterparty, 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, and audit user actions

The 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 in order to analyze data on the performance of the consolidated company. The application generates a federated catalog of Auchan-Retail sales indicators, receives data in streaming mode from POS systems and provides analytics on any mobile device and work computer via the Internet. To ensure security, the BI Russia authentication and authorization environment is used. Complete connection auditing

System architecture available

Margin Rules Management Application

The BI Margin Management application is an innovative application for analyzing and solving problems with margin management and selling prices. The application contains a configuration of 12 key rules wide discount policy and allows in real time the management of the company, the store and the segment manager to see and control the situation regarding 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 rules can be performed by key users based on a 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 department of the Public Health Center in order to collect information and control the inflation of compound products. Analytics from the application are available in the IPON / PPP BI application and are used in negotiations with suppliers to verify claims of price increases for composite products

Application documentation can be downloaded

System architecture available

Function 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 out-of-stock events. The application provides a convenient interface for the store manager and segment manager and allows you to track the dynamics of the situation with out-of-stock goods on a daily basis both by the fact that employees scan empty shelves, and by analyzing other events, for example, the absence of goods in stock (Hidden Rupture)

Application documentation can be downloaded

Functional task available

You can see the application architecture

PPP (Supplier Performance) application

The PPP application is analytical system to track 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 Enterprise Edition.

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

Application documentation can be downloaded

You can see the application architecture

List of core components of BI systems Russia

		Name	Description
			Oracle database. Basis for storage and data aggregation subsystem
			Oracle DB option. Basis for the data aggregation subsystem
		Oracle Partitioning	Oracle DB option. The basis for the storage subsystem
		Oracle Warehouse Builder	Oracle DB option. Generation 2000 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	Environment for operational (online) integration and transformation of data 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 possibility of system federation. The basis of the modeling subsystem and the catalog of indicators
			Module for heterogeneous batch data integration. Designed to reduce licensing burden and create efficient environment batch integration. 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. It has advanced tools for planning, passing parameters and auditing execution with a convenient graphical interface. The basis of the batch loading and transformation subsystem
		Intelli Reports Security	System security and audit management module. Allows you to use various methods and schemes of authentication / authorization. It has advanced performance auditing tools. The basis of the planning and execution subsystem