EDITTING QUERIES RELATED TO QUERY TABLE
 

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

EDITTING QUERIES RELATED TO QUERY TABLE
 

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.

"Yuvraj" wrote:

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