Skip to Content
author's profile photo Former Member
Former Member

Making different time infoobject available in infocube

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!

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jun 04, 2012 at 01:04 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.