In the diagram below you can see three departments: Sales, Marketing and Development, ordered as such. They are not ordered alphabetically, but according to an alternative sequence. SAP S/4HANA allows you to create hierarchies like that, where the no...
In our previous blog, we covered the basics of creating a Hierarchy with Directory. Now, we're taking a step further in this blog by enhancing our model with an extra node type, language-dependent texts, and time-dependency, both for the hierarchies ...
In the previous blog, we provided an overview of the new features introduced with the Hierarchy with Directory. In this blog, we'll guide you through creating a basic Hierarchy with Directory, starting from scratch and progressing to the data preview...
SAP Datasphere has rolled out a much-anticipated feature set with the Hierarchy with Directory. This feature set extends beyond directory capabilities, which we will explore in detail, to a host of other functionalities engineered to integrate smooth...
In this blog post we'll take you through the options to model a running Year to Date (YTD) metric in SAP Datasphere, using different approaches. This blog post is the third of the following series:
Fiscal calendar generation for SAP Datasphere usi...
The answer is described here: https://community.sap.com/t5/technology-blogs-by-sap/order-siblings-in-a-hierarchy-with-directory-with-sap-datasphere/ba-p/13638210
Hi @Conor_,You could see LV_PRODUCT_CATEGORY as the infoobject, and LT_PRODUCT_CATEGORY as the table underneath the infoobject (P*, Q*, etc. as they are called in BW).
Hi @Conor_,LT_PRODUCT_CATEGORY is the table serving the data for the dimension. Typically, you would not store language specific fields in a dimension. This would make the dimension a mess, e.g., you would get a record for each language you want to s...
Hi @Conor_,Correct. In my case it was a self-created table with dummy data with only that column. But a dimension will often have other fields available as well. Even for product category you could think of change date, changed by, category manager, ...
Hi @hasba_younes,Indeed, BW has a single place for storing the hierarchy directories. In SAP Datasphere every dimension has its own directory. In some calls, the directory entity is accessed directly without a join on the dimension values. So you wil...