Skip to Content
0
Former Member
Jul 22, 2008 at 09:28 AM

Convert 0calday to Fiscalyear/period and fiscal year in BI7

587 Views

Hello

I have to do a transformation in which i have to link 0calday to Fiscalyear/period and fiscal year. I have already introduced fiscal year variant. I looked into the formula buider to find out the formula but i am not able to get what values to enter in it.

for eg.

DATE_FISCPER Calculate Posting Period from Date(Year + Posting Period)

appears like this

DATE_FISCPER3( , )

Now what values will we have to enter. Second thing is that will it automatically convert the posting period according to the periods defined in the fiscal year variant.

Please can someone help.

Thanks