Transitive attribute in SAP Datasphere

Preface

Transitive attribute is a useful feature in SAP BW, this blog will explore the possibility of implementing transitive attributes in SAP Datasphere

Disclaimer: All the data created are for demo purposes, the approach is used to demo the functionality of the currency conversion in SAP Datasphere, not intended for production design or usage.

Implementation:

Let’s first draw the diagram to explain the concept of Transitive attribute, our goal is to display the attributes: Address and postcode from Company Code

Country Spend is transaction data, it has Country dimension, Company Code dimension and measure Amount.

Country dimension has attributes: Company Code, Language, and Company City

Company Code dimension has attributes: Address and Postcode

In SAP Datasphere, we will create the same data model according to the above diagram:

Company Code dimension with its attribute (no association, Company code as key):

Country dimension with its attribute ( Compound key: Country + Company Code, association to Company Code), Country dimension act as a bridge to navigate to Company Code

Association to Company Code dimension:

Country Spend transaction data with association only to Country dimension, not to Company dimension

Create an Analytical Model on top of Country Spend view

Important note: we enable the attribute Country only and can see the associated dimension: Country

If we click on associated dimension: Country, dimension Company Code with transitive attribute: Address and Postcode will show up

Now it is time to show the magic with Data Preview 😀:

The attribute of Company Code can display nicely in the final output.  

Summary:

The way to implement transitive attribute is similar to BW and functionality can be achieved perfectly in SAP Datasphere without much effort. 

Feel free to post any questions you may have, thank you for your time.

​ PrefaceTransitive attribute is a useful feature in SAP BW, this blog will explore the possibility of implementing transitive attributes in SAP DatasphereDisclaimer: All the data created are for demo purposes, the approach is used to demo the functionality of the currency conversion in SAP Datasphere, not intended for production design or usage.Implementation:Let’s first draw the diagram to explain the concept of Transitive attribute, our goal is to display the attributes: Address and postcode from Company CodeCountry Spend is transaction data, it has Country dimension, Company Code dimension and measure Amount.Country dimension has attributes: Company Code, Language, and Company CityCompany Code dimension has attributes: Address and PostcodeIn SAP Datasphere, we will create the same data model according to the above diagram:Company Code dimension with its attribute (no association, Company code as key):Country dimension with its attribute ( Compound key: Country + Company Code, association to Company Code), Country dimension act as a bridge to navigate to Company CodeAssociation to Company Code dimension:Country Spend transaction data with association only to Country dimension, not to Company dimensionCreate an Analytical Model on top of Country Spend viewImportant note: we enable the attribute Country only and can see the associated dimension: CountryIf we click on associated dimension: Country, dimension Company Code with transitive attribute: Address and Postcode will show upNow it is time to show the magic with Data Preview 😀:The attribute of Company Code can display nicely in the final output.  Summary:The way to implement transitive attribute is similar to BW and functionality can be achieved perfectly in SAP Datasphere without much effort. Feel free to post any questions you may have, thank you for your time.               Read More Technology Blogs by Members articles 

#SAP

#SAPTechnologyblog