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?