Table Metadata information for Hyperion

Third Party Software
N/A

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?
1 REPLY
Teradata Employee

Re: Table Metadata information for Hyperion

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]"