Making different time infoobject available in infocube

[Former Member]

Hi gurus,

I have only the infoobject 0CALMONTH available in infocube. Coming from data source into DSO and to infocube (everything mapped and works fine).

What do I have to do when in infocube the following time infoobjects are needed but only 0CALMONTH is available?:

0CALQUARTER

0CALYEAR

0FISCPER3

0FISCYEAR.

Is this only a mapping issue from DSO 0CALMONTH to the needed and mentioned infoobjects in infocube?

Thanks in advance for your help!

[former_member266802 · Accepted solution]

the values for 0CALYEAR and 0CALQUARTER can be derived directly from 0CALMONTH.

0FISCPER3 and 0FISCYEAR may cause a bigger challenge. If the beginning and end of the fiscal period and calendar month are not aligned exactly, you need 0CALDAY in order to derive the values for fiscal period and fiscal year. On the other side you can check whether your data source provides the fiscal period. Then you can take the values directly from there.

From a technical standpoint you have to add the additional time characteristics to the time dimension of the info cube and provide the update logic in the update rule or transformation. The system will do the transformation between calendar day and fiscal period automatically, if the fiscal year variant is available in the source data and the settings for the fiscal year variant have been replicated from the source system into BW,

h

[Former Member · Accepted solution]

Thanks a lot!

Im using SAP BI 7.0 and mapping tranformation between the objects.

Calendar day or more time fields are not available in data source. Only the month with year which is used for 0CALMONTH in DSO.

The 0FISCPER and 0FISCVARNT are available in DSO.

Why do I need the 0CALDAY?

Question: from my understanding if the data would be on a daily basis then the system could do all necessary calculations automatically. That means, it would be possible to determine the month, fiscvarnt, calyear and so on.

Is my understanding correct?

[former_member266802 · Accepted solution]

The question is how do you populate the Fiscal Year Variant (0FISCVARNT) and the Fiscal Period (0FISCPER) in the the DSO?

If your company uses fiscal periods that are not exactly aligned with the calendar month, then it is impossible to derive the fiscal period from the calendar month. You need to check with accounting!

If both don't align, you will have to enhace the extractor. You can add the calendar day (most likely a posting date) or you add the fiscal period and fiscal year variant to the extractor,

h

[Former Member · Accepted solution]

In DSO:

0FISCVARNT is constant V9.

0FISCPER is initial.

0CALMONTH comes from data source.

The fiscal period is not exactly aligned with the calendar month.

In infocube we determine the

0FISCVARNT with direct mapping of DSO.

0FISCPER with a routine (mapped with 0CALMONTH and 0FISCVARNT of DSO).

0CALMONTH with direct mapping of DSO.

It works that way, in the query we are using the 0FISCPER as a variable in selection mask for displaying the month and the aligned period.

[former_member188080 · Accepted solution]

Hi,

From calmonth u can have direct mapping to calyear and calquart so it will derive the values automatically through internal routines..

also U CAN DERIVE FISCPERIOD by adding leading zero ok..

0FISCVARIANT u can map as constant as mentioned above..by you value V9

Thanks and regards

Kiran