How can we create static BEx reports?
I'm assuming, like most clients I've worked with, you intend to do this in order to reference cells, and/or move the results to a home-made database solution. If you're looking for a fixed width/length report using the BEx Analyzer, you must take advantage of structures in your Query Definition. Using the Query Designer, you create a Rows structure and a Column structure. In each, you can label each row/column to your specific needs, and specify the logic for each row/column by using filters and restrictions. It is also possible to overwrite a column formula for individual cells using the "Define Cells" feature found in the Query Designer toolbar.
Dig Deeper on SAP business intelligence
Enhance SAP BW report printing for Web application templates by using the advice in this expert response by Peter Scott.
In this expert response, Peter Scott exposes how to query only negative projects in SAP BW reporting.
ODS objects support detailed information for reporting needs but can cause query performance issues. Peter Scott considers the options for BW ...
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.