Ad Hoc Querying
I am looking into the tools available for ad hoc querying in BW 3.5 that do not utilize the Web interface. So far I have only been able to identify the Query Designer as an option. We are looking to have our superusers create ad hoc queries (possibly in production). Has anyone had success in accomplishing this, how did you implement? Thank you in advance!
Ad hoc query designer is available in BW3.5 only with web interface in WAD or in EP
To have superusers create there own queries you can give authorization for end users for respective cubes in BEx query designer such that only relevant cubes they can use to create the queries