SAP Explorer has become one of the most useful tools in the Business Objects Toolkit, although sometimes we do not appreciate all its potential. If our data set has one or more geographical dimensions, like city, country, state.., we should use the geographical variable types for these dimensions. This kind of dimensions allow us to introduce map analytics in our Exploration Views, which is a plus. Below we will proceed to explain the needed steps in order to set up these dimensions and explain how to better use them. First of all, we need to log on SAP Explorer with an account with permission to "Manage Spaces".
Tips and tricks on HTLM5 Dashboard conversion for BI Mobile
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.
Running SAP BusinessObjects Explorer on top of SAP BW
Running SAP Explorer on top of BW This blog describes the only successfully tested way to run SAP Explorer on top of SAP Netweaver Business Warehouse (SAP BW) info-providers. This is not a straight forward configuration and it requires knowledge of Information Design Tool, Data Federator Administration Tool and SAP Logon application for SAP BW.
Handling Formula Errors in Web Intelligence
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.
What top BI and analytics trends and predictions in 2014 to watch out for?
Is your organization ready for “After Big Data”?
A recent article in the Harvard Business Review by Thomas Davenport, professor and fellow at MIT, caught my attention. Davenport refers to the beginnings of a new era: “After Big Data” in his article Analytics 3.0. While organizations built around massive data volumes — such as Facebook, LinkedIn, eBay, Amazon and others — may be ready to move to the next wave of analytics, the full spectrum of big data capabilities is yet to be realized in the traditional organizations we work with on a daily basis.
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.