Create BIP report with Dependent Parameters

Create BIP report with Dependent Parameters

In this section, we will see how to create BIP report with dependent parameters in fusion.

Let us create sample BIP report with two parameters:

Navigation—->

Tools—>Reports and Analytics

Graphical user interface, application

Description automatically generated

Go to Browse Catalog—>New —–>Data Model.

Graphical user interface, application

Description automatically generated

Create SQL Query to create Data Model.

Go to Diagram—->SQL Query.

Graphical user interface, application, Word

Description automatically generated

Give Name, Data Source and Type of SQL as shown below:

Graphical user interface, text

Description automatically generated

As we have used two bind variables, automatically it will ask to create two parameters for Data model as shown below:

Graphical user interface, text, application

Description automatically generated

Let us create and configure these two parameters as shown below:

Graphical user interface, text, application, email

Description automatically generated

Now next we will create list of values for these two parameters.

Go to List of Values and Click on Create icon as shown:

Graphical user interface, text, application, email

Description automatically generated

For P_VENDOR_NUM Parameter:

Graphical user interface, text, application, email

Description automatically generated

For P_VENDOR_SITE_CODE Parameter:

Here we need to refer P_VENDOR_NUM value selected in first parameter to create dependent list of values on first parameter.

Graphical user interface, text, application, email

Description automatically generated

Attach value set to respective parameters:

Graphical user interface, text, application, email

Description automatically generated

Graphical user interface, text, application, email

Description automatically generated

Save the DM.

Graphical user interface, text, application, email

Description automatically generated

Graphical user interface, text, application, email

Description automatically generated

Run the DM.

Graphical user interface, application

Description automatically generated

Graphical user interface, text, application, email

Description automatically generated

Now let us select Vendor Number as 100004 and it will show respective vendor Site code.

Graphical user interface, text, application

Description automatically generated

In this way, we can create dependent parameters in BIP report.

Leave a Reply

Your email address will not be published. Required fields are marked *

Back To Top