on 05-22-2014 10:50 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Andre,
Did you tried creating in Webi Rich client?
Check your webi Modify preference is selected as RIA Applet.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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é
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.