- Home
- Company
- Services
- Business Applications
- Mobility
- Big Data
- Analytics
- Customers
- Contact
With the new version of MS SQL, from MS SQL 2012 and on, any SAP customer can benefit from a huge data compression of its database (85%) while improving its SAP performance and make its SAP BW queries 3 to 5 time faster (average) by activating the new column store indexes for SAP BW infocubes. Those techniques have been used in productive systens by Microsoft and organization all over the world. ELSOP has upgrade some of its customer to MS SQL 2012 resulting a more than 85 % SAP BW database reduction and 4 times quicker SAP Bex/BO queries. All of this without any additional license for the customer, within a month, with less than 4 hours down time and in a completelly transparent way for the end user.
Data in tables and indexes can be compressed, in addition to data at the row and page levels. Row-level compression reduces database size without additional resource consumption. Page-level compression, which is now a default compression type in SAP, reduces the size of a typical SAP ERP database by up to a factor of four, helping to improve overall response time and reduce storage costs in a dramatic way. According to SAP, applying row compression on an SAP ERP Unicode system on SQL Server resulted in approximately 50 percent space savings and approximately 75 percent space savings when using page compression.
ELSOP has achive a comression from 1,5 TB to 242 GB in one of its Customer's SAP BW system.
SQL Server 2012 introduced an additional storage format for data. Besides the normal row-oriented store, there is a column-oriented store as well (like in SAP HANA). In order to make it as transparent as possible, the new column store got exposed to the Database Administrators and Applications as a new index type: non-clustered column-store index.
A column-oriented store is optimized for aggregating mass data. A row-oriented store can be used optimal when accessing just a single row. In SQL Server 2012, the column-oriented store is build side by side with the row-oriented store. SQL Server Query Optimizer can decide at compilation time of a query which store to use best.
SQL Server 2012 Column-store support has been integrated into SAP BW for the releases 7.00, 7.01, 7.02, 7.11, 7.30 and newer.
See SAP note 1651862 for details.
A column-store index has many benefits: The administration of SAP BW is much easier, since you do not need to maintain any BW aggregates any more. The disk space usage is much smaller when using column-store indexes and the BW query performance is much better.
We have seen significantly increased BW query performance when using a column-store index in our test lab. There was a wide spread of performance increase, dependent on the data and type of query. Some queries were up to 50 times faster, while others did hardly benefit from the column-store index. The majority of the BW queries we tested ran about 3 to 5 times faster. However, we expect even better results with real customer data. The data in our test cubes was often artificially created and did not have any relation between the different characteristics, which prevented optimal compression and performance.
The fact tables on SAP BW cubes have one database index per dimension. All these indexes are dropped, once we move the data into the column-oriented store by creating a column-store index. Dependent on the number of dimensions you save a lot of disk space when using a column-store index. We have seen space savings of 50% and more, even when comparing with fully PAGE compressed fact tables.
When defining a column-store index in SAP BW for a cube, all aggregates are deactivated. The definition of the aggregates still exists in SAP BW. However, the database tables for the aggregates are dropped. This results in further space savings and less administration efforts when using a column-store index
SAP NetWeaver BW customers who perform daily loads can benefit from the increase in table partitions from 1,000 to 15,000.
Tuesday, 08 March 2016 16:11
ELSOP has successfully completed the Contract Management project for Nea Odos Inc.
Monday, 16 February 2015 11:31
ELSOP's Mobility Department implemented SAP Fiori and customized Purchasing Workflow and Purchase Approval apps for Chipita, one of the largest Food Suppliers in Greece. The company has presence in 65 countries with 18 production plants in 10 countries. SAP Fiori was deployed for Bulgaria and Greece as first Golive. The Solution was deploeyd within 3 weeks.
Friday, 29 August 2014 10:59
ELSOP Consulting Group undertakes the Roll out implementation of SAP ERP for the Greek Entity of Playmobil in collaboration with Lufthansa Systems.
Wednesday, 14 May 2014 14:13
SAP AG today announced that SAP Fiori user experience (UX) and SAP Screen Personas software will now be included within underlying licenses of SAP software. For existing customers, SAP will provide a software credit redeemable against future software sales.
Friday, 05 June 2015 10:59
ELSOP Consulting Group undertakes the implementation of Qlikview for PAPADOPOULOU S.A.
Wednesday, 01 October 2014 10:59
ELSOP achieved a BW database compression from 3,5 TB to 340 GB! just by upgrading SQL to 2012 version in PAPADOPOULOU company BW system. Their queries performance is 4-5 times quicker! without any new aggregate or so.
This was done in 2 weeks in the production system and completelly transparent to the end users.
Wednesday, 14 May 2014 14:13
Take advantage of the new offer from ELSOP! Change radically your everyday enterprise reality with SAP Fiori. No more complicated processes and delays. Do everything via your mobile device, easily and quickly and feel SAP at the tips of your fingers. ELSOP brings you all of the benefits Fiori has to offer at a really affordable fixed price! Our offer includes installation of the proper software on your environment as well as implementation of 3 Fiori applications of your choice, only for 10.000 EUR.
Read more about our offer here.
Saturday, 26 April 2014 14:14
According Law POL 1022/31.01.2014 the Sales & Purchases Reconciliation Report (MYF) should be submitted monthly instead of yearly. The due date for submitting the data is 02.06.2014. SAP has issued 3 notes, as part of Hellenization package, with new solution for MYF reporting, without affecting the old programs.
New solution contains new set of reports and other objects, such as:
Wednesday, 09 April 2014 08:14
ELSOP’ s mobility department completed successfully the development of the “Sales Calendar” project on behalf of the Hellenic Petroleum Group. “Sales Calendar” is a mobile application designed for tablet devices using the Android operating system in conjuction with SAP's Sybase Unwired Platform. In the scope of the business on-the-go practices that the contemporary enterprise needs demand, the user, a Sales Executive or a Sales Head, can schedule or review the working program of every week with a few clicks. A Sales Head has extended privileges including inspection of the programs committed by the Sales Executives he/she is responsible for.
Tuesday, 12 November 2013 10:25
According to Law POL 1022/31.1.2014, report MYF should be provided to the Greek Authorities on a monthly basis with a specifc XML format.
For this SAP has already announced through SAP Note 1972510 - GR: new MYF montly format, XML output, for ECC 6.0 and Hellenization C-CEE 110_600 or subsequent, the required actions .
Tuesday, 12 November 2013 10:25
As you already know, the publishing in the Government Gazette (FEK 3513, 13.12.2012) and the ministerial decision POL 1221/2012, for the Upgrade of the support software for Special Secure Fiscal Device for Record Signing (SSFDRS) (Tax Devices) determine the necessary mode changes for them.
SAP has already announced through SAP Note 1825984, for ECC 6.0 and Hellenization C-CEE 110_600 or subsequent, the required actions according to the type of the device.
Wednesday, 25 September 2013 12:44
Type A tax device, models Casio FP500-600 with signature processor and signature processor 2. Conversion to pdf and automatic delivery of documents via e-mail as attached files with the corresponding name_a.txt and name_b.txt. Adaption to POL 1221 via selection functions to generate the e.txt file. The tax-devices were installed succesfully on hardware with 64-bit operating systems and restricted-user policies enforced. The installation is ready for sending the e.txt to the General Secretariat of Information Systems, that will apply from 01/01/2014.
Wednesday, 25 September 2013 09:44
ELSOP's certified application Mobile Basis for SAP is now available to download via the official SAP Store. You can download it here.
Friday, 13 September 2013 12:47
Type A tax device, models Casio FP500-600 and Proline 650-750 with signature processor and signature processor 2. Conversion to pdf and automatic delivery of documents via e-mail as attached files with the corresponding name_a.txt and name_b.txt. Customization and adaption to POL 1221 via selection functions to generate the e.txt file. The installation is ready for sending the e.txt to the General Secretariat of Information Systems, that will apply from 01/01/2014.
Thursday, 12 September 2013 14:47
Type A tax device, models Casio FP500-600 and Proline 650-750 with signature processor and signature processor 2. Conversion to pdf and automatic delivery of documents via e-mail as attached files with the corresponding name_a.txt and name_b.txt files.Customization and adaption to POL 1221 via selection functions to generate the e.txt file. The installation is ready for sending the e.txt to the General Secretariat of Information Systems, that will apply from 01/01/2014.
Thursday, 08 August 2013 14:33
ELSOP's certified application Mobile Basis for SAP is available via the Google Play store.
Monday, 05 August 2013 12:02
ELSOP is the first SAP Partner in Greece and one of the few in the world that earns a certification for a custom made mobile solution. Mobile Basis for SAP is designed to offer remote administration services for any SAP system. The application is available for purchase in the official SAP Application Store and a demo version for Android users can be downloaded from Google Play.
Monday, 15 July 2013 13:31
ELSOP's Mobility Department implemented a pilot Field Service application for Natural Gas Company, the only natural gas distributor and trader in the area of Attica, Greece. This Field Service application is hybrid, crossplatform and was developed on SAP Mobile Platform (SUP HWC).
Friday, 12 July 2013 09:31
ELSOP's Mobility Department implemented the Sales Distribution Credit Release application for Hellenic Petroleum, the largest oil supply, refining and trading company in Greece. SD Credit Released is a hybrid, crossplatform application developed on SAP Mobile Platform (SUP HWC).
Thursday, 11 July 2013 10:38
ELSOP's Mobility Department implemented the Sales Distribution Credit Release application for Hellenic Fuels, a leading company in retail fuels business in Greece. SD Credit Released is a hybrid, crossplatform application developed on SAP Mobile Platform (SUP HWC).
Wednesday, 10 July 2013 11:31
ELSOP's Mobility Department implemented the Sales Distribution Credit Release application for EKO, one of the largest energy groups in South East Europe and a leading Greek company in the oil sector. SD Credit Released is a hybrid, crossplatform application developed on SAP Mobile Platform (SUP HWC).
Thursday, 09 May 2013 11:07
ELSOP Consulting Group completed succesfully the SAP roll-out project for Total Hellas. Total is a French multinational integrated oil and gas company and one of the six "Supermajor" oil companies in the world.
Wednesday, 09 January 2013 10:23
ELSOP Consulting Group completed succesfully the SAP roll-out project for Italcementi Group. Italcementi Group is a multinational company, one of the leaders in production of cement, ready-mix concrete and construction aggregates.
Wednesday, 14 November 2012 10:47
ELSOP Consulting Group installed its custom made Mobile Basis application on Papadopoulos, one of the largest greek companies, with many years of presence in the biscuit industry and bread substitute segment. Mobile Basis by ELSOP is a SUP native Android application purposed for SAP system administration.
Wednesday, 12 September 2012 15:12
Type A tax devices , models Casio FP500-600 and Proline 650-750 with signature processor and signature processor 2. Conversion to pdf and automatic delivery of documents via e-mail as attached files with the corresponding name_a.txt and name_b.txt files.
Monday, 12 September 2011 14:23
Type B tax devices, model: DM100, DM1000.
Automatic conversion and storage through the SAP of the printed documents which have passed from the tax device as PDFs. Ability to search documents in PDF format from the SAP system.
Connect With Us |
|
 |
 |
© 2024 ELSOP Consulting Group