The concept behind Query & Analysis is really about empowering the Business User and Analyst to interact with data on the fly in a Self-service BI environment. There a few tools available from SAP BusinessObjects that fulfil this criteria. First of all, here’s a little background, so as to avoid any confusion around what the products are.
Historically, the original Query & Analysis and Reporting tool was simply called ‘BusinessObjects’. Back then if you were to ask someone what reporting tool they were working with they would just say ‘BusinessObjects’. That was the only tool, until sometime later the first version of Web Intelligence was released. After BusinessObjects acquired Crystal Decisions the ‘BusinessObjects’ reporting tool was renamed Desktop Intelligence, sometimes also known as Deski. Running alongside Desktop Intelligence the thin client tool Web Intelligence was being developed.
Over the years Web Intelligence has grown to become SAP BusinessObjects’ flagship tool that allowing non-technical users to create new queries, slice and dice, and then drill down through their data all via a web browser. The advancement in Web Intelligence means that Desktop Intelligence is now coming to its end of life.
A second tool available is Voyager. Voyager is an Online Analytical Processing Tool (OLAP). In the BI 4.0 release Voyager is superseded by SAP BusinessObjects Analysis edition for OLAP and SAP BusinessObjects Analysis edition for Microsoft Office. It should be used when analysis is required against large data sets.
We also find it useful to think of a third tool under the Query & Analysis category. That is the search tool named Explorer. The original name for Explorer was Polestar.
Biography – Russell Beech, Founder of BI System Builders & Cornerstone Solution®
I architect data solutions and superintend the solutions that I architect. I build teams that are usually a mix of full-time employees and sub-contractors. I ensure mentoring and knowledge transfer. The emergence of big data has opened the door to a rise in interest in predictive analytics aka machine learning. For me the technology changes have provided the opportunity to architect data solutions which combine my enterprise data warehousing experience with data lake concepts and to apply my knowledge of statistics to that data to deliver predictive analytics. To that end I’m putting work into understanding how the evolving technologies hook in to each other. I have a focused interest in learning about big data technologies such as Hadoop, Hive, GCP BigQuery and machine learning and their integration/virtualization with the enterprise data warehouse.
You can find me on LinkedIn here and subscribe to watch BI System Builders videos on our YouTube channel here.
Query as a Web Service is a wizard-based application that enables users to create custom web services for specific queries against a SAP Business Objects universe. Once they have been created the queries can be integrated with other applications or tools. The integration ensures that the SAP Business Objects universe becomes the central hub for delivering secure, trusted information wherever it is needed. For example, a Web Service Query on a SAP Business Objects universe can be used to feed data in to a Xcelsius dashboard. The wizard is a client based component that is simple to use enabling both application developers and business users to quickly create their own queries. After creating the query a URL is generated for the Web Service. The URL can then be added to other applications. The generated Web Service can be consumed by any web service-enabled application.