Skip to Content
0

Nested Section with Input control

Apr 12 at 05:46 AM

54

avatar image

Hi,

Please can anyone tell me how to create nested sections for cascaded input control filter

I'm using 2 dimensions in sections: Main Section(Country), Subsection(Region)

Subsection contain tables, charts sections, and other types of object.

Cascaded input control filter is placed for Main section and Subsection.

When i filter single value in Main Section(Country) Input control it displays all Subsection(Region) in the report. I need to filter data only for selected values in Main section cascaded input control accordingly subsection gets displayed.

All input control should also work for cascaded input control filter

How do i do. Could you please help with an sample.

Thanks,

Dinya

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
Apr 12 at 02:48 PM
0

tree list input control you can use if your back end database SAP BW through BICS connection or UNX universe.it is not available for relation databases.

Or cascading input control is new feature from BI 4.2 SP03.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Amit,

Let me explain the reqd. I have created 2 sections with 2 different dimensions with same input control as attached

Main Section - Region dimension

Subsection - Country dimension

Subsection contain tables, charts , and other types of object.

Cascaded the input control Region and country when i select specific region\All regions in Region Radio button, it displays all countries in the Subsection that contain tables, charts and other types of object.

the issue is Subsection table is not filtered with selected region specific countries.

Cascading input control is not working for this nested Sections

Thanks,

Dinya


capture.jpg (27.1 kB)
0
Jyothirmayee A Apr 13 at 04:04 PM
0

Hi,

What is your BO version and source for the report?. if it is BO 4.1 then try using List tree

BO 4.2 had cascading option by grouping the dimesions.

Thanks,

Jothi

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Amit and Jothi,

Iam using BO 4.2 cascading option by grouping the dimensions.

I have created 2 sections with 2 different dimensions same object used as input control

Main Section - Region dimension

Subsection - Country dimension

Subsection contain tables, charts , and other types of object.

Cascaded the input control Region and country when i select specific region\All regions in Region Radio button, it displays all countries in the Subsection that contain tables, charts and other types of object in the report

the issue is Subsection is not filtered with selected region specific countries.

Appreciate your help in the report Subsection displaying all countires instead the selected region specific countries.

Thanks,

Dinya

capture.jpg (37.1 kB)
0

Hi,

Here are the steps I followed:

1. Created 2 input Controls on Country and Region

2. Created Group by selecting both Input Controls.

3. Have a table in Region section.

When I filter on Country, it do show me all the regions.

Can you share a screen shot of your Grouping and data?.

Thanks,

Jothi

0