Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

Im trying to create a portal in Designer and I love it. Ho...


ERIN TROTTER 3

Recommended Posts

Im trying to create a portal in Designer and I love it. However, the parameters dont seem to be chained together to where selecting the first parameter will filter what is available in the second parameter list. How do I get this to happen We are using 8.2.06 WebFocus Enterprise Editiion.

I found this in some documentation: WebFOCUS Designer chains controls automatically, if the parameters are defined in the metadata layer with the WITHIN keyword to relate them.

But I cannot find anything saying HOW to do that

Link to comment
Share on other sites

You can still do it in 8206 by something like this.

WHERE SALES_VIEW.SEG01_2.REGION EQ &REGION.(OR(FIND SALES_VIEW.SEG01_2.REGION IN SALESDEMO/SALES_VIEW |FORMAT=A100,SORT=ASCENDING)).REGION:.;

WHERE SALES_VIEW.SEG01_2.BRANCH EQ &BRANCH.(OR(FIND SALES_VIEW.SEG01_2.BRANCH IN SALESDEMO/SALES_VIEW |FORMAT=A100,SORT=ASCENDING ,WITHIN=REGION)).Branch:.;

WHERE SALES_VIEW.SEG01_2.ACTOWNER EQ &ACTOWNER.(OR(FIND SALES_VIEW.SEG01_2.ACTOWNER IN SALESDEMO/SALES_VIEW |FORMAT=A100,SORT=ASCENDING ,WITHIN=BRANCH)).Sales Rep:.;

This should create chained filters on the page, in the order REGION>BRANCH>Sales Rep

But, in 8207 at some release, there is a bi-directional chaining which is pretty cool!

Link to comment
Share on other sites

If all the chained fields are in the same synonym then create drill levels on the fields you are trying to chain.

If are no drill levels on the fields then they have a single blue dot seen in the InfoAssist interface.

 

1.PNG442516 64.6 KB

 

To add drill levels, open the synonym (Business View), choose the fields in the order you want to define levels. So, in the example, I choose COUNTRY, CAR and MODEL in that order and created Drill Level. In this interface, I wish there is a way to verify the drill levels graphically. Unfortunately, there is none.

 

2.PNG872675 119 KB

 

There are couple of ways to verify drill levels. One way is by looking at the synonym in the text editor. The other way is in the InfoAssist. The fields having drill levels are represented with blue dots incrementing based on the levels.

 

3.PNG842708 148 KB

 

In the example, I choose the fields having drill levels as dynamic parameters. When you create Portal page then the filters will appears as control and they are automatically chained.

 

4.PNG628553 26 KB

Link to comment
Share on other sites

  • 1 year later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...