How To ... APD & InfoSpoke for Offline-Reporting

52 Views

Hi Guys,

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:

Offline Reporting with Excel? --> complete Report +hierarchy possible?

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

Standa