Quarterly Reporting in BEX using variable

[Former Member]

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

[Former Member · Accepted solution]

I can see two possibilites .. either

1.Can be done from customer exit

2.Add Quarter to the target and retrieve from Date field / Month using below functions in formula (go for formula based on source time char's)

DATE_QUARTER Calculate Quarter from Date (YYYYMMDD -> YYYYQ)

MONTH_QUARTER Calculate Quarter from Month (YYYYMM-> YYYYQ)

[former_member242420]

Hi,

What MKR said is correct. Best way is to modify Infocube to add 0CALQUARTER and fill it based on your company FISCVAR...

vamsi.

[Former Member]

If possible, add 0CALQUARTER to your cube.

or

Create customer exit variables for Q1,Q2,Q3 and Q4 using calmonth.

[Former Member]

Hi - thank you for your response.

At this time, it is not feasible to add 0quarter to the cube.

I am looking into cmod but was hoping to be able to do it using variables/formulas.

Still invesitgating my options.

Thank you.

[Former Member]

Given your situation I think CMOD would be the only way. There are lot of pseudo codes on the forum that should get you started.

[Former Member]

Hi - thanks to everyone for their response....

All suggestions will work.

What I have currently done is to create a custom variable for "month 1"

It holds the january xxxx start.

I created selection in column using KF and "month 1";

January KF used month1 variable - offset 0

February KF used month 1 variable - offset +1

March KF used month1 variable - offset +2

etc

Created 3 forumulas

Qtr 1 = january kf selection + february KF selection + march KF selection

Qtr 2 = etc

Probably other ways as well....

This appeared to work without having to use CMOD since we can create queries in production and no transports were required.

Thanks for your input.

Lynda