Attribute in the hierarchy display as one value
-
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 -
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
-
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply