Hyperion Intelligence - Teradata Macro Is Not Returning Any Results When Executed via Hyperion Interactive Reporting Studio

(Doc ID 746072.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Hyperion BI+ - Version: 9.2.0.2.00 and later   [Release: 9.2 and later ]
Microsoft Windows (32-bit)
Microsoft Windows 2003

Symptoms

A Teradata macro is imported into Interactive Reporting Studio.  This macro makes a call to a Teradata stored procedure. When the query is processed, no results are obtained and no error message is displayed. The same macro works fine when run via Teradata SQL Assistant query tool.

This is the macro:
REPLACE MACRO test.abc (
p_user DECIMAL(18,0)
) AS
(
CALL test.pr_abc(:p_user);
);

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms