Adding derived table to-Universe issue!

[Former Member]

Hi,

I am trying to add a derived table to my Universe by writing a SQL query, after some length of the query its not enabling me to write more.Could soemebody suggest is there any limit I can write upto or is there anyway I can increase the capacity of the length of the query.Thanks in Advance.

[Former Member · Accepted solution]

How big is your query. I think there is a limit based on the edit box of about 32k but that is all

It is possible to create derived tables based on other derived table using the @DerivedTable function. You might be able to break your query into smaller parts and build it that way

Regards

Alan

[Former Member · Accepted solution]

II have checked back and the total query size is 30k.As per your answer total query should fit into that where as its not gonig after about 90% the total query I have written.

Can you tell me what is the exact limit of the query in edit box?

[Former Member · Accepted solution]

Hi Jaspal,

I check the dialog box and you can enter 28k of data.

Regards

Alan

[Former Member · Accepted solution]

Thanks for the Info. Now I will check back my query and try to tune it to reduce the size.My query size was 30k so that could be the reason it not allowng me to write more than 28k.