I have a problem with get GETPIVOTDATA, and getting data from an Analysis
Services cube.

When you drill down quite far, GETPIVOTDATA starts to display "#N/A", this
seems to be because GETPIVOTDATA is cutting the 'variables' short.

e.g. GETPIVOTDATA has the following:
=GETPIVOTDATA("[Measures].[Value]",$A$3,"[IS Structure TEST]","[IS Structure
TEST].[All IS Structure].[RETAINED INCOME].[NET INCOME BEFORE TAXATION AND
AFTER INDIRECT COST].[NET INCOME BEFORE TAXATION AND BEFORE INDIRECT
COST].[OPERATING INCOME].[NON-INTEREST INCOME].[CHEQUE ACCOUNT
FEES].[Management fees: Cheque a")

When it should have
=GETPIVOTDATA("[Measures].[Value]",$A$3,"[IS Structure TEST]","[IS Structure
TEST].[All IS Structure].[RETAINED INCOME].[NET INCOME BEFORE TAXATION AND
AFTER INDIRECT COST].[NET INCOME BEFORE TAXATION AND BEFORE INDIRECT
COST].[OPERATING INCOME].[NON-INTEREST INCOME].[CHEQUE ACCOUNT
FEES].[Management fees: Cheque accounts]")

Is there anyway around this? Also, it would help if I can set it up to pass
the member keys, and not the member names, as the keys are obviously a lot
shorter.

Any help would be appreciated.

Hi,

I have notice that problem and apparently the problem is a limitation on the
Pivot Tables that cannot retrieved data from members which length exceeds 256
characters.

To solve this (without reduzing the length) you can use the "Microsoft
Office Solution Acelerator for Excel Reporting".

"Brett" wrote:

Thanks for the reply. Do you have a link to it? "Microsoft Office Solution
Acelerator for Excel Reporting".???

"Tiago Rente" wrote:

http://www.microsoft.com/downloads/d...displaylang=en

"Brett" wrote: