PDA

View Full Version : Parsing excel value into SAP BW Analyzer 7.x



j312ry
01-03-2012, 08:31 PM
Hi All Gurus,

I'm a newbie for VBA and SAP BW, please please help me to figure this out.

I have a variables in Excel that consist of some values (i got these values using lookup function in VBA).

Example :
Unit = "101" , "102" , "103"
Year = 2011

Those values will keep changing depends on user (dynamic).
I want to parse these values into SAP BW Analyzer right before user Refreshing content process.
The purpose is to decrease human typo error.

Is it possible to do that? many thanks in advance..

Specification :
BW Analyzer 7.x
Excel 2003