SAP Design Studio’s standard function
As you probably know, SAP’s standard export only allows for export to PDF in a quite basic way. However, you are already able to flag meta information to be displayed. What I’ve heard from a lot of customers though is that they would like to have more freedom to define which meta information to export!
Let’s say you have some static filters in your query, probably they are even only there for technical reasons. Fiscal Year Variant or Last Request are typical examples. Do you really want to show this information to your end users in the export?
How to add meta information to your exports!
This is why for our Export add-on for Design Studio (www.designstudio-export.com) we implemented a highly customizable solution for this!
The feature is available for all export formats: PDF, PowerPoint, Word and Excel. For PDF, you can even use it in headers and footers, so the meta information is automatically repeated on each page!
To include meta information, you make use of a placeholder, which is marked being surrounded by “%”. These placeholders can be used in the following parameters of our Design Studio export component:
- PowerPoint Template
- Word Template
- Excel Template
- HTML Template (PDF)
- Header HTML (PDF)
- Footer HTML (PDF)
- Bookmark Template (PDF)
There are four different ways of how to include meta information into the export:
1. General meta information
Here is a bunch of general placeholders that we provide:
2. Meta information that is already contained on the Design Studio application page
Meta information (such as filters) is often displayed to the end user. That’s why these pieces of information are already contained in the source of our export.
Let’s assume there is a filter panel with the technical name FILTER_PANEL_1, which contains several text components to display the filters (TEXT_1, TEXT_2, etc.).To include the meta information also in the export, you have several options:
- write %FILTER_PANEL_1% to move the full meta information into the export document
- write %TEXT_1%, %TEXT_2% separately to rearrange the meta information in the export
The second option makes especially sense if you export to PowerPoint or Word, and you want to display filters in a header line or slide title. For PowerPoint, Word or Excel Templates you may also control whether the information shall be rendered as an image, as a text with formatting of Design Studio (suffix :TEXT) or as a text with formatting of the template (suffix :VALUE).
Of course you can also use this way to export meta information that shall not be displayed to the end user.Simply add a text component to show this information. The hide it with our openbihidden class (do not use the SAP function Visibility = false!). You can still access the text component in the export document.
3. Pass custom meta information
If the meta information is not already displayed to the user, you can simply add it to the export via the “Custom Texts Array”.
We want to replace custom placeholder %DEPARTMENT% with “Financials” and %USERNAME% with “William Smith”.
To do so, we add two Custom Texts for the Export component:
USERNAME: William Smith
4. Meta information of the data source
Our export component is also capable of accessing the meta information of the data sources and make them available in your export. This way you can also export meta information that is neither displayed to the end user (option 2) nor manually passable (option 3).
Some examples of what you can do (for more, please check out our documentation!):
I hope that I was able to give you a good overview of the flexibility you have with our Design Studio Export when it comes to include meta information.
Feel free to contact us in case you have any questions!
Hope to hear from you soon!