Seven Essential Tips and Tricks for Queries and Tables - Part Two
Skip to Posts
Filter By
Browse By
- SAP Analytics and AI
- SAP Application Development and Integration
- All SAP Application Development and Integration
- SAP ABAP
- SAP ABAP Development Tools
- SAP ABAP Test Cockpit
- SAP API Management
- SAP BAPI
- SAP Basis
- SAP BRF
- SAP Business Application Studio
- SAP CMS
- SAP Design Studio
- SAP Development Tools
- SAP DevOps
- SAP EAI
- SAP EDI
- SAP Extension Suite
- SAP Fiori
- SAP Fiori Elements
- SAP Integration Suite
- SAP Low Code Application Development
- SAP Low Code Automation
- SAP Netweaver
- SAP Release Management
- SAP UI5
- SAP Web Application Server
- SAP Web IDE
- SAP Business Process Management
- SAP Center of Excellence
- SAP CIO
- SAP Customer Experience
- SAP Data and Data Management
- All SAP Data and Data Management
- SAP BW
- SAP BW/4HANA
- SAP Crystal Reporting
- SAP Data Archiving
- SAP Data Center
- SAP Data Governance
- SAP Data Integration
- SAP Data Migration
- SAP Data Quality
- SAP Data Services
- SAP Data Strategy
- SAP Data Visualization
- SAP Data Warehouse Cloud
- SAP DMS
- SAP Document Control
- SAP EIM
- SAP ETL
- SAP ETL Tools
- SAP HANA
- SAP HANA Administration
- SAP HANA Deployment Infrastructure
- SAP HANA Studio
- SAP Master Data
- SAP Master Data Governance
- SAP MDM
- SAP Enterprise Architect
- SAP Enterprise Asset Management
- SAP ERP
- SAP Finance
- All SAP Finance
- SAP Accounting
- SAP AR AP
- SAP Asset Accounting
- SAP Billing Systems
- SAP BPC
- SAP BRIM
- SAP Cash Management
- SAP Central Finance
- SAP Controlling
- SAP COPA
- SAP Cost Center Accounting
- SAP e-invoicing
- SAP FICO
- SAP Finance Automation
- SAP Financial Closing Cockpit
- SAP Financial Consolidation
- SAP Financial Planning
- SAP FX Risk
- SAP General Ledger
- SAP Global Tax Management
- SAP Hyperion
- SAP Order to Cash
- SAP Payment Processing
- SAP Profitability Analysis
- SAP Rebate Management
- SAP S/4HANA Finance
- SAP Universal Journal
- SAP Governance Risk and Compliance
- SAP Human Capital Management
- SAP Intelligent Technologies
- SAP Platform and Technology
- All SAP Platform and Technology
- SAP Business Technology Platform
- SAP Cloud Connector
- SAP Cloud Integration Platform
- SAP Cloud Migration
- SAP Cloud Platform
- SAP Cloud Providers
- SAP Cloud Strategy
- SAP Container Platform
- SAP Digital Asset Management
- SAP Digital Integration Hub
- SAP Digital Signature
- SAP HANA Enterprise Cloud
- SAP HEC
- SAP Hyperscalers
- SAP Infrastructure
- SAP Messaging
- SAP Smart Forms
- SAP Quality and Testing
- SAP Security
- SAP Spend Management
- SAP Supply Chain Management
- All SAP Supply Chain Management
- SAP APO
- SAP Asset Management
- SAP Business Network
- SAP Digital Manufacturing Cloud
- SAP Digital Twin
- SAP EWM
- SAP IBP
- SAP Inventory Management
- SAP Label Printing
- SAP Logistics
- SAP Manufacturing
- SAP Manufacturing Automation
- SAP MES
- SAP MII
- SAP MM
- SAP MRO
- SAP MRP
- SAP Order Management
- SAP Plant Maintenance
- SAP PLM
- SAP Production Planning
- SAP S&OP
- SAP SD
- SAP SPM
- SAP Supply Chain Planning
- SAP Track and Trace
- SAP Transportation Management
- SAP System Administration
492 results
-
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…...… -
Ask The Expert: Copy and Move Queries without Transports
Reading time: 9 mins
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…...… -
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…....… -
-
Ask the HR Expert: Save Time by Moving Your Existing Queries to a New InfoSet
Reading time: 9 mins
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…...… -
3 Approaches to Create Global Ad-Hoc Queries
Reading time: 13 mins
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…...… -
Quick Tip: Best Practices for Designing SAP BW BEx Queries and a Comparison of Connection Options
Reading time: 8 mins
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… -
8 Tips for Building Efficient BEx Queries for SAP BusinessObjects
Reading time: 6 mins
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…...… -
-
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…...… -
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…...… -
Using SAP Lumira Desktop in Combination with SAP BW Queries
Reading time: 15 mins
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…...…
Become a Member
Unlimited access to thousands of resources for SAP-specific expertise that can only be found here.
Upcoming Events
-
Register Now: Mastering SAP June 2023
June 07 - 08, 2023
Melbourne, Australia
Join SAPinsider Preferred Membership for $199
View Event
Related Vendors
Your request has been successfully sent
This website uses cookies. If you continue to use the site you consent to our use of cookies in accordance with our Cookie Policy.ACCEPT Read More
Privacy & Cookies Policy
Privacy Overview
This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.