RSRT Generate Query

[Former Member]

We are preparing to transport our queries to our Q box. My question is do we need to generate the queries in RSRT.

What does that Generate button actually do ?

[Former Member · Accepted solution]

Hi Richard,

You do not need to generate the queries as a pre-step to transporting them. Generate button will generate all the code behind the query. Sometimes this helps especially when you are testing a complex query definition as generating in RSRT would cut down on the front end processing time. Also sometimes a query may not execute in BEx and we usually use the Generate in RSRT as a means to validate that the query definition is okay and active.

Hope this helps...

[Former Member · Accepted solution]

Ok if we do generate them does that cause any problems.

[Former Member · Accepted solution]

No, it will not

[Former Member · Accepted solution]

Thanks !!!

[Former Member · Accepted solution]

Does it cause a problem if regenerated after transport to production?

[Former Member · Accepted solution]

You mean like you transported the query to Production and then in Production you regenerated in RSRT...No this will not be a problem either.