cancel
Showing results for 
Search instead for 
Did you mean: 

Webi input control based on field value belonging to multiple groups

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (0)