GETPIVOTDATA from OLAP cube - grouped field

B

bquackenbush

I am trying to build relative references to an SSAS OLAP cube using the
GETPIVOTDATA function (excel 2007). There is a field in the pivot table named
"Item". I have grouped this field and named it "Item1". I renamed the values
in the grouped field so they are more descriptive than "Group1", etc. For
example, I renamed "Group6" to "NBD".

When I create the initial formula by typing "=", arrowing onto a field in
the cube and pressing enter, I get the expected result and a formula such as
this:

=GETPIVOTDATA("[Measures].[Quantity]",$A$9,"[Item].[Item]","[Item].[Item].[Item1].[GROUPMEMBER.[ProductXl_Grp_6]].[Item]].[Item]].[All]]]")

This formula references Group6, aka "NBD". Excel seems to default the
GETPIVOTDATA reference to some system name for the value in the grouped field
("ProductXL_Grp_6") instead of my renamed value. Is there a way for the
formula to reference my renamed value instead of the system value for the
grouped field? This would make it easier to build relative references and
scale the formula to the entire worksheet.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top