""

Technical

, ,

Automating queries to SAP BusinessObjects System repository

, ,

The system CMS is an encrypted transactional repository where we can find the “current snapshot” of what is going on in BusinessObjects. Everything related to content, security and platform services can be found here, at a real time. Bringing this information into our reporting environment has always been key for administrators and power users and a line of investigation for years. Automating the capture of this data is the starting point for projects involving data quality reports, monitoring, alerts and corporate portals.

ETL with Microsoft SSIS: First steps and common issues

First impression when using Microsoft SQL Server Integration Services (SSIS), the developer’s first impression is the tool provides powerful features in addition is simple to use. Although this is true, there are some common errors that can make us waste our time. The purpose of this blog article is to cover some of these very common issues and save some time when starting to develop a solution with Microsoft SSIS.

,

Bringing homogeneity to a heterogeneous world - SAP HANA’s Smart Data Access

,

SAP HANA’s Smart Data Access bridges hot in-memory data with your traditional EDW During the second half of 2013, the database and technology team at SAP has been hard at work to deliver major enhancements for the SAP HANA database. With SP6 and SP7, released just a few weeks ago, we will highlight a new key capability for the in-memory database we believe will provide immense benefits.

, ,

SAP BW on SAP HANA: when and why?

, ,

In this article we will analyse the advantages of the SAP Business Warehouse (SAP BW) on SAP HANA solution in comparison with a Data Warehouse built directly on SAP HANA. We will also benchmark the performance of a SAP BW vs. SAP BW on HANA in a big data scenario. Most of us are aware of the last trends in BI/EPM market and where it is heading. SAP's mid and long term strategy shows that they are committed to convert SAP HANA in the core of many of their solutions including SAP ERP and SAP BW. SAP HANA can be used either as a database for other Custom Applications or as an Enterprise Corporate Datawarehouse (EDW) to take advantage of its big data and in-memory capabilities.

,

SAP BusinessObjects Web Intelligence report showing prompts with scientific notation

,

A while ago I was delivered a relatively easy task: create a SAP BusinessObjects Web Intelligence report that only needed one user entry in the prompt to calculate all the needed parameters for the query. After creating all the calculations and receiving the correct data in the Universe I proceeded to update the query of the Web Intelligence report, but encountered a problem. Due to unknown circumstances the report started showing the numbers and dates with scientific notation. When modifying my Web Intelligence report with the new values for the prompt, the SQL generated was showing the numbers in exponential form. "5.93e2" for example, as opposed to the actual value "593".

,

Configuring SAP Data Services 4.x with SAP ERP

,

In SAP® Data Services 3.2 some of the SAP system security standards were overlooked, allowing you to run any ABAP program in a production environment. As part of the improvements on SAP Data Services 4.x (SAP DS) this was fixed and it is now compliant with the SAP security standards. This means that for any ETL development including ABAP dataflows you will be forced to upload the ABAP code following the typical SAP system security process: upload to development (DEV), transport the changes to quality (QA) and, finally, transport the changes to production (PROD). In this article I would like to share with you some insights on how to get your new SAP DS 4.x environment ready using SAP systems.