How to display Historical Changes of primary data (4)

 Business scenario 4:Comparable architecture and comparable data.

Users want to see trend analysis of historical comparable data,Reports are collected only for businesses existing in both the old and new organizational structures to collect statistics on the business income of the parent company.. That is, all impacts caused by organizational structure changes are excluded from the statistics of reports.Comparable data for analysis.

Modeling Method:It is a time-related navigation Attribute Table that stores the parent company and two additional attributes "valid from" and "valid to" in the information object "subsidiary" primary data. These fields defined by the system that indicate the start time and end time are not used for the report navigation purpose, nor are they directly displayed in the query designer. The key date fields in the query attribute use the information of these two date fields. These fields that determine the key date and validity period can provide flexible REPORT query options. You can use a key date in a query to access different primary data records with the same feature value. However, you can only specify a key date, but cannot specify a date range for selection. In this way, we cannot use the two fields defined by the system to meet our business scenario 4 requirements.

One feasible method is to define two time fields, "Custom valid from" and "Custom valid to", indicating the validity period of an attribute ".

1. Define the information object "subsidiary 4" and add the predefined "Custom valid from" and "Custom valid to" to "subsidiary 4" as the navigation attribute.

 

2. After activation, let's take a look at the table structure of "subsidiary 4.

 

In this way, the custom Date Field appears in the report designer and can also be used as a selection condition for REPORT query. You can define a bi variable so that you can select a valid date for different primary data and analyze all primary data that has not changed since the date. In our example, we can select data that meets our business needs for analysis.

I am not very familiar with this kind of business, so the modeling method described in the book cannot be used. Who can see this article?ArticleHope you can give me some advice.