Attribute in the hierarchy display as one value

• Charmer

  SSChampion

  Points: 14885

  More actions

  January 27, 2020 at 8:12 am

  #3720503

  Hello Friends,

  I want to display the attributes in a hierarchy as one value in the cube. Just the last leaf level. Please refer the below image. Is it possible to display as '11A Base Maintenance' ? I am wondering if this is possible in cube by adjusting some properties instead of doing through ETL/database.

  

  Thanks,
  Charmer

• Site Owners

  SSC Guru

  Points: 80376

  More actions

  January 28, 2020 at 9:10 am

  #3720845

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• PB_BI

  SSCoach

  Points: 17093

  More actions

  January 31, 2020 at 7:42 am

  #3721902

  You have a few options, depending on how your cube is structured, but the most simple is to create a calculated column/named calculation (either in the underlying view/query or the Data Source View) and reference that as the Name/Value column of your leaf level.

  If you're using SSAS Tabular it is better practice to do this in an underlying view/query rather than in the cube itself.

  Multidimensional: https://docs.microsoft.com/en-us/analysis-services/multidimensional-models/define-named-calculations-in-a-data-source-view-analysis-services

  Tabular: https://docs.microsoft.com/en-us/analysis-services/tabular-models/ssas-calculated-columns-create-a-calculated-column

  General principles that apply to both: http://falconteksolutionscentral.com/?p=447

  ---

  I'm on LinkedIn