cancel
Showing results for 
Search instead for 
Did you mean: 

Query output to CSV file in SAP BW 7.5

ravikiran_sap
Explorer
0 Kudos

Hi Folks,

we have a requirement to generate a CSV file using Bex query based on Multiprovider which has yearly cubes .

what is the best approach from the following .?

1.) Multiprovider --> Bex Query (Current year To Date data filter) -- > ADSO -- > APD --> CSV File in target location

2.) Bex Query (Current year To Date data filter) -- > APD --> CSV File in target location

we dont need any filters in APD since data is restricted in Query Level.

Also we have to keep all characteristics in rows right ? otherwise they wont appear in CSV file when we run APD. Pelase clarify.

Regards,

Raki

Accepted Solutions (1)

Accepted Solutions (1)

vishalakshmi
Contributor
0 Kudos

Hello Ravi,

if data storage in ADSO is not required, the second option, which involves using the Bex Query with the current year-to-date filter and then an APD to generate the CSV file in the target location, is the preferable choice due to its potential for faster execution.

Bex Query (Current year To Date data filter) -- > APD --> CSV File in the target location.

Regarding your question about characteristics in rows: Yes, if you want specific characteristics to appear in the CSV file generated by the APD, you need to ensure that those characteristics are included in the Bex Query and the subsequent APD. If a characteristic is not included in the query or APD, it won't appear in the resulting CSV file. So, make sure to include all the necessary characteristics in the Bex Query's output and the APD's selections to ensure they appear in the CSV file.

Thanks,

Lakshmi.

ravikiran_sap
Explorer
0 Kudos

Hi Thanks Lakshmi. yah i will consider the same model and include all fields in row pane.

Thanks again for your valuable time.

Answers (0)