Skip to Content
avatar image
Former Member

Webi input control based on field value belonging to multiple groups

Hi,

I have a general question I hope someone can assist with. I am using SAP BO 4.1 sp5 / oracle 12 and webi report. My question is in regards to webi Input control, I would like to filter on the field values based on a grouping criteria, please see how the accounts field is stored below in oracle:

Accounts

---------

A1

A2

A3

B2

B5

C7

C8

D

E2

F5

G1

G2

H

I

J

The Accounts field should be firstly grouped based on the criteria

1) All Accounts in (A1,A2,A3,B2,B5,C7,C8,D,E2,F5,G1,G2,H,I,J)

2) Accounts North in (A1,A2,A3,B2,B5)

3) Accounts South in (C7,C8,D,E2,F5)

4) Accounts East in (G1,G2,H)

5) Accounts West in (I,J)

I would like to display in input control the values to choose from All Accounts, Accounts North, Accounts South, Accounts East and Accounts West.

Is this something I can achieve in BO IDT?

Thank you,

Khawer

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers