How to convert Time Char,

[Former Member]

Experts,

WE have created all different kind of reports by using 0fiscper. Now i have a requirement of showing those in Quaters.

So, how do i convert those ?

Is there any where we maintain Quaters ? OR do i need to create a time char. ( QuaterS) i am not famillier with that,

Can anybody tell me the solution.

Currently, if user wants 1st quater, then we run the report and take out the months which are not falling in that quater.

So basically, user can have SALE for Jan-feb-march and its called Q1. But no where in the coulmn it says Q1.

What is the best way of doing that.

Thanks a lot

[Former Member]

Hi There,

Calendar quarters have a business content time characteristic 0CALQUARTER.

0CALQUARTER can be devired from 0CALDAY or Dates using standard functionality.

Try using fuction module LAST_DAY_IN_PERIOD_GET to derive the last day of the fiscal period, then using standard functionality to derive the Calendar quarter.

If you have Fiscal Quarters, your have following options:

1) Create a hierarchy on 0FICSPER of Fiscal Quarters

2) Create a custom InfoObject ZFISCQTR for Fiscal Quarter, add as attribute of 0FISCPER. Make is a navigation attribute of 0FISCPER or perform a master data look up and store in a Dimension. (Only "official" time characteristics can be added to the Time dimension.)

let me know if this helped!

John Hawk

[Former Member]

Hey john,

Thanks a lot for your reply. But i still need some more information. As i am new to this .

when u say that 0CALQUARTER can be devired from 0CALDAY, does it mean in the query ?

or can i create an infoobject, which has quaters Masterdata, and in the query when i pull it , all the data gets arraged by quarters.

also, u mentation that i can use fuction module LAST_DAY_IN_PERIOD_GET, But where do i have to useit ? in the query ? does it calculate Runtime? if thats the case then there will be Performance issue..right ?

please let me know

thanks a lot