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

Custom Time Dimension with half year

Does anybody have a sample time.xls file for SAP BPC v5.1 SP2 that can support four levels per Year ?

Some other requirements include: We need the YTD and QTD measures to work without customization if at all possible. We would also like to keep this in a single parent. We would rather not use dimension formulas in our Time dimension.

The levels we need

MONTH (base) rolling into

QUARTER rolling into

HALF YEAR rolling into

YEAR

We actually have this working in v4.2 / SSAS 2000 but our workaround does not work in SAP BPC v5.1 / SSAS 2005

Thanks!

Mark

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Apr 24, 2008 at 03:07 AM

    There are no work arounds or special measures required. It would be setup in 5.x the same a it would (should) have been in 4.2:

    ID                | PARENTH1   | LEVEL

    2007.Total    |                     |TOTAL

    2007.H1       | 2007.TOTAL  |YEAR

    2007.Q1       | 2007.H1       |QUARTER

    2007.JAN     | 2007.Q1       |MONTH

    2007.FEB     | 2007.Q1       |MONTH

    2007.MAR    | 2007.Q1        |MONTH

    The YTD measure works across all members. The QTD (same for MTD in a weekly app) doesn't show up on the half-year members which makes sense because half year spans across multiple members of these levels so the resets wouldn't make sense. I have seen this customized to make the QTD value be the 6 month sum and the MTD value be the same but again the concept doesn't really fit. It's more a personal preference on display.

    HTH

    James

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      James...thanks for your comments and I am trying those out in SAP BPC 5.1 SP2 soon SP3. I will post results but the good news is the dimension validated with your recommendations.

      Around v4.2 (admin build 4.2.4098) we did create a workaround becase we found that we could not validate (using View member report) without errors a time dimension with properties at levels below. The view member report would not finish and highlight "total" in red within seconds of validating.

      Our workaround was to hold YEAR at the 2007.TOTAL level and to hold level DAY at the half year level and that validated.

      Again we could NOT get your recommended structure to validate in v4.2 (view member report) but we can now in SAP BPC and I am testing the results.

      ID | PARENTH1 | LEVEL

      2007.Total | |TOTAL

      2007.H1 | 2007.TOTAL |YEAR

      2007.Q1 | 2007.H1 |QUARTER

      2007.JAN | 2007.Q1 |MONTH

      2007.FEB | 2007.Q1 |MONTH

      2007.MAR | 2007.Q1 |MONTH

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.