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

How to convert Time Char,

Posted on Oct 06, 2010 at 08:24 PM 11 Views

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 06, 2010 at 11:32 PM
    0

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Oct 07, 2010 at 04:29 PM

      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

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.