cancel
Showing results for 
Search instead for 
Did you mean: 

Virtual characteristics for MultiCube

Former Member
0 Kudos

How to use virtual characteristics in MultiCube? Here is the code I implemented but the query is not detecting user exit. I looked at query's tecnical information (rsrt) and there it shows that the query does not have any Virtual Char./Key Figures.

Virtual characteristic name is: SG_RCSSN used in SG_M_RC1 MultiCube. Data providers of MultiCube are InfoCube and ODS. I assigned virtual characteristic to a dimension, and did 'Identifications' ( --> InfoCube) for that characteristic.

PS. I did the same for basic InfoCube and it worked, but for MultiCube did not.

________________

Include ZXRSRU02

________________

DATA: L_S_CHANM TYPE RRKE_S_CHANM.

CASE I_S_RKB1D-INFOCUBE.

when 'SG_M_RC1'. "RCCP

l_s_chanm-mode = rrke_c_mode-read.

l_s_chanm-chanm = 'SG_ASGRP'. append l_s_chanm to e_t_chanm.

l_s_chanm-chanm = 'SG_SELUNT'. append l_s_chanm to e_t_chanm.

l_s_chanm-chanm = 'SG_FDF'. append l_s_chanm to e_t_chanm.

l_s_chanm-chanm = 'SG_SPR'. append l_s_chanm to e_t_chanm.

l_s_chanm-chanm = 'SG_RCSSAG'. append l_s_chanm to e_t_chanm.

l_s_chanm-mode = rrke_c_mode-no_selection.

l_s_chanm-chanm = 'SG_RCSSN'. append l_s_chanm to e_t_chanm.

ENDCASE.

________________

Include LXRSRTOP

________________

data: g_pos_SG_M_RC1_SG_ASGRP type i.

data: g_pos_SG_M_RC1_SG_SELUNT type i.

data: g_pos_SG_M_RC1_SG_FDF type i.

data: g_pos_SG_M_RC1_SG_SPR type i.

data: g_pos_SG_M_RC1_SG_RCSSAG type i.

data: g_pos_SG_M_RC1_0calyear type i.

data: g_pos_SG_M_RC1_SG_RCSSN type i.

________________

Include ZXRSRZZZ

________________

form user_SG_M_RC1 using i_s_rkb1d type rsr_s_rkb1d

changing c_s_data type any.

*tables: /BIC/QSG_RCSAGS.

field-symbols <l_SG_ASGRP>.

field-symbols <l_SG_SELUNT>.

field-symbols <l_SG_FDF>.

field-symbols <l_SG_SPR>.

field-symbols <l_0calyear>.

field-symbols <l_SG_RCSSAG>.

field-symbols <l_SG_RCSSN>.

break-point.

assign component g_pos_SG_M_RC1_SG_ASGRP

of structure c_s_data to <l_SG_ASGRP>.

assign component g_pos_SG_M_RC1_SG_SELUNT

of structure c_s_data to <l_SG_SELUNT>.

assign component g_pos_SG_M_RC1_SG_FDF

of structure c_s_data to <l_SG_FDF>.

assign component g_pos_SG_M_RC1_SG_SPR

of structure c_s_data to <l_SG_SPR>.

assign component 1

of structure c_s_data to <l_0calyear>.

assign component g_pos_SG_M_RC1_SG_RCSSAG

of structure c_s_data to <l_SG_RCSSAG>.

assign component g_pos_SG_M_RC1_SG_RCSSN

of structure c_s_data to <l_SG_RCSSN>.

zyear = <l_0calyear>.

concatenate zyear '0101' into zcalday.

select * from /BIC/QSG_RCSAGS

where /BIC/SG_ASGRP eq <l_SG_ASGRP>

and /BIC/SG_RCSAGS eq <l_SG_RCSSAG>

and /BIC/SG_SELUNT eq <l_SG_SELUNT>

and /BIC/SG_FDF eq <l_SG_FDF>

and /BIC/SG_SPR eq <l_SG_SPR>

and OBJVERS eq 'A'

and /BIC/SG_RCSSN ne ''

and DATETO ge zcalday

and DATEFROM le zcalday.

exit.

endselect.

if sy-subrc eq 0.

<l_SG_RCSSN> = /BIC/QSG_RCSAGS-/BIC/SG_RCSSN.

else.

<l_SG_RCSSN> = <l_SG_RCSSAG>.

endif.

endform.

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

hi,

do you have the query before without the virtual characteristics ?

try to check if the latest version of zxrsr* is active,

try to deactivate and activate the project (cmod),

rsrt and delete the query cache, and re-generate the query then check again the technical info.

Former Member
0 Kudos

Dear A.H.P,

thanks for the reply, I did all the steps you mentioned, but it still does not work. I have the query on MultiCube. Virtual characteristic is used in the query. Do you have any other idea?

I will be pleased for any proposals. Thanks in advance.

Former Member
0 Kudos

Thanks to all, now it is working. I did 'generate report' of the program in RSRT2 it worked. Before I was doing in RSRT.

Thanks.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

so your multicube is called 'SG_M_RC1', isn't it?

If yes, I would recommend to run the query in rsrt. Before running it, generate the query.

regards

Siggi