AUTOMATION OF BW QUERIES USING WEB BROWSER

In the fiercely increasing competition amongst corporations it has become mandatory to make quick and sound crucial business decisions based on analysis of business critical data. This is the point where SAP BW comes into play. BW Queries are the core of the reporting and analysis functionality in SAP BW. They provide a flexible and intuitive platform for data analysis that can be developed using the SAP Business Explorer (BEx) Query Designer.


AUTOMATION OF BW QUERIES – OVERVIEW


The Automation of queries in SAP BW is require where the data from BW is extracted by reporting analyst using the BW queries and send to business frequently on a regular basis for their analysis for example monthly or weekly.


Queries using web browser can be configured to be run:
Only Once: We can schedule the BW queries to be run on a specific day or time to be refreshed and sent to the email id of the recipients.
Scheduled Basis: We can schedule the BW queries to be run on a regular basis i.e. every day, specific day of a week or monthly basis.


This document outlines a set of guidelines to automate a query for a given scenario.


PROCEDURE TO AUTOMATE THE QUERIES USING WEB BROWSER:


Step 1: Log in SAP BW using the User Name and Password. Enter the RRMX as transaction code into the transaction window and hit the Enter. New Excel window will open with the additional BEx (Business Explorer) tool bar.

Step 2: Open a query which you want to automate through BEx and refresh the same.

Step 3: Launch the query in web browser.

Tool Button –> Launch in Web Browser –> Query (Default View)

When you click on the Query (Default View) it will pop up the message box asking the user name and password.

While you enter the user name and password it will populate the query in web browser.

Step 4: Modify the output structure of the query according to your requirement using the Variable screen at the left side of the window

Applying filters


If you want to apply any filter on the query then you can do that using filter icon against the characteristics. (Ex. If you have to produce the report for particular business unit only then click on the filter icon in front of Master Cost Centers it will pop up another window. Select the Business unit as per your requirement and click on transfer at the bottom left.)

If you want to set the properties of any characteristic then right click on that it will pop up window and select the properties. It will pop up another properties window that will allow you to change the properties of the characteristics.

Step 5: Information Broadcasting: When you are done with the formatting of the query click on the Information Broadcasting and mention the email addresses of the recipients whom the report needs to be sent then click on Create new Setting with the Wizard.

Step 6: Select on the check box as Zip File, it will create the Zip file for the report then click on continue at the bottom.

Step 7: Enter the subject line for the report and enter the E-mail content in the content window and continue at the bottom.

Step 8: Insert the technical name and description for the automated report.

Step 9: Schedule the report: Select the Create New Scheduling and Periodic All and enter the date which you want to schedule the report for and the schedule as weekly or monthly. Mention the date and time on which you want the report to be sent in front of Next Start at and click on the transfer below.

If you want to execute the report at the time of creation then click on the Execute button at the bottom otherwise close that. Now the report is scheduled for the period you mentioned this will automatically refresh the query in the same format you created on the scheduled date and E-mail this report to the recipients with the report attached in Zip format.
MODIFICATION IN SCHEDULE OF AUTOMATED QUERIES:-
If you want to make changes in the schedule then select the query and click on the Schedule button at the bottom it will pop up the window just create the new schedule and delete the old as well and click on transfer.

The BEx Web query automation is a standalone, comfortable Web application for data analysis that the user can call up using an URL or as an iView in the Enterprise Portal. The Open a query which you want to automate through BEx and offers a wide range of functions for data analysis via various tab pages and the associated view-specific toolbars.
SAP query automation is an information modeling tool which can be used to analyze business data. To help analyze data in a more user friendly manner, SAP BW used to describe any kind of numeric information from a business process level. There are various ways to describe key figures in SAP BW.
Essentially, a query is a database research action with interesting additional functionality like currency scenarios, complex calculation options, and analysis functions. However, analyses born out of queries can be applied flexibly to a multitude of areas in a multidimensional dataset of an SAP BW Info Provider. This is enabled by combining analytical functionality with the provided drilldowns and filter options. Therefore, one query or few queries can often map an entire analytical application.

How to achieve full potential of Test Automation?

Why test automation?

Software testing is an art, aimed at evaluating an attribute or capability of a program or system and determining whether it meets the expected outcomes. Software testing can be very costly and time consuming.

Hence automation is a good way to cut down time and cost.

Benefits of test automation:

Test automation provides numerous benefits to any organization. Some of them are listed below:

• Reduced test execution time and cost
• Increased test coverage on each testing cycle
• Increased value of manual testing effort
• Reduced manual work

Reasons for failure of test automation:

