The new functions READMETADATA() and PLACEMETADATA() offer a range of quite new possibilities to the arcplan designer. As shown in the arcCorporation Demo, data queries can be dynamically set up and modified via drag & drop.
The set-up of such a query is described below.
In order to have the entire cube structure available, it can be extracted from the database window as depicted below:
In the following example, the list of all objects available in the Cube is shown to the user. The user may then move any hierarchy from any dimension into a hierarchy object via drag & drop.
After the Cube is available, the metadata must be read. In order to do so, the following formula with the parameter 3 = SELECTION is used.
READMETADATA ( [<AW_Hierarchy>] ; METADATA ; SELECTION )
The function must be run in a table as the Cube name is always shown in the first row in case of application to a hierarchy, and if the hierarchy is not open, there is always a ‘+’ in the column behind the selection. The result is shown in the following screenshot in the table at the top right.
The selection can then be read in a separate object or directly in the next formula via [<AW_METADATA>; ROW2; COLUMN1] or REFERENCE ( [<AW_METADATA>] ; 1 ; 2 ). READMETADATA cannot be used directly in the reference formula.
Subsequently, a hierarchy menu can be populated via the function PLACEMETADATA. This will then contain the Selected Hierarchy.
If PLACEMETADATA is now run in the target object under "Upon Drop", hierarchies can be exchanged via drag and drop as in the arcplan Corporate Demo.
IMPORTANT! The selection of the hierarchy in the source object will behave just as the selection in the database window. In order to carry out correct queries, a real hierarchy must be selected.
Do you want to replace the IoT core with a multi-cloud solution and utilise the benefits of other IoT services from Azure or Amazon Web Services? Then get in touch with us and we will support you in the implementation with our expertise and the b.telligent partner network.
Domain Lead Insights & Information Design
With the new function REPLACEEXPRESSION, arcplan 7 affords the possibility to influence the automatically generated SQL and MDX statement. This has the benefit that a design can continue to be made with “arrows” and that one is not limited to formulas. Currently, only simple adjustments of the query are possible with this tool; however, there is a large impact on the resulting possibilities.
With the Q2 2023 updated titled "New optimized story experience - unified strories and applications", SAP analytics cloud offers users new ways to develop reports and dashboards even more flexibly and easily in an integrated design enviroment. We'll showyou which new features theupdate provides and how it supports you in creating reports,
As a business intelligence package, SAP BW provides many opportunities for efficient reporting – but also contains numerous barriers which significantly slow down performance. Using the example of report filters available in the application, this article shows how the smallest adaptations impair SAP BW performance, and how efficient settings for filtering options can improve results.
No previous post
No next post
