A background report to connect to databases enables the user to login to all required systems with one single loginin the background; there is no need for the user to explicitly login to each connection upon its first access. The requirement is, of course, that the user exists in all systems with the same access data.
In addition, logins to systems which are not personalized but operate with a technical user can be performed.
If there is no such background report, a login dialog popup appearswhen a report with database reference is opened. This function enables the user to login to the respective database.If several databases are used, several dialogs will open up. One for each database.
In order to prevent this from happening and to offer the user a comfortable login to the application, it is recommended to prepare a separate start report. At the most basic level, this could e.g. look as follows.
arcplan offers the possibility to enter encryptedtext into fields.
(Object Properties [F2] - Select Encrypted Input).
The login button then contains the login to the database.
"DB_AdventureWorks" = Name of the Connection File
It is important that data from the databases arerequested no sooner than in the next dialog. Otherwise, the login dialog popup will open as usual.
An additional benefit is the possibility to select the system prior to the login, in order to e.g. be able to switch between test and productive environment.
see link: Tips & Tricks: Switching between Data Sources
In addition, a path where the respective connection file for test or production is located, has to be specified prior to the login.
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
