All Forums Third Party Software
Innova 1 post Joined 06/10
28 Jun 2010
Table Metadata information for Hyperion

We are trying to read data from Teradata with Hyperion 8.5. The OCE is selecting records from DBC.COLUMNSX to find out the length of the columns. Since Hyperion is running this for the views, it is receiving a lot of NULL data for the column lengths. Much of the data is then being truncated in Hyperion.

Is there a way to change Hyperion to get the correct column sizes for views in Teradata?

TDobiee 9 posts Joined 07/09
07 Jul 2010

Can you turn off the use of X views in ODBC? On windows the setting is under "options". On unix the setting is "UseXViews = [Yes|No]"

You must sign in to leave a comment.