There are a number of reasons why test automation efforts are unproductive. Some of the most common include:

• Poor quality of tests being automated
• Lack of good test automation framework and process
• Inability to adapt to changes in the system under test

Five Steps for Successful Test Automation

To avoid the above reason and to achieve the full potential of test automation, emphasis has to be given on the below steps:

• Planning
• Preparation
• Proof of concept
• Implementation
• Maintenance

Planning

Each phase in the project must be planned with a clear view on the current testing methods and information of the infrastructure. Gather information from key people who have experience in test automation.

Preparation

During preparation phase, a pilot project should be defined and test cases that need to be automated have to be selected. Define the roles and responsibilities and prepare input test data.

Proof of Concept

The test automation tool must be configured in order to be compatible with application under test (AUT). The tool must be able to capture user actions. Since more and more application types may be being used, the configuration part is not as easy. It is possible that the test tool will not recognize the application “out-of-the-box”, which means you need to configure the tool.
Then the team needs to automate a limited amount of test cases to prove that the application can be automated. Select an easy, a normal and a complex test case. Demonstrate execution and reporting of the automated test cases to decision makers.

Implementation

If proof of concept is successful, automation of selected test cases (scope defined at preparation step) can start. Analyze selected tests, think about data separation, functional decomposition, reusability of certain business components. Modularize your script into clear-cut building blocks. During this phase, you can set up test automation framework which can vary from documentation on tool usage to a full-scaled framework based on a spreadsheet or database layer.

Maintenance

A test automation project expands together with application under test. A new release may offer new functionality that needs to be automated. The existing automated scripts need to be maintained, new automated tests need to be added and there is a possibility that other organization may take over automation project in future. Team has to prepare for these events by providing documentation for each script, by constantly allocating the proper resources for the project and by training newcomers in the tool, the script and the execution.

Conclusion

Test Automation in today’s competitive environment is much needed than desired; to keep operating efficiently and considerably cut down costs and efforts, without compromising on quality and security. However you must adopt a well planned and a structured approach to automation in order to ensure a higher return on investment. It is suggested that prior to opting for automation, QA teams need to perform an exhaustive automation assessment to identify the right set of automation methods, tools and techniques that will compliment their QA needs.

Cloud Computing- Easily Config To Any Computer Resource's

What is Cloud Computing?


Cloud Computing is a model that enables access to a configurable computing resource, which is easily accessible with no or only minimal service provider input.

“If the user does not know the physical location and configuration of the system that delivers the services of computation, software, data access, and storage services”, then it is Cloud Computing
.
The Flexible usage of IT services which are available in real-time/on-line via the Internet/Intranet, enabling users global access to standardized services. Cloud Services require no (or minimal) initial fixed cost investment and are charged on a usage basis.

What can be achieved with Cloud?


Within Cloud Computing, varieties of technically innovative solutions are combined and can deliver the potential for an innovative business approach leading to:

• Cost  Reduction
• Cost Structure Improvement
• Variability of Cost
• Flexibility of Services
• New business models
• Time to market for new products is significantly reduced

Steps to Optimize Cloud Computing:

Is the Business ready to use Cloud?

If yes, which services offered within the Cloud are the most suitable to support the Business Model?

Before engaging in Cloud Computing, initiate a project that reviews existing processes and products. The review process should go through the following steps in order to optimize use of Cloud Services:

Step 1: Standardization – Evaluate the actual level of process automation within the business being serviced.

Step 2: Virtualization – Identify the opportunities (from an IT and process perspective) within the existing operating model to virtualize services.

Step 3: Automation – Analyze level of automation of processes and identification of potential by using the Cloud for virtualized processes.

Step 4: Cloud Computing – Introduce those selected services into Cloud and define how to integrate Cloud services into existing IT/process environment.

When should a company go for cloud computing?


There is a growing belief that over the next few years, Cloud Computing will become a major stimulus for change in how corporations view and use Information Technology.

Cost efficiency, scalability and availability are the main drivers in the discussion regarding Cloud Computing. Security and privacy are the main issues, which need to be dealt with when using services in the Cloud.

From an end user perspective, Cloud Services will offer small and midsize companies access to a level of technology that is currently not available to them. Large corporations will be able to make their IT environment more flexible and reduce their cost base. The speed of new product developments will increase significantly and will offer major advantages for the end customer.

Conclusion:


All major providers offer services in the Cloud, which can bring enormous advantages to large, small and midsized companies when properly implemented and used. There are challenges in implementing Cloud Computing, which are similar to those inherent in IT sourcing engagements and can be successfully dealt with when addressed in a structured way.