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