EDITTING QUERIES RELATED TO QUERY TABLE

[Yuvraj]

My excel templates are attached to cube.

But I see no way in which i can see the queries or modify the queries.
Please tell me a way where we can modify the queries related to a
query table.

When I go to the Data, Import wizard I see the edit query as
disabled.

I am not knowing how it is attached and how to edit the queries for an
existing excel template.

Please guide.

Regards,

Prince

 

[joel]

Yu have to select any cell where the result of the query is placed and then
go to Edit Query for it to be enabled. the SQL button we let you change the
query. Yo can't change the connection. If you need to change the connection
I will give you the steps. Basically you need to create a new qury and then
copy the SQL statements fro an old query to the new query.