cancel
Showing results for 
Search instead for 
Did you mean: 

Filtering the values in query

Former Member
0 Kudos

Hi gurus,

I need some help in building a query.

I trying a build a query on InfoCube, this cube has a field called rule name.

The Rule Name Infoobjet has both global and divisional data.

values of divisional rule name begins with SCG*, where as value for global rule name begins with SC and ends with 001 i.e. SC*001.

So in the query I only need only global rule names i.e. SC*001.

I want filter the field because I need Rule Name in variable input sreen and in default rows view.

Is there any mechanism where only global rules could be displayed. The divisional rules should not be displayed even in F4 input help screen of variable input.

My cube has records for both Global and Divisional Rules.

Thanks in Advance.

Subbu.

Accepted Solutions (1)

Accepted Solutions (1)

anshu_lilhori
Active Contributor
0 Kudos

Hi,

You can restrict the characteristic with that particular combination as you mentioned in your post.

What is the length of that object based on that you can detect the values on pattern

while restricting the characteristic choose option contains pattern

Check this doc as well

http://wiki.sdn.sap.com/wiki/display/BI/Customer+Exit+to+Restrict+a+Characteristic+with+Values+Conta...

Hope that helps.

Regards,

AL

Answers (2)

Answers (2)

kr_pavankumar
Contributor
0 Kudos

Hi Subba Reddy,

Try the below mentioned for pattern. If it doesnt work, follow the procedure as Anshu suggested.

Create a variable ZVARIABLE as follows:

Type of Variable: Characteristic Value.

Process By: Customer Exit.

Variable Represents: Selection Option.

Variable Entry is: Mandatory

WHEN 'ZVARIABLE'.

  IF I_STEP = 2.

  L_S_RANGE-LOW = 'SC*001'.

  L_S_RANGE-SIGN = 'E'.

  L_S_RANGE-OPT = 'CP'.

  APPEND L_S_RANGE TO E_T_RANGE.

ENDIF.

--------------------------------------------------------------------------------

FOR F4 help:

Make use of this BADI: 'RSR_VARIABLE_F4_RESTRICT_BADI"

Go thru the following links

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20ecb78c-374a-2d10-c6af-f024f19b7...

http://scn.sap.com/thread/2009070

http://scn.sap.com/thread/1208277

Hope it helps.

-- KRPK

anshu_lilhori
Active Contributor
0 Kudos

Hi,

For F4 help restriction refer the below doc.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/4009b0a8-7adc-2e10-48b3-a111c8f40...

It can also be restricted with the help of authorization on that particular infoobject if that is authorization relevant.

Liaise with security team to implement that approach.

Regards,

AL