cancel
Showing results for 
Search instead for 
Did you mean: 

How to make input controls cascaded

Former Member
0 Kudos

Hello,

I have such input controls and I have a requirement for making these input controls cascaded. I mean that whenever user selects Delivery than corresponding to the selection the DM values should come in the drop-down.

How to implement it?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Anuj,

Browse through this forum link.

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

and youtube link

http://www.youtube.com/watch?v=_1Qyb8X3ZeQ

Hope it helps.

Thanks

Gaurav

Former Member
0 Kudos

hi Gaurav Saxena

The video shared contains nothing it is of 11 sec only and the scn post is somewhat different scenario than mine.

Former Member
0 Kudos

Anuj,

I've not tried it but the only way that I can think of that would make it work is to use tables as input controls. Say you had a table with Continent and then the next with Country. You'd need:

Block1 contains the object [Continent]

Block2 countains the object [Country]

Create a variable to filter Block2 on so that you can set to hide when empty

Create your input filter on Block1 to filter Block2

Once you pick a continent, Block2 would show up with just that continent's countries.

Hope that works for your situation.

Regards,

Mark

Former Member
0 Kudos
Former Member
0 Kudos

yes Hardik,

I have seen both the posts but those doesn't fulfill my criteria

Former Member
0 Kudos

Hello Mark,

This solution might help me can you please elaborate it and provide me some formulas with examples for creating the variables.

Former Member
0 Kudos

Build your two blocks, one with just continent name, the other with country information

In your continent table, you would right click on it and define it as an input control. Follow the dialog through to filter the target block with the second level data.

Create a variable, Show Countries as

=If(Pos(ReportFilterSummary();"Continent Name Equal")>0;0;1)

(Note that Continent Name is the name of the object from block one

Now filter your country block where Show Countries Not Equal 1

Finally make sure that the Show When Empty tick is cleared for the block with the Country list.

You can then use this second block as an input control in the same way on the rest of your report.

If I spent any more time on this, I'd have to start charging you.

Former Member
0 Kudos

Hey Mark there is no such way to create input controls from blocks.

Former Member
0 Kudos

Ah, you must be on version 4.

Have a look at this:

http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_ia_en.pdf

Page 262

Former Member
0 Kudos

hi Mark,

I have followed that pdf and it creates an input control like this. I have 6 columns out of which I used one column as input ctrl.

How to proceed and fulfill my requirements?

Former Member
0 Kudos

I'm not sure on v4 but can you apply what I wrote about for XI3 to v4?

Former Member
0 Kudos

I am using Webi 4.0 SP6.

Former Member
0 Kudos

Yes but I'm on XI3 - try and adapt the basic things I wrote about to work on 4.0; I've not got access to 4 here so cannot tell you the exact way of doing it, but doing what I described will work.