Skip to Content
0
Former Member
Aug 23, 2011 at 01:33 PM

Displaying data of query based on 0CALDAY

16 Views

Hi Experts,

In Query designer, I am giving Calender day(0CALDAY) as an input to the query developed on 0IC_C03. the variable used for the same is 0P_CSDAT, which is single input date.

In rows, I am having Calendear Day(0CALDAY), Plane and Material. In Columns, I am having Opening and Closing Stock.

I wish to display the output of the query for only the date(e.g. 01.01.2011) I have given as an input. But as in Columns I am having Opening Stock(i.e. closing stock of previous day i.e. 31.12.2010), I am giving an offset of one day to 0CALDAY to Closing stock KF that is directly available in cube. The opening stock KF is not directly available in cube.

The data in the report is being shown for 31.12.2010 as well as 01.01.2011.

The data is coming correct but, I want to have it only for 01.01.2011 date I have given as an input. I am not getting any option in Query Designer.

Can anyone please help out at the earliest ???? Its urgent..

Thanks in Advance.

Regards,

Romil

Edited by: romil02 on Aug 23, 2011 3:34 PM

Edited by: romil02 on Aug 23, 2011 3:35 PM