Skip to Content
0
Former Member
Oct 22, 2012 at 01:12 AM

SAPGetData

131 Views

In Analysis for MS Office v1.3

My data source is an SAP HR Multicube

I have a crosstab set up with Amount by Year in columns and rows with the following hierarchy compact display in rows:

Personnel Area

Personnel Subarea

Person

I am trying to use the formula SAPGetData() as a quick way to find 'Person' data.

However, it only seems to work retrieving data at the 'Personnel Area' level not the 2 sub-levels.

If I move 'Person' to the top level the formula works.

Is there any way I can get this to work to find 'Person' data at the sub-level in the row hierarchy or is this a known limitation (seems a bit strange if it is)?

Thanks, Matt.