Question:
How can I download BW query output into the flat file?
How can I schedule the download of BW query into the flat file and then upload it into the ODS? I need to schedule it. Is there any way for BW query output?
Thanks,
Amey5
Answer:
Hii Amey5 ,
its possible , follow these steps :-
1. Check the settings from your Internet Browser. Call
Internet Options from the Tools menu.
2. Mark “Local Intranet” in the “Security” area and
press “Custom Level…”.
3. open the web template & paste this code :-
<SCRIPT LANGUAGE="JScript"> function bringToExcel() {this.document.execCommand("SelectAll", false); this.document.execCommand("Copy", true); this.document.execCommand("UnSelect", false); // Start Excel and get Application object. var oXL = new ActiveXObject
("Excel.Application"); oXL.Visible = true; // Get a new
workbook. var oWB = oXL.Workbooks.Add(); var oSheet = oWB.ActiveSheet; oSheet.Paste(); oXL.Visible = true; oXL.UserControl = true;} </script>
4. Add the follwing coding for the button to your template:
<input type=button value="Download to Excel" onClick="bringToExcel()">
5. After that U can save it in .csv format and then upload to
any ODS & Info cube .
I hope it will click , if not U can leave ur message here , I will
try to find another way .
Good Luck !
Answer:
You are taking data from a data target in BW via a query, going to a flat file, and then re-importing into another data target in BW?
Can't you create a generic extractor to grab the records from the data target your query is based on and load the data directly into the ODS you would load the flat file too?
Seems to me that it is a little in-efficient to take data in BW - bring it outside - and the back into BW when you could cut out the middle step.
Is there a requirement that is missing?
Answer:
You could try using RSCRM_BAPI to save the query results to a table.
Then create a generic extractor in BW.
THere is a How to paper on this.
How to … Schedule Query Extracts using RSCRM_BAPI
Answer:
You could try using RSCRM_BAPI to save the query results to a table.
Then create a generic extractor in BW.
THere is a How to paper on this.
How to … Schedule Query Extracts using RSCRM_BAPI
Answer:
You could try using RSCRM_BAPI to save the query results to a table.
Then create a generic extractor in BW.
THere is a How to paper on this.
How to … Schedule Query Extracts using RSCRM_BAPI