January 27, 2020 at 8:12 am
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
January 28, 2020 at 9:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
January 31, 2020 at 7:42 am
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
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy