Author Archives: Olaf Fischer

Analysis Office 1.1 – Using the VBA APIs – Create in-Sheet Drop-Down populated with API results


It is quite common that the API of Analysis Office returns arrays containing the requested information. How would I extract a single column out of it and show it to the user in a in-sheet drop-down?

Continue reading

Posted in Business Intelligence (BusinessObjects), SAP Business Intelligence, SAP Businsess Objects | Comments Off on Analysis Office 1.1 – Using the VBA APIs – Create in-Sheet Drop-Down populated with API results