Bex variable doubt

[Former Member]

Hi

I need to develop one report which shows data on weekly basis.Our client's week is typically from Thursday early morning(00:00:00 hrs) this week to wednesday late night next week(24:00:00 hrs)....but at present our reports are based on a manual input variable based on a characteristic called 'Prod Week' which takes values like Calendar Week(Monday early morning to next sunday late night)....I checked that 'prodweek' is based on reference characteristic 0CALWEEK......

I checked our cube...we donot have any OCALDAY ...we have only OCALMONTH,OCALYEAR,OCALQUARTER,ProdWeek as time characteristics....So how can I do so I can show reports based on week from Thursday early morning to next wednesday late night....?

(Do I need to change anything in architecture or is it enough just with customer exit variables on front end part)

Thanks for your guidance.

Regards.

[Former Member · Accepted solution]

Hi

My queries are based on a multiprovider.This multi is based on one 'Weekly cube' and one Monthly cube.My Multi contains 'CalDay' characteristics but they are from Monthly cube.As my query is a weekly data report,I have global filter on infoprovider restricting it to only weekly cube.......

[Former Member · Accepted solution]

In the weekly data InfoProvider which date InfoObjects are available? The transactions must be posted with some dates captured, for example posting date, transaction created date, start date, etc. You can use any object that stores the date relevance.

If you do not have any date objects of this sort, then I think you will need to create a new InfoObject for the customer week, e.g. ZWEEK. ZWEEK would start on Thursday and end on Wednesday and then you could map transactions to the relevant ZWEEK.

[Former Member]

Is there a date type InfoObject (e.g. posting date) available in the query which you can use as a reference? If so, customer exit variables will work fine.

WHEN 'ZV_LASTWEEK'.

Data: zfdcw TYPE datum.

CALL FUNCTION 'BWSO_DATE_GET_FIRST_WEEKDAY'
  EXPORTING
    date_in         = sy-datum
  IMPORTING
    date_out        = zfdcw
  EXCEPTIONS
    date_invalid    = 1
    others          = 2.
IF sy-subrc <> 0.
ENDIF.

CLEAR l_s_range.

zfdpw = zfdcw - 11.
l_s_range-low = zfdpw.
zldpw = zfdpw + 6.
l_s_range-high = zldpw.
l_s_range-sign = 'I'.
l_s_range-opt  = 'EQ'.

APPEND l_s_range TO e_t_range.