Skip to Content
avatar image
Ankit Vaidya

How to create quarter variable...?

Nov 10, 2016 at 10:17 AM | 52 Views

Hey Experts,

I am stuck in my webi report. Please help me.

My requirement is I have MONTHS variable out of which I have created Quarter variable which I achieved through IF formula. Now in table I am using measure called Avg(Qty) in Months column value is coming proper but same measure if I am using in Quarter variable I am not getting expected value, though its showing but not logically.

screenshot is placed below:

Quarter is being considered by Fiscal Year.

Even I tried using formula : Avg(Qty)ForEach([Months] ) or other diimensions too.like Zone , RO, Div, Fiscal Year.

screenshot.png (10.9 kB)
SAP Knowledge Acceleration, version for SAP BusinessObjects Web Intelligence
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Nov 10, 2016 at 11:46 AM

    Hello Ankit,

    can you please explain issue in detail with some more detailed example.

    This will help me provide solution :)

    Regards,

    Sushil Padhye

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 16, 2016 at 05:15 PM

    Hi Ankit

    Try to create Quarter with the help of "group" feature as mentioned in below link and perform the operations, check if it helps.

    https://archive.sap.com/documents/docs/DOC-49932

    http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/f0af8996-333f-3110-55a1-ec9774bd3b36&overridelayout=true

    This feature is introduced in SAP BO 4.1 sp2

    Regards

    Venkatesh

    Add comment
    10|10000 characters needed characters exceeded