Skip to Content
Former Member
Dec 11, 2013 at 03:15 AM

Unable to sort or add calculation when using BW query with characteristic structure


Dear All,

We are using a BW query (OLAP connection) with characteristic structure in Analysis for Excel. The problem is the I can't do sorting on key figures values and if I want to add custom calculation then it throws an error. For example if I want to subtract Actual-Month from Budget-Month then it give "Formula (1) contains a formal error (BRAIN-209)" error. Please see attached.

SAP Note 1671259 explains about above error message but none of my calculation has got any time or date operator.

I can do the same with BW queries which do not have characteristic structure. Is this a limitation from BW or something that Analysis for Excel is missing?

Any help will be really appreciated.