In Bex Query day from calday value and sales in prev yr value not come

[former_member182040]

Dear all

right now i got output like

								                                    Sales		               Sales in Prev Yr	
Sales Organization	    Day From Calday		Calendar Day	   Sales Value	              Sales Value		
1020			   Not assigned		05/1/2010			                     2,013,176.00 INR			
1020			   Not assigned	       05/1/2011	           2,945.00 INR										

and i want output like base on date 05/01 how to do pl help

Sales Organization	    Day From Calday		Calendar Day	   Sales Value	              Sales Value		
1020			       05/01	  	          05/1/2010	   2,945.00 INR		     2,013,176.00 INR			
						

[former_member182040]

Thanks to all who help me well i solve my issue using Virtual Key Figures (KF)/ Characteristics (RSR_OLAP_BADI)

[Former Member]

Hi,

Remove calender day from the output as it doesn't make any sense showing sales of a particular day for curr year and prev year against calday for prev year.

Derive 'day from calday' at backend in the transformation routines based on calendat day.

In the report create two selections, restrict sales value with current year (exit variable available on calyear) for one selection and restrict sales value with curryear-1 offset for the second selection.

Then your report would show...for a sales org on a particular day of a month, the sales made in current year and prev year.

[Former Member]

Hi,

Agree with Murli.

If you add 'Calday', the rows will obviously split.

And for the '05/01', Need to add a new characteristic 'ZCALDAY1' (CHAR 5). Which is populated by routine,

CONCATENATE CALDAY6(2) '/' CALDAY4(2) INTO RESULT.

Needless to say this will exhibit any time char properties.

[former_member182040]

i create two date using formula variable and use offset now i try to display so i wrtie in formula like

'DAY' / 'MONTH'

SO it not display proper value actually i have to display '/' SIGN BUT in formula it division . how to display sign '/'

Edited by: Krupaji on May 28, 2011 8:25 AM

[Former Member]

hi,

In your cube you have a row with a different calday along with a value.

To assign the value of 2,945.00 INR for calday 05/1/2011 to 05/1/2010 is incorrect as shown by you in the desired output. If it is previous year value then you need to write a routine in the cube to get this populated with the logic which will work for all the records and not only for the example provided by you.

regards,

Arvind.

[former_member182040]

above output which i want its base on day and month not year

[Former Member]

Hi ,

This is possible via customer exit.You can populate day on the bases of your date .

Try this :

WHEN 'tech name of exit var'.

data : v_day type c length 5 ,

v_day_val type c length 5.

IF i_step = 2.

READ TABLE i_t_var_range INTO LS_T_VAR_RANGE WITH KEY vnam = 'date_value u2019.

v_day = LS_T_VAR_RANGE-high+4(4).

concatenate v_day+2(2) '/' v_day(2) into v_day_val .

ls_range-low = v_day_val .

ls_range-opt = 'EQ'.

ls_range-sign = 'I'.

APPEND ls_range TO e_t_range.

Hope this will be helpful .

Regards,

Jaya

[former_member182040]

Hi Jaya

I doing same as u told but data not comming

[Former Member]

Hi,

The data output is based on infoprovider model and data in it.Can you give your model?

I.e

1. Is it based on Multiprovider

2.Which Cube has what data

3.Is it ok for you to move it to another provider? etc

Thanks and Regards,

MuraliManohar.

[former_member182040]

it is based on Multiprovider