Skip to Content
Whilst working with BW BEx users, I often get asked to explain what a key date is and how it affects query results. It’s understandable that this can sometimes be a little confusing to users as you really need to know a little bit about how your BW handles Master Data within your data model star schema. Characteristics can contain attributes, which help describe in detail information about the characteristic itself.

  • For example The 0EMPLOYEE characteristic holds the value of an employee’s personnel number. This is great but it would be better if we new more information about this employee. This is where attributes come in. We can assign attributes to the 0EMPLOYEE characteristic that describe more information about the employee such as Job, Position, Gender, Personnel Area etc…

When attributes are assigned to a characteristic, we can add these attributes to our reports in the BEx Analyzer. When we run the report, the BW system reads the attribute values that correspond to the characteristic and displays them in our query results. Woohoo, I hear you cry, but what about the Key Date? When attributes are assigned to characteristics, there is an option to specify that the attributes are Time Dependant. This means that instead of the BW system reading a single attribute value that corresponds to the characteristic, the system has to use dates to workout if the attribute value is valid for the reporting time period the user has chosen when running the report. This is made possible because when Time Dependant data is loaded into a BW system for a characteristic, a start-date and end-date is loaded with it identifying when an attribute is valid. Know when a query is executed that displays attribute information; the BW system needs to know what date to use when searching for the relevant attribute information. This is where the Key Date comes in. BW uses the Key Date as a special parameter to read the relevant attribute records that correspond to the characteristic. You may have designed queries in the past that use attributes but have never specified a Key Date and found that sometimes the correct information is displayed and other times it isn’t. This is because by default the query will use the current system date to find the attribute information if no Key Date is specified for the query, resulting in only the most recent attribute data being displayed. To ensure your reports display the correct attribute information all the time, make sure you either manually specify the Key Date in your query design or use a variable to determine the date at run-time. This can be done by selecting the Query Property screen from within the Query Designer. image My preferred method is to always display a parameter that the user must fill when the report is executed.

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. Amit Tandon
    Hi Peter,

    I have a question though….

    I have a query that has attributes but none of them is ‘time dependent’.

    However, still I get different values of keyfigures (sales amount) when I run the query with and without the ‘key date’.

    I have checked all the attributes in my query (in filter, in free characteristics, in the restrictions on the key figures and in the rows) but none of the attributes are ‘time dependent’.

    Am I missing anything?

    Thanks,
    Amit

    (0) 
  2. Sonal Patel
    Hi Peter,
    I have used 0person as time dependent master data
    which has division as time dependent attribute
    Now in report i want the division as per the validilty when i run the report month wise
    but it show only last change of division in all the months.
    Is there any other setting i need to do at query level…
    (0) 
  3. Max Cohen
    Hi,

    What if you would want a report that reports the changes in the master data?

    I’m considering to use the infoObject as a source for a Datasource.

    thanks,

    Max

    (0) 

Leave a Reply