Dimension Properties as Tooltip in Excel

https://blogs.msdn.microsoft.com/vhinz/2011/03/16/dimension-properties-as-tooltip-in-excel/

Step by Step:
Dimension Properties as Tooltip in Excel

Objectives:		This document describes how to configure Tooltip Information for Dimension members in Excel.   Sample: “Ort:Dortmund” as additional information
Limitations:		Not examined here
Prerequisites		SSAS Solution for an existing DB / cube Information as column in DWH / SSAS Data source View
Estimated Time to complete actions		~3 to n minutes (depending on your cube processing time)

 

Tasks	Detailed Steps
Steps to generate the property in your Cube	Ensure, that your properties are loaded with the dimension into your  SSAS solution Data source view (DSV). Open your dimension in your SSAS solution – Tab “Dimension Structure” Drag & drop the new property to your list of Attributes   Right click the new Attribute and select Properties Change the Property “AttributeHierarchyEnabled” to FALSE  (this leads to not displaying the attribute within you dimension selection  in Client tools, e.g. Pivot Field list in Excel or Query Designer in SSRS) Navigate to the TAB “Attribute Relationships”   Mark the automatically generated Relationship of your new Property –  and delete it Now, in the upper window drag & drop your Attribute  (where your property should belong to) to your new property. A new relationship will be displayed. Save your solution, deploy and rebuild the SSAS DB
Test the Property / Attribute description in Excel	Open your Excel Connect to your Cube and create a new Pivot Table Check the dimension property to be displayed in Rows or Columns Mouse over your Dimension members to display the new information.