Export to Angles Business Views

Use this feature to convert existing .edq files from Spreadsheet Server Query Designer into business views in Angles Professional. Once converted, these views can be used in dashboards, enabling immediate value for Spreadsheet Server users seeking web-based visualization tools.

Prerequisites

• Spreadsheet Server must be version 25.2 or later.

• Spreadsheet Server and Angles Professional must be installed.

• Both products must be deployed on the Platform.

• Spreadsheet Server and Angles Professional must each have their own separate connection to the same data source. This integration does not rely on data sharing or ODBF.

Note: SPARMS are not supported in Angles Professional. Literal values are passed instead.

Convert Query Designer Queries to Angles Professional Business Views

1. Open Query Designer. A new button appears for launching Angles Professional, along with checkboxes next to each query and a counter showing how many queries are selected.

2. Select one or more queries from any folder or the root. All selected queries must share a common connection.

   

   

3. In the upper-right corner, open the dropdown labeled Selected. Choose either to delete the selected .edq files or to send them to Angles.

   

4. When sending queries to Angles, a dialog displays the selected items. Select the appropriate Angles Professional connection and click Send.

   

5. A progress bar shows the status of the operation, including successful and failed submissions.

   

6. Open Angles Professional, search for the new business views, and test them to confirm successful conversion.

   

   

Handling Updates to Queries

When a query is modified in Query Designer and sent again to Angles Professional:

• Choose to overwrite the existing business view or create a duplicate.

• Select Do this automatically for queries like this from now on to apply the same action in future cases.

  

• Duplicates are named with a suffix, such as (1).

  

SQL Translation Example

Original Query Designer SQL:

SELECT DISTINCT Viewpoint.dbo.JCCD.JCCo, Viewpoint.dbo.JCCD.Job AS Job, Viewpoint.dbo.JCCD.Mth AS [Month],

Viewpoint.dbo.JCCD.Vendor AS Vendor, Viewpoint.dbo.APVM.Name AS [Vendor Name], Viewpoint.dbo.JCCD.APRef

FROM ( Viewpoint.dbo.JCCD

INNER JOIN Viewpoint.dbo.JCJM ON ( Viewpoint.dbo.JCCD.JCCo = Viewpoint.dbo.JCJM.JCCo )

AND ( Viewpoint.dbo.JCCD.Job = Viewpoint.dbo.JCJM.Job ) )

INNER JOIN Viewpoint.dbo.APVM ON ( Viewpoint.dbo.JCCD.Vendor = Viewpoint.dbo.APVM.Vendor )

WHERE ((Viewpoint.dbo.JCCD.JCCo  &SPARM01 ) AND (Viewpoint.dbo.JCCD.Job &SPARM02)

AND (Viewpoint.dbo.JCCD.Mth &SPARM05) AND (Viewpoint.dbo.JCCD.Vendor &SPARM07)

AND (Viewpoint.dbo.APVM.Name &SPARM08))

Converted Angles Professional Business View:

SELECT DISTINCT Viewpoint.dbo.JCCD.JCCo, Viewpoint.dbo.JCCD.Job AS Job, Viewpoint.dbo.JCCD.Mth AS [Month],

Viewpoint.dbo.JCCD.Vendor AS Vendor, Viewpoint.dbo.APVM.Name AS [Vendor Name], Viewpoint.dbo.JCCD.APRef

FROM ( Viewpoint.dbo.JCCD

INNER JOIN Viewpoint.dbo.JCJM ON ( Viewpoint.dbo.JCCD.JCCo = Viewpoint.dbo.JCJM.JCCo )

AND ( Viewpoint.dbo.JCCD.Job = Viewpoint.dbo.JCJM.Job ) )

INNER JOIN Viewpoint.dbo.APVM ON ( Viewpoint.dbo.JCCD.Vendor = Viewpoint.dbo.APVM.Vendor )

WHERE (((Viewpoint.dbo.JCCD.JCCo = '1')) AND ((Viewpoint.dbo.JCCD.Job = '15619-00'))

AND (Viewpoint.dbo.JCCD.Mth = Viewpoint.dbo.JCCD.Mth OR Viewpoint.dbo.JCCD.Mth IS NULL)

AND (Viewpoint.dbo.JCCD.Vendor = Viewpoint.dbo.JCCD.Vendor OR Viewpoint.dbo.JCCD.Vendor IS NULL)

AND (Viewpoint.dbo.APVM.Name = Viewpoint.dbo.APVM.Name OR Viewpoint.dbo.APVM.Name IS NULL))