Seven Essential Tips and Tricks for Queries and Tables - Part Two

494 results

  1. Best Practices for Allowing Power Users to Develop Queries in BW

    Reading time: 30 mins

    More and more businesses now authorize power users to develop queries in the BW production environment. Often the benefits of relying more on power users to create queries outweighs the risks and can even reduce the workload for your BW team. The author examines some of the key issues, policies, and best practices that you…...…

  2. Ask The Expert: Copy and Move Queries without Transports

    Two of the most frequently asked questions about SAP Query involve copying and moving user queries. The author explains how to quickly copy queries across user groups and move queries between clients without the use of transports. Key Concept Dear HR Expert, How do I copy queries across user groups, and how do I move…...…

  3. Help Your Queries Run More Quickly Using the OLAP Cache

    Reading time: 12 mins

    Your users can benefit from one another when they run similar queries thanks to the online analytical processing (OLAP) cache. It is designed to store the results set used by certain queries to improve system performance. The system quickly reads from past query results stored in the cache rather than from the InfoCube or aggregate…....…

  4. Ask the HR Expert: Save Time by Moving Your Existing Queries to a New InfoSet

    Learn how to transfer queries from the global query area using preconfigured InfoSets to a custom InfoSet in the standard query area. This technique allows you to capture all desired InfoSet data without recreating existing queries in a new InfoSet. Key Concept Dear HR Expert, How can you transfer queries created in the global application…...…

  5. 3 Approaches to Create Global Ad-Hoc Queries

    Learn the details on how you can transport user-defined ad-hoc reports from development to quality to production in your SAP ERP HCM implementation. Follow this process when you want certain reports (queries) transported and available to all users in all environments. For example, this approach is useful if you create a report in ad-hoc, but…...…

  6. Quick Tip: Best Practices for Designing SAP BW BEx Queries and a Comparison of Connection Options

    This checklist helps you learn SAP BW BEx Query design best practices to enable you to build performance-optimized SAP BW BEx Queries. Also see a quick comparison of the three SAP BusinessObjects connection types: Business Intelligence Consumer Services (BICS), relational, and Business Application Programming Interface (BAPI) connections. This quick tip also helps you decide which…

  7. 8 Tips for Building Efficient BEx Queries for SAP BusinessObjects

    After the acquisition of Business Objects, SAP has increased the integration between SAP NetWeaver BW and SAP BusinessObjects very quickly. However, some challenges with regard to performance still remain. Find out how you can improve the usability of BEx queries with SAP BusinessObjects to increase report performance. Key Concept To analyze a dataset in SAP…...…

  8. Identify Fraud Risks with Forensic Audit Queries

    Reading time: 23 mins

    Audit committees, management, investors, regulators, and external auditors expect your business process controls to be effective, efficient, and testable. See how to extend your GRC functionality to identify control exceptions in your SAP system by locating data in SAP tables and running forensic audit queries. Out of the box, compliance solutions such as the SAP…...…

  9. Monitor Your Queries and Workbooks

    Reading time: 12 mins

    It’s a challenge to identify when a workbook or query was changed if many consultants are working on a project. You need that information when you are deciding which workbooks to transport. Learn about a method to monitor workbook changes. Key Concept In BW, it is important to have instruments for object monitoring. These tools…...…

  10. Using SAP Lumira Desktop in Combination with SAP BW Queries

    With the latest release of SAP Lumira Desktop, you can now connect directly from SAP Lumira Desktop to your SAP BW system using BEx Query connectivity. Learn the steps required to connect to SAP BW using this new option and see how your existing metadata is supported by SAP Lumira. Key Concept Until recently, SAP…...…