Skip to Content
0

Neither %GT in Analysis office or Constant selection meet requirement

Apr 27 at 09:30 PM

53

avatar image
Former Member

Hello Gurus,

It is a know issue that %GT does not work in Analysis office when using OLAP connection https://launchpad.support.sap.com/#/notes/1951436 I have used constant selection method as an alternative. However the % contribution in constant selection method only works when you are looking at over all results. It is not dynamic and does not update when I filter on the report.

eg. When you look at % contribution of one Customer over 5 Countries % GT( Constant selection) is 2%. When I filter the report to just that customer's country %GT( Constant selection) stays at 2% instead of updating to 10%.

As such the %GT and %GT constant selection are not the same and the later does not meet my requirement. Any ideas on how to make constant selection dynamic?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tammy Powlas
Apr 28 at 11:52 AM
0

Hi Thomas - what about using Excel functions and not the Analysis Office ones? See https://blogs.sap.com/2018/03/11/sharing-experiences-with-analysis-office-2.5-2.6-bihana2018/

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

That will cause issues if the user drills into the report. I don't know where in your Blog you are pointing to.

I see you have version 2.5 & 2.6 does OLAP connection and %GT work in latest versions?

0

Hi Thomas - I am referring to the Excel formula use; it is best with 2.6

0