SAP Knowledge Base Article - Preview

2629035 - BW Query: Sign not Reversed though 'Reverse +/- Sign for Nodes' Function is used in Hierarchy Definition

Symptom

You are using  'Reverse +/- Sign for Nodes' function in the hierarchy definition.

hierarchy definition main page.png

hierarchy definition.png

Cube data is like this.

cube data.png

You expect the query result to show the sign reversed value 10 for ZBAY/375050. But it still shows -10.00, which is not reversed.

query not reverse.png


Read more...

Environment

BW7.x

Product

SAP NetWeaver all versions

Keywords

reverse sign, sign reverse, sign reversal, sign change, 0SIGNCH, SIGNAGE for Accounts not working , KBA , BW-BEX-OT-OLAP , Analyzing Data , BW-BEX-OT-OLAP-HIER , Using Hierarchies , Problem

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.