Search code examples
sql-serverexcelssaspivot-table

SSAS Label for a Measure is Different in Pivot Table than Source Project

I'm reviewing a SSAS database designed by someone else who is long gone. The SSAS project was designed in BIDS 2010 and has an Excel pivot table as the front-end to do the reporting.

When I look at a particular measure in the Excel pivot table it has a label "Actual 2014". However, when I look at the design in BIDS (looked in the cube design, data source view, and a few other areas) the label name is "Actual".

Where can I find where I can change the label being displayed in the Excel Pivot table?

EDIT

Here's a picture of what it looks like. You can see where it says "2014 Actual" and "2015 Budget". In the field list, but the underlying database all labels say "Actual" and "Budget" respectively (as it shows even in the "values" section).

enter image description here

Solution

  • It could be an Excel issue, not an SSAS. In the Excel Pivot, Display the field list, and on the left, under Values, check the Value Field settings (right click to display). The custom Name is probably different. enter image description here