on 07-01-2015 6:57 PM
Dear Community:
As I haven't found a work around for the large Excel Exports from the Portal, I'm wondering if somebody could share
an example of you they have used openhub as a way to Export Query results.
I'm thinking of running the Query once a month to populate the openhub to generate a csv file.
How do we modify the Query Variables when it's run like this? Do we use a variant approach similar to the old
Bex Broadcaster? I'm thinking it would be nice to import the csv file into another process to generate an Excel
File once the csv was created by the openhub. Has anybody done this? I'm thinking it could be done on a windows server.
Thanks for your consideration.
Hello Chris,
I extract the following information from SAP Note 1860872:
I believe that is your scenario
You want to extract data:
Best Regards,
Edward
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Just use ANALYSIS PROCESS DESIGNER (APD) instead of openhub..The former is faster..
About your conversion from CSV to EXCEL, it is not possible IF the number of rows exceeds the maximum number of rows of your MS EXCEL which is 1,048,000+ rows..
Regards,
Loed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.