Drill Down Problem on Report Designer

From Sage Intelligence Knowledgebase
Jump to: navigation, search

Products

Sage X3

Description

Users of Sage X3 Intelligence Reporting would not be able drill down to transactions for analytical and financial formulae. The following error is returned when attempting to drill down to transactions:

DESCRIPTION
DESCRIPTION

Cause

The following reports are not available in report manager to facilitate transaction drill downs. Connector does not contain SQL logic to facilitate transactional drill downs.

•Report Designer - GL Drill Analytical SX3 1-1

•Report Designer - GL Drill Financial SX3 1-1


Resolution

Import the below reports (also attached) into report manager and thereafter attempt to drill down to transactions.

•Report Designer - GL Drill Analytical SX3 1-1

•Report Designer - GL Drill Financial SX3 1-1


ftp://SoftDownloads@ftp.alchemex.org/Hotfixes/Report%20Designer%20GL%20Drill.zip