cancel
Showing results for 
Search instead for 
Did you mean: 

How do I detach all queries in Workbook under 04s BEX?

Former Member
0 Kudos

BEx versions prior to 04s allows you to select Tools -> All Queries in the Workbook -> Detach

now however within 04s, its seems this functionality has disappeared?

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

...but when you delete the data provider, the data is removed as well. So, how can i break ties with the BW back-end...but keep the data? ..ie, what the old funcationlity of 'Detach Queries' used to do.

thanks so much for all the help

former_member563406
Active Participant
0 Kudos

Hi!

welcome to sdn.

in new work books we do not directly embed a query instead it works similar to the web templates in 3.x where we use tables which are linked to data providers. and editing data providers can be done in a single screen .. and thats makes changing the queries easier.

regards

mohan

Former Member
0 Kudos

hi Greg,

If you are trying to delete the query assignment in the workbook, then you have to switch to "Design Mode" and the click on the "Analysis Grid" and in "Analysis Grid Properties" window delete Data Provider.

Hope this helps.

Bhargava