The window to select dimensions simply does not appear and I can't move forward, due to variables exit in the report

[Former Member]

Dear experts,

I am having an issue when I try to create a WEBI document using Bex query through OLAP connection (Bics).

Due to variables exit, it is not possible to open query pannel in webi to choose wich dimensions to add to the webi document.

The window to select dimensions simply does not appear and I can't move forward!

In RSRT ou Bex Analyzer, the query is running fine without errors.

CMOD code is like this (I believe there is not any error as it is working flawless on other reports for other variable names):

WHEN 'ZREDT1'.

     IF i_step = 2.

       CLEAR wa2.

       READ TABLE i_t_var_range INTO wa2 WITH KEY vnam = 'ZRE_DT_IN'.

*      wa2-low = |{ v_year_h }12|.

       IF sy-subrc EQ 0.

         v_year_h = wa2-low(4) - 1.

         CONCATENATE v_year_h '12' INTO wa1-low.

*        wa1-low = wa2-low.

         wa1-opt  = 'EQ'.

         wa1-sign = 'I'.

         APPEND wa1 TO e_t_range.

       ENDIF.

     ENDIF.

    WHEN 'ZREDT2'.

     IF i_step = 2.

       CLEAR wa2.

       READ TABLE i_t_var_range INTO wa2 WITH KEY vnam = 'ZRE_DT_IN'.

       IF sy-subrc EQ 0.

*        wa2-low = |{ v_year_h }12|.

         v_year_h = wa2-low(4) - 1.

         CONCATENATE v_year_h '12' INTO wa1-low.

         wa1-opt  = 'EQ'.

         wa1-sign = 'I'.

         APPEND wa1 TO e_t_range.

       ENDIF.

     ENDIF.

Please provide assistance,

Thanks in advance,

Kind regards,

André Oliveira

[Former Member]

I solved it.

The problem was due to date coming to exit - as you know some time intervals start at 01-01-1000, and as I was calculating 1000-1 = 999

I was getting and interval from 99901 to 201405. Do not know if it was not working because CHAR NUMC6 was failing trying to recognize interval 99901 - 201405, but probably, this was the issue.

Thanks for your inputs,

Best regards,

André Oliveira

[LepreuxLoic]

Hi,

Which version of BOE are you using ?

Do you receive any error message at all, or is there an error logged in WebI trace file when it fails ?

Regards,

Loic

[Former Member]

Hi Loic,

I am doing the trace.

BO is 4.0 sp8.1

Regards,

Andre

[sateesh_kumar1]

Hi Andre,

Did you tried creating in Webi Rich client?

Check your webi Modify preference is selected as RIA Applet.

[Former Member]

Hi Kumar,

Rich client works the same, also tried other ie browsers with no other result.

Can you specify better that last suggestion?

KR,

André Oliveira

[sateesh_kumar1]

Hi Andre,

Clear default values of the variables in BEx if any.

is this issue is specific to any query /with all queries ?

[Former Member]

Hi,

There are no default values.

This is query specific, sometimes some exit variables do not work. If i remove variable exits from query, then it will work ok, but I need the restrictions provided from exit variables.

I have similar queries with the same text in CMOD for the variable and they do work.

Do not know why it is not working this time.

Regards,

André