Skip to Content

A key date variable allows you to specify a date for time-dependent data.

The key date selection influnce the data retrived: for example the region name can change with time, so dependent on the date selected the region name will be given.

We had a time dependent master data for Geography.

We created a Key Date variable “ZKEYDT(Enter Key Date)” which was a ready for input variable created on 0calday.

Universe was created on the BEx query and the report was created using WEBi.

When the report was executed the prompt for Key Date was not coming in WEBi.

Solution:

If we have a Key Date variable created at the BEx query, we have to mark “YES” for the KEYDATE_ENABLE parameter at the universe level (as seen below)

Key Date Parameters.png

Also if the Key date variable is created on 0calday you need to remove the char 0calday from rows/column of BEx query.

Key date variable properties are mapped to the five universe parameters

Keydate_enable = Set to yes if the key date is enabled on the universe

Keydate_name = Technical Name of the Key date Variable

Keydate_Caption = Text of the Key date variable

Keydate_Default_value = Default value of the keydate if it exists

Keydate_mandatory = set to yes if a user must enter a value or use the default

We had one more requirement with respect to the key date variable. I would like to share the same too.

We had a BEx query on 0Employee master data which had a key date variable prompt.

It was a yearly report and user ran the BEx report 12 times to get the data for each month start data and 12 times to get the month end data.User use to get the data for each month and paste it in excel and create the report for the complete year.

For Example: For Month End Data

For Jan : Input to Key date variable was 31/01/2012

For Feb :  Input to Key date variable was 29/02/2012

For Mar : Input to Key date variable was 31/03/2012 and so on.

In WEBi user did not wanted to run the report 12 times.

Solution:

We create the Universe on the BEx query and used the same universe 12 times in the WEBi query designer.

We named query as Jan,Feb,mar……,Nov,Dec.

Using the merged dimension property at the WEBi level we merged all the 12 months queries to show the data. When the User ran the report , he gets the prompts for each month where he can input the start or end date of the month and run the report.

User got the data by runnig the report just once.

Important Document:

Web Intelligence on SAP implementation best practices

I hope the blog helps you all.

To report this post you need to login first.

4 Comments

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

  1. Henry Banks

    Hi,

    Please could you confirm the product version (XI3.1 / BI4.0), the client tool (presumably Universe Designer), and the type of universe (MDX OLAP .UNV)?

    Regards,

    H

    (0) 
  2. Santhosh Sreshta

    Hi,

    I am very new to SAP BI/BO

    thank you so much for the information..!!
    I finally got some idea on KeyDate. 🙂
    but a small doubt ..
    where can we get the Key date name as you mentioned ( A technical name )..???

    (0) 

Leave a Reply