Auchan extranet for legal entities. Personal account Аuchan (Auchan)

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

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 that information about horse meat in minced pork be refuted

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

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

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

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

After inspections by Rosselkhoznadzor, Auchan decided to suspend it 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 inspections

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

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

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

Rosselkhoznadzor found dangerous bacteria in Auchan and Selgros products

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

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

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

Rospotrebnadzor: a lawsuit was filed against Auchan based on the results of scheduled inspections

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

Previously, the Moscow department of Rospotrebnadzor filed a arbitration court Moscow, two statements demanding that the large retailer Auchan be brought to administrative responsibility...

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

Twelve Auchan stores are inspected after bomb calls

The check after reports of alleged bombs has already affected 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, 11 were evacuated, and in four stores the threat of an explosion has no longer been confirmed,” the agency’s interlocutor 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, as follows from the information on the court’s website...

In this statement, Rospotrebnadzor demands that Auchan be brought to administrative liability under Part 2 of Article 14...

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

Rospotrebnadzor: inspection of Auchan chain stores is not related to politics

The inspection of Auchan chain stores 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 Auchan chain stores in Moscow...

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

"Auchan" challenged in court the prosecution of Rosselkhoznadzor

On September 17, the Moscow Arbitration Court will consider the application of the large retailer Auchan, in which it demands to recognize as illegal and cancel the decision of Rosselkhoznadzor to bring the applicant to administrative responsibility, the court reported 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...

Economics | 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 labeling during its storage, processing and sale, which poses a threat to consumers, Rosselkhoznadzor said in a statement...

“It has been established that the Auchan LLC hypermarket chain extends the shelf life of chilled raw meat during its storage, processing and sale, which can pose a threat to human life and health,”...

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

Authorities: Auchan is able to eliminate identified violations

The Auchan retail chain, in the opinion of 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, the minister said consumer market and services of the region Vladimir Posazhennikov on Wednesday...

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 is translated from French. - “Haute 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 distinctive in that hypermarkets trademark crossed the border - appeared in Poland, China, Luxembourg, Hungary. But the first ones in Russian Federation– in 2002. In subsequent years, turnover increased, and in November 2015 a transformation took place: from the 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 purchase almost everything: from groceries, appliances, household goods to cosmetics, cabinet furniture, and 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, adjust data (for example, delivery address, etc.), instantly find out whether the goods have arrived at the specified location or are still on the way (if the status does not change for a long time, you need to call by phone hotline).

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

Auchan company contacts

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

Address email: [email protected]

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

This document was compiled at the request of the Auchan directorate in order to give a general idea of ​​the structure of 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. History of the development of the system. Main stages
3. Current system usage statistics

General information about the system.

In today's world, data is key asset companies. Data about company activities is generated by various participants production activities. The analysis and use of accumulated data is of exceptional value.

The Auchan BI system is designed to provide users with access to analytics based on accumulated data for the purpose of decision-making. 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. Transformation of data according to flexible customizable rules taking into account business requirements
4. Organizing the 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 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 view data and analytics. All applications that work with the BI system are divided into two large categories.

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

Figure 1. General diagram of BI system components Russia

History of the development of the system. Main Stages

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

1. Period 2006-2008. Beginning of system development. Sales data collection. Implementation of BI applications Performance and Publisher and basic reports in stores, COP, Marketing
2. Period 2009-2011. Formation of the system. Collection of advanced data on commerce processes for stores and public health centers, creation of Needs and Extranet applications. Establishing data quality services and processes
3. Period 2012-2014. System improvement. Implementation of a modern virtual platform to ensure the required accessibility indicators in connection with the company's growth. Implementation of master data control processes (BPM Workflow) based on the modern Adobe Livecycle BPM solution. 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 through indicators of commerce, HR and finance. Implementations modern system calculating indicators based on business rules - Margin Management / Rupture applications. Implementation of the advanced Oracle Exadata analytics platform. Beginning of 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 entering into an agreement on the unlimited use of Oracle BI technologies in 2012, Auchan largely used applications and modules created by our company in order to reduce the cost of system ownership. A list of BI software components and software vendors is provided in the table at the end of this document.

System usage statistics

Current system usage statistics are available on the performance application web portal. Below are figures compared to previous years in terms of the number of users and requests to the analytics system.

Requests for reports 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 over 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. Main components of the system core

As mentioned above, the main components of a BI system are the system core and applications. The BI system core provides a number of basic services for applications. Below is a brief overview of the system core components, 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 Auchan-Russia BI core subsystems 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 download tasks. The subsystem has a central repository, is integrated with a visual administrator console, and also provides an extended API.

Detailed information on the module can be obtained

A 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 system functions, as well as a full 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. The architecture of the solution can be viewed

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 for structuring and storing information. A separate Oracle database module is used to build aggregate data marts. The subsystem provides access to stored information through standard Oracle OCI APIs

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 that serve to perform data processing tasks. The subsystem answers everything modern requirements and allows you to perform batch and operational (online) integration and data transformation

