Excel GETPIVOTDATA and Analysis Services

B

Brett

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.
 
Top