SAP Knowledge Base Article - Preview

1508237 - First Steps to Check Wrong Number in BW Query (Transaction RSFC)

Symptom

  • When run a BW query, you notice that some numbers in the result are not as you expected, or you think they are wrong.
  • In the query, you have used one or a few following features:
  • OLAP Analytic Features, like 
    • Conditions,
    • Constant Selection,
    • Elimination of Internal Business Volume,
    • Exception Aggregation,
    • Local Aggregation,
    • Slow Moving Item Report,
    • Temproray Hierarchy Join,
    • Variables,
    • Virtual Time Hierarchy
  • Intergrated Planning Features, like
    • Access Type for Result Values (Combination Proposal),
    • Disaggregation,
    • Lock behavior,
    • Units (Currency/Quantity),
    • Writable Cells,
    • Writable rows
  • Data Modeling Features, like
    • Current Data,
    • Multiprovider
  • When designing a BW query in BW BEX Query Designer, you want to use feature options as listed above, but somehow it looks confusing, you don't understand what exactly it means.


Read more...

Environment

Transaction RSFC is available with Business Warehouse BW 7.0 with NW Support Package Stack 15

Product

SAP NetWeaver 7.0 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

display result as, Request Status, multicube, formula, missing data, missing record, unexpected results, wrong number, wrong figure, unexpected result, OLAP engine, OLAP feature, behavior not understandable, query designer, confusing options, inputable , KBA , BW-BEX-OT-OLAP , Analyzing Data , BW-PLA-IP , Integrated Planning , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.