My aim is to download some data from BI into Excel-Pivot-Table. User can click in Excel ->Data->External data->actualize Data and he has the newest KPIs.
Now the troubleshooting. I want to realize this according to this thread:
using APD and / or InfoSpoke. I have a query with filters, rows, columns (columns are as one structure key indicators and characteristics, so that APD can read it). Now the output should be into a Database. This can handle InfoSpoke, but it doesn't communicate with APD. grrr
So the question. How is it possible to extract automatically data from BI into "somewhere" and from "somewhere" into Excel-Pivot.
Do you use some offline solutions?
Thank you for any answers
Greetings to SAP