Loading Profile...
Can I control the column width for table created for drill-through results?
I am using MySQL for source data and drill-through tables. The table created automatically for drill-through uses varchar(400) for all string fields. This is a problem when many (150+) columns are profiled because the row size of drill-through table created in MySQL table would exceed the MySQL limit. Where is the default varchar(400) specified and can I change it?
Thanks.
Help get this topic noticed by sharing it on
Twitter,
Facebook, or email.
Twitter,
Facebook, or email.
I’m
frustrated
Drillthrough table created exceeds MySQL row size limit
-
Hi Steve,
the value is hardcoded and sadly cannot be changed. The only option I can offer you, would be to split the table (in case there are no dependencies between the columns) in 2 profiles with 100 columns. Though imperfect solution, it might help.
Let me know if that would help you.Comment -
-
-
EMPLOYEE
