Question:
Hi,
Could someone tell me, is it possible to download the query result to text file from BEx query.
Right now I am running the query using BEx analyser, get the results in excel format and manually convert the output to text format(.txt).
But the requirement is to do the same automatically at the design level of the query or writing some macro some thing like that.
Thanks for the advise.
With warm regards
Balaji Srinivas P
Answer:
If your query is based on just one cube / ods then you can define a infospoke and schedule it to run on a daily basis ina process chain to create a file for you .
Not sure if you cando this in BEx if query is reading from multi cubes.
You can't use a multiprovider in a infospoke either.
ST