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.