Data load crash & Cross Tab

[Anonymous]

Hi Friends,

- My Table capacity 20 Col and 22,00,000

I have to create a table view (cross Tab, Table View) with

104 Col, 13000 rows,

Could you please tell me can i do it??? Currently I'm not able to load the data load.

[sunny_talwar]

May be using The Generic Load

[jonathandienst]

Aside from the fact that this would be an extremely wide and unwieldy table at 104 columns, what are you not sure about?

Are the columns based on a dimension or on expressions? If you have 104 expression, I sincerely hope you have carefully profiled the expressions to make sure they are optimized,

[Anonymous]

I have  104 coloms as week No's its my dimension...
And I have 99 if else expressions for one measure which i have used in the cross tab view