BI system - open system, therefore it is possible to use any data transformation modules of arbitrary vendors. In order to reduce cost and increase reliability, today only 4 types of transformation modules are used. Each module of the system, in turn, has an environment for process design, execution and configuration of transformation processes.

Below is a list of module types and their brief descriptions

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

Subsystem for modeling and catalog of indicators

This subsystem is quite 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 visual form. The subsystem appeared recently due to the high cost of licensing this component. Only thanks to the conclusion of the ULA agreement it became possible to perform modeling of indicator catalogs in this system

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

System structure. Brief description applications

Performance app

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

Publisher Application

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

Application documentation can be downloaded

Workflow app

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

• Define and measure KPIs for master data management processes;
• Establish correspondence between KPIs and company business rules;
• Provide analytics regarding the business activities of company employees;
• In combination with BI receive necessary analytics when making a decision;
• Speed ​​up processing times;
• 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 items;
5. Change of article supplier;
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

Documentation on Workflow processes can be viewed

Extranet Application

The BI Extranet application was created specifically to provide secure access to data for Auchan counterparties. It is also used by factor banks and suppliers to access analytics on mutual settlements. The application provides a counterparty account, is accessible via the Internet and allows you to generate reports of any complexity, both in batch and online. The visual interface capabilities of the Adobe Flex environment allow you to generate any visualization. The application today allows you 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

Application documentation can be downloaded and

Video tutorials available

Cockpit app

The BI Cockpit application is a new application created after the Auchan-Retail merger for the purpose of analyzing data on the results of the activities of the consolidated company. The application creates 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 your work computer via the Internet. To ensure security, the BI Russia authentication and authorization environment is used. A full audit of connections is carried out

System architecture available

Margin Rules Management Application

BI Margin Management application is an innovative application for analyzing and solving problems with margin and sales price management. The application contains a configuration of 12 key rules wide discount policy and allows the management of the company, store and segment manager to see and control the situation in real time in terms of compliance of the established markup with all 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 MINTEC application was created for the Public Health Department to collect information and control inflation of composite products. Analytics from the application are available in the IPON / PPP BI application and are used in negotiations with suppliers to verify claims for price increases on composite products

Application documentation can be downloaded

System architecture available

Functional assignment available

Rupture Management App

The rupture analysis application was created for the company's stores in order to collect classification and analysis of the causes of events involving the absence of goods on the shelves. The application provides a convenient interface for the store manager and segment manager and allows you to monitor the dynamics of the situation regarding out-of-stock products on a daily basis, both by employees scanning empty shelves and by analyzing other events, for example, the absence of goods on 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 an analytical system for tracking supplier productivity. It contains over 100 metrics and is tightly integrated with the existing Qlick View repository and 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

You can see the application architecture

List of core components of BI systems Russia

		Name	Description
			Oracle Database. Basis for the data storage and aggregation subsystem
			Oracle DB option. Basis for the data aggregation subsystem
		Oracle Partitioning	Oracle DB option. Basis for the storage subsystem
		Oracle Warehouse Buyer	Oracle DB option. Generation 2000 batch integration and data transformation environment. Basis of the batch loading and transformation subsystem
		Oracle Data Integrator	Batch integration and data transformation environment of the 2010 generation. Basis of the batch loading and transformation subsystem
		Oracle Golden Gate	Environment for operational (online) integration and transformation of data of the 2015 generation. Basis of the operational loading and transformation subsystem
		Oracle BI Server/Suite	An environment for building a catalog of indicators with the ability to federate systems. Basis of the modeling subsystem and indicator catalog
			Module for heterogeneous batch data integration. Designed to reduce the licensing burden and create an efficient package integration environment. Basis of the batch loading and transformation subsystem
		Intelli Reports Scheduler/Processor	Planning and execution module. Serves to schedule all tasks in the system. It has developed tools for planning, passing parameters and auditing execution with a convenient graphical interface. Basis of the batch loading and transformation subsystem
		Intelli Reports Security	System security and audit management module. Allows you to use various authentication / authorization methods and schemes. Has developed implementation audit tools. The basis of the planning and execution subsystem

Auchan Extranet module, what is it? What is it for and how to access it? How is reporting generated and what is the general algorithm of the system? Can I contact support regarding the operation of the Extranet system?

First, let’s tell you a few lines about the Auchan company itself. This is one of the biggest players trading market Russia, representing one of the international branches in our country. The retail chain is represented in most Russian cities, with a total of more than 300 open stores.

The article will be devoted to the Extranet portal.

Why do you need the Auchan Extranet module?

The module is intended for suppliers and partners of the Auchan company who cooperate with it in various 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 carried out 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.
• About non-returnable documents and other reporting.

You could say this is a secretary that allows you to control joint activities and get a complete and balanced picture.

Using the Extranet, you can generate and prepare different types of reports.

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

How to access the module

Personal account is provided through the website of the Auchan retail chain, 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 the Personal Account for each registered person; you just need to use the registration data and log into your profile.

Suppliers and other partners can choose the format of help, reports and other documents that suits their needs via the Extranet.

Extranet module technical support

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

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

The response time to an appeal is no more than 24 hours.