Skip to Content
author's profile photo Former Member
Former Member

Virtual characteristics for MultiCube

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2005 at 01:39 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2005 at 03:20 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.