Day wise Analysis

[Former Member]

Hi Experts ,

Plese guide me in achiving the below reuirment.

Date Sales Sales for Previous month same day

01.06.2011 100 10(01.05.2011)

02.06.2011 200 20(02.05.2011)

03.06.2011 300 30(03.05.2011)

04.05.2011 400 40(04.05.2011)

05.06.2011 500 50(05.05.2011)

Date to be in rows.

Content in Bold need not be dispalyed.its given for just understandin purpose.

I am able to achive it but the problem is , It is dispalying the previous months date also in the Rowswhich actually i do not require.

Regards

Laxman

[sven_mader2]

Hi,

Do you want an monthly report, with day in the display?

1. create a non-keyfigure-structure with day (do you have this characteristic in your infocube?).

- numc2

- 31 selections: 1, 2, 3, ..., 30, 31

2. insert a variable for calmonth

3. create a customer-exit-variables for calmonth2 and calyear (do you have these characteristics in your infocube?)

4. insert the key figure sales in your query - two times.

- select the first key figure with the customer-exit-variables

- select the secondkey figure with the customer-exit-variables

Sven

[Former Member]

Hi Mader,

Thanks a lot for your response.

your are correct but not up to what i expect.

i need to analyse the data on daily basis for two months(curren and prevoius monhts).

I need to dispaly date(ddmmyyyy any format) but not DAY.

I understood your process ,but i do not know what is a non-keyfigure-structure?

[Former Member]

Hi,

A non KF structure is one in which only characteristics are used.

Create a structure based on 0CALDAY. Then create selections for each of the days. Now you can have this structure in your rows and the KF's in teh columns.

Reg,

Rahul

[Former Member]

hi rahul,

sorry for the late reply....

I got your point...but in this case my report wil become static not dynamic.....

am i correct..?

[Former Member]

Your buckets will be predefined. But teh data will fill up in the buckets dynimacally at runtuime.

Reg,

Rahul

[Former Member]

Hi ,

Thanks for your response.

But i think in this case my report will be static,means FI user enters input 15.06.2011 to 20.06.2011.

still it shows the output with 1 to 31 days in the rows but filled only for the given input rest as empty.

[Former Member]

Hi All,

Please help me..on this...

[Former Member]

Hi,

If your input variable is 0CALDAY, then create a variable based on 0CALDAY with Processing type as Customer Exit and write below code in your CMOD.....

CASE i_vnam.

WHEN 'ZVARIABLE'.

DATA :w_date TYPE dats.

is_range-sign = is_temp-sign.

is_range-opt = is_temp-opt.

MOVE is_temp-low TO w_date.

w_date(4) = w_date(4) - 1.

is_range-low = w_date.

APPEND is_range TO e_t_range.

ENDCASE.

This will give Last year same day for what ever variable you enter.

Put your 0CALDAY in rows and restrict your keyfigure with ZVARIABLE(Customer Exit Varaible).

Regards,

Vishnu.

[Former Member]

To achieve this, you can try creating a Virtual Keyfigure.

check this link for virtual keyfigures.

[http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/60e34f63-f44c-2c10-488e-c89b04e0ca7c?QuickLink=index&overridelayout=true]

--- Thanks...