Skip to Content
0
Former Member
Sep 07, 2010 at 03:59 PM

Quarterly Reporting in BEX using variable

447 Views

Hi,

I have seen several postings for quarterly reporting but I dont think they resolve my issue.

There is an existing report - Purchase Order Summary by Material.

The user wants it by quarter instead of cal month/year which he is currently receiving.

I only see variable for current quarter and prev quarter.

Loaded to the cube are the following time characteristics;

0calday

0calmonth

0calweek

ocalyear

0fiscper

0fiscvarnt

I would like to not have to use CMOD if possible.

The two reported key figures per month are gr value and gr qty.

I just created a custom variable for month1 (01/2010) and I can create offsets for each month and then formulas to capture qtr1, qtr2, qtr3 and qtr4 but I am thinking there might be a better and more efficient way.

Report currently comes out as;

material plant vendor gr value 01/2010 gr qty 01/2010 gr value 02/2010 gr qty 02/2010 etc

I would like;

material plant vendor gr value qtr1 gr qty qtr1 gr value qtr2 gr qty qtr2 etc

Thanks for any help you can provide.

Lynda