Highlighted
Absent Member.. Absent Member..
Absent Member..
895 views

Excel Report Query builder window in Analysis module

Hi,

 

I am trying to build a dashboard for my team using SQL queries, below are two questions I have:

 

- Is there a way to process PL/SQL queries in Excel Query Builder?

 

- How to use and declare Query Parameters in Excel Query Builder?

 

 

Thanks!

0 Likes
3 Replies
Highlighted
Established Member..
Established Member..

Hello,

 

Have you tried the Business views module ? It is an DQL editor that do wonders compared to the SQL Excel Editor.

 

Best regards,

Cédric Mabileau.

Highlighted
Valued Contributor.
Valued Contributor.

Hi,

 

- Is there a way to process PL/SQL queries in Excel Query Builder?

 

There is no way to process PL/SQL queries in excel query  Builder

 

- How to use and declare Query Parameters in Excel Query Builder?

 

New Query Parameter/Edit Query Parameter Dialog Box
This dialog box enables you to edit or create a new query parameter.

 

 

 

To access

1.In an Excel report, under the Configuration tab, click the Query tab, and then

click the Query Builder button.
2. In the Query Parameters tab, right-click and select New Parameter or Edit
Parameter.

 

 

 

you can also   can take a look at the ALM Admin Guide page 872

 

regards.

Highlighted
Absent Member.. Absent Member..
Absent Member..

Thank you for your responses.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.