Sep 16, 2013
8.5.2025
8.5.2025
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.
Looking to become more data-driven, optimize processes, or leverage cutting-edge technologies? Our blog provides valuable insights – but the best way to tackle your specific challenges is through a direct conversation.
Let’s talk – our experts are just one click away!
Domain Lead Insights & Information Design
OData is the language your SAP system uses to talk to the world today. We'll show you step by step how to turn an idea into a production-ready, delta-capable OData service in S/4HANA or ECC.
SAP data integration is complex: performance issues, storage limitations, and third-party system integration pose significant challenges for businesses. With our flexible framework, you can create a powerful and scalable solution that seamlessly complements SAP BW and S/4HANA—efficient, future-proof, and cost-effective.
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.
No previous post
No next post
