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