In any application, there are always central functions which control a generic process. These functions request reporting-specific functions from the central area. If, for example, a report only requests data when needed, but is supposed to be directly updated when a favorite is activated, the update must be triggered by the central document.
Here, the problem arises that there may also be reports which are always up to date. In this case, the central function must not activate the button for manual update because this would not exist in this report. Thus, there would be an error report.
One solution for this problem is the maintenance of a control table in a database which contains information on when a manual update is necessary or sensible. In the course of the update of the report, this information could then be requested. However, the efforts to maintain this information are relatively high. The functionality and also the possibility to evaluate reports are in place despite the efforts and the susceptibility to error. However, it is more elegant to use a dynamic assessment of whether an object exists. arcplan does not provide a function to do so. The assessment can be done with the following formula, however:
ISEMPTY(OBJECT([<Report_Update_Button>];[<ReportName>]))
This formula identifies the object with the name <Report_Update_Button> from the report <ReportName>. If this object does not exist, the assessment with ISEMPTY will return a “1”, otherwise a “0”.
It is important in this context that the function ISEMPTY() naturally evaluates the contents of an object. In the example of the update, the object to be assessed is a button. The content of a button is the text which is stored in the “Issue” characteristic (the labeling) of the button. Thus, this must not be empty. Thus, the same applies to all other object, , as well: an assessment can only work if there is content.
An assessment of whether an object is empty or not is frequently also done with the following construction:
OBJECT([<Report_Update_Button>];[<ReportName>]) = EMPTY()
This kind of assessment, however, does not work for the case described here, as an “= EMPTY()” can only be applied to objects with the “calculate event”. Thus, only the formula stated at the beginning should be used for the assessment.
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
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.
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.
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,
No previous post
No next post
