Problem solve
Get help with specific problems with your technologies, process and projects.
SAP business warehouse
Swisscom makes gains by shrinking data warehouse systems
When Swisscom needed to merge two SAP ERP systems and several SAP BW data warehouses, it upgraded to one SAP BW on HANA system to reduce data from 5 TB to 1 TB. Continue Reading
What are the differences, similarities between SAP BWA and HANA?
SAP BWA paved the way for the HANA in-memory database, so are the two all that similar? Ethan Jewett lays it out in this Ask the Expert column. Continue Reading
How does SAP help companies manage big data?
From HANA to IQ, consultant Ethan Jewett outlines the SAP tools companies can use to manage big data. Continue Reading
-
How does SAP BI compare with other suites, 'best of breed' tools?
In this Ask the Expert column, Ethan Jewett explains the biggest difference between SAP BI and 'best of breed' tools, as well as other suites. Continue Reading
SAP data warehousing: What are the options?
There's no one way to go about data warehousing, explains data expert Ethan Jewett. Here's what you need to know about deciding which route to take. Continue Reading
Tap SAP Information Steward to see how BEx query changes affect reports
Companies should use SAP Information Steward's Metadata Management tool to avoid 'broken' BI reports, writes SAP expert Don Loden.Continue Reading
SAP HANA best suited for solving ERP performance issues
SAP expert Tony De Thomasis lays out a plan for companies looking to deploy SAP HANA.Continue Reading
Performing RFC connection checks in NetWeaver BW with SAP TREX
SAP administrators can use SAP TREX to diagnose and repair broken RFC connections between SAP NetWeaver BW and the blades of the BW Accelerator.Continue Reading
Understanding the SAP NetWeaver BW Accelerator
This chapter download explains the basics of the SAP NetWeaver BW Accelerator and how to repair connections to the NetWeaver BW system.Continue Reading
Sizing hardware for SAP BW applications
An SAP user is looking to assess the hardware requirements for an SAP BW application and wants to know what the parameters are of sizing hardware for SAP BW.Continue Reading
-
How to change the characteristics of an SAP InfoCube
An SAP user is looking to change the values of a characteristic in an SAP InfoCube and wants to know if it's possible to use virtual InfoCubes to manipulate the data.Continue Reading
How does SAP R/3 data differ from BW (NetWeaver BI) data?
What is the difference between data on SAP R/3 and data on SAP BW?Continue Reading
Adding custom fields for retail product comparisons in SAP BW
Need to analyze and compare product sales, product cost and suggested retail price etc? This tip shows you how to customize the R/3 BW datasource/extractor to get elementary fields such as AFS color and size into BW.Continue Reading
Prerequisites for SAP BI training
What are the prerequisites for SAP BI training? I have a J2EE background and I want to move to BI. I have heard SAP BI is the latest and greatest in business warehousing. I have also heard people say it's techno-functional, whatever tha means). Will...Continue Reading
The tables/views used to populate extractors
I am trying to ascertain what tables/views are used to populate an extractor. I need to get the size of the underlying tables on R/3.Continue Reading
What's the difference between ODS and DSO in SAP BI?
In SAP BI, what is the difference between ODS and DSO?Continue Reading
Adding special characters in SAP BI
Are your SAP BI extractions failing too often? It could be a problem as minor as an invalid character within the report. Learn the acceptable characters as well as how to fix the issue all together in this tip by Aaron Wang.Continue Reading
What is the difference between SAP BI and BW?
What is the major difference between SAP BI and SAP BW? If I study SAP BW 3.0, will the concepts be similar to what I will find in SAP BI?Continue Reading
The difference between territory management and organizational structure
What is the main difference between territory management and organizational structure?Continue Reading
Steps for a generic extraction of FI/CO, COPA and LO in SAP BW
What are the necessary steps for a generic extraction of FI/CO, COPA and LO in SAP BW?Continue Reading
What are the responsibilities of an SAP BW administrator?
I am new to BW; what should a BW administrator study? Also, what are the responsibilities of an SAP BW Administrator?Continue Reading
What is the difference between SAP BW 7.0 and SAP BI?
What is the difference between BI (Business Intelligence) and BW (Business Warehouse) if any? Also, is there a difference between SAP BW 7.0 and SAP BI? BI/BW expert Jay Narayanan shares a clean cut answer.Continue Reading
Currency translation using SAP BI
Are you in need of a currency translator? Most companies nowadays are not limited to domestic sales and have to deal with many different currency types. Rasim Manavoglu shows us how to set up a currency translator with one standard currency output ...Continue Reading
How to acquire the runtime information of a data transfer process (DTP)
This article will show how you can access the runtime information of a 'Data Transfer Process' and what data is available.Continue Reading
Performance tuning in SAP BW
Find out the specifics about SAP BW perfomance tuning in this response from BI/BW expert Jay Narayanan.Continue Reading
SAP logistics information system (LIS) out, hello LO
Find out about the status of your LIS sytem and its replacement, LO.Continue Reading
Using SAP NetWeaver Business Intelligence for SAP Business Workflow Analysis
In this tip by SDN contributor Ginger Gatling, learn how to create useful queries from the workflow BI data in your SAP NetWeaver 2004s system using Visual Composer.Continue Reading
Reporting SD, FI and MM in BW
Expert Jay Narayanan explains how other modules like Sales, Finance and Purchasing can be reported through SAP BW.Continue Reading
Difference between BW functional and technical consultant
Expert Sam Gassem identifies the roles of the BW functional and BW technical consultant in this expert response.Continue Reading
A list of versions of SAP BW
Versions and differences in SAP Business Information Warehouse.Continue Reading
What is a BW datasource?
Our expert defines the BW datasource and describes what it takes to maintain it.Continue Reading
Replicating the datasource in BW
Discover the replicating process of datasources and how they end up in BW.Continue Reading
What's the difference between SAP BW and SAP BI?
What is the difference between SAP BW and SAP BI? Is it required to have programming knowledge for learning BI/BW? Get Jay Narayanan's answers here.Continue Reading
14. How to save a query
Learn the response to the fourteenth question in SearchSAP.com's exclusive BW reporting quiz.Continue Reading
Main difference between a transfer routine and transfer rule
Describes the main difference between a transfer routine and a transfer rule.Continue Reading
Definition: cumulative vs. non-cumulative key figures
Describes the difference between cumulative and non-cumulative key figures in BW.Continue Reading
What steps need to be taken to add an InfoObject into an InfoCube?
Learn the step-by-step methodology for adding an InfoObject into an InfoCube through Business Content with SAP BW in this expert advice.Continue Reading
What is data extraction in SAP BW?
Learn about data extraction in BW delta types and update methods. Also learn from BI and BW expert Jay Narayanan what type of extractors use which type of delta methods.Continue Reading
SAP BW: Top 10 best practices
Looking for best practices for business warehouse (BW) applications? Janet Hutchinson, a BW expert from Wyeth Pharmeceuticals, gave a presentation at SAP TechEd '05 on ten ways to leverage BW in your enterprise.Continue Reading
Error extracting data from SAP R/3 to BW
Learn how to troubleshoot an error message while extracting data from R/3 into SAP BW. BI and BW expert Jay Narayanan explains how to correct one reader's system error.Continue Reading
ODS architecture in SAP SD: Best practices
Where is the logical breakdown of ODSs? We have one standard SD InfoCube we are planning on using. Later, we will add FI, PP, MM and InfoCubes. What is the best way to architect this so that using the InfoCubes and ODSs do not affect performance?Continue Reading
How to concentrate two fields in BW Query Designer
Learn how to concentrate two fields in BW Query Designer. SAP BW and BI expert Jay Narayanan explains how.Continue Reading
Can I change the InfoProvider that a query uses?
Is it possible to change the cube used by a BW query? We have a number of identical cubes representing a quarter's history data. Rather than build a unique BW query for each quarter, I would like to build one query and change the cube it points to.Continue Reading
Using a replacement path variable to create a formula
Learn how to use a replacement path variable to create a formula, with advice from BW expert Peter Scott.Continue Reading
Can I extract data from a Hyperion database to SAP BW?
Learn how to transfer data from a Hyperion database into SAP BW, or from SAP FI t SAP BW.Continue Reading
Help! My BEx report is rounding up values
What are transitive attributes?
Using BEx Web Application Designer
How can I change the format of an SAP BW query?
is there an efficient way to change the format of an SAP BW query? (Number format, etc.). Find out in this SAP BW expert tip.Continue Reading
Is it safe to delete old IDocs as a cleanup process?
ERP Data Warehouse
What is an ERP-Data Warehouse? ERP data warehousing is "a framework of information objects that becomes the foundation of business intelligence...Continue Reading