Skip to Content
Former Member
Jun 14, 2009 at 01:52 PM

Arithmetic & String Functions on objects in BO universe on SAP BW



We are on BO XI R2 SP5 integrated with SAP BI 7.0

1. How to apply arithmetic operations on measure (Key figure) objects in BO?

Example: Say If i want to invert sign of a key figure,Such operations are possible at report level. But how to do that universe level?

2. How can we apply string functions on dimension or detail objects in BO?

Example: What would be the syntax if I want to apply a substring function on a dimension at universe level?

Are there any documents available mentioning the syntax for functions in SAP mdx?

Please help.