Key date in the reports

[Former Member]

Hi All,

Can any one tell the sample reports where we use the Keydate option in the query proiperies?

I wanna to see the bahaviour of the queries when i change the time dependent mastar data.

Thanks

Sravani

[former_member181964 · Accepted solution]

Hi,

Key Date: Every query has a key date. For time-dependent data, the key date determines the time for which the data is selected. The default value for the key date is the date on which the query is executed, that is today.

How to set it:

A.Choose Squer Icon to Select Values for Date dialog box appears.

B .Choose a date from the calendar. If you select 01.01.1999, for example, time-dependent data for 01.01.1999 is read.

C.Choose OK.

So in above case it will fetch the data for 01.01.1999 date.

See the SPA Help

http://help.sap.com/saphelp_nw2004s/helpdata/en/1e/99ea3bd7896f58e10000000a11402f/content.htm

You need to check in Content based on Module wise, so it may be tough to give correct report name, becasue it may not required in all Projects.

See the example:

http://www.sd-solutions.com/SAP-HCM-BW-KeyDate.html

Good PDF.

http://help.sap.com/businessobject/product_guides/boexir3/en/xi3_sap_whats_new_en.pdf

Thanks

Reddy

[former_member189845 · Accepted solution]

You're great and cool in explaining the things, this shows your technically strong.

Wanna become like you

[former_member215240]

Hi

I need to get the time dependent attributes of 0Employee (Valid from and Valid to) in report level. Please suggest how can achieve it.

Thanks and Regards

Santhosh

[Former Member]

No

I need the sample queries in BI Content I want to see practically how it behaves?

Thanks

Sravani

[Former Member]

Hi Sravani,

Please check the inventory querries, if the buiness content is installed in your project.

There are a few queries which will work on key date in inventory.

Hope this helps.

Regards,

Reddy

[Former Member]

Hi Sravani,

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.

Now 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 is not. 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.

For better understanding of Key date as Time dependent, please refer to the below url,

http://teklink.co.uk/sap/what-is-the-sap-bw-query-key-date/

[Former Member]

Key Date setting is for the 'time dependent' master data.

Lets say u have a Characteristic MATERIAL with a time dependent attribute MATERIAL GROUP as follows.

MATERIAL FROM TO MATERIAL GROUP

ABD 01/01/1995 12/31/2003 X

ABD 01/01/2004 12/31/9999 Y

Depending on what you have for the Keydate, the Material group is selected.

If your key date is, ex, 06/12/2001 there material group is X. Or if key date is 02/15/2005, material group is Y.

If you do not enter any value for keydate, system automatically assumes today' date.

santosh