Migration of Workbook Strategy

[Former Member]

Hi All,

I have several workbooks which has quite a number VBA/VB codings in complexity, I understand that once if this workbook is migrated there is a high probablity that these workbook might not function in BI 7.0 Analyzer and this could lead to a cost rebuild.

I wonder could I use the in SAP Business Explorer (SAP BW 3.x), in another word. Start Menu ---> Programs ---> Business Explorer -

---

> Choose SAP BW 3.x -

---

> Analyzer (SAP BW 3.x).

Will this be a solution in my case ? In another word upgraded to BI 7.0 but executing it in 3.x, my strategy is to preserved the workbook containing VBA/VB codings from being changed .

Please advise

TQ

Nathan

[Former Member]

Hi All,

I guess this will be a temporary solution only ? But real challenge is what happens if one of the reports requires additional product .... then this will require an additional task of manually keying in the VB/VBA codes in the Workbook VB Editor. I would like to eliminate this .... by using the new functionality in BI 7, what will be the best way to do so ? If it is in BEx Analyzer in BI 7.0, does it comes with VBA tht automatically add a new product when a new product is being introduced ...

I don't think so ...... I guess what will be next best solution to this

Thanks

Nathan

[Former Member]

Hi,

Yes, if you dont want migrate yur workbook to BI7 and continue to use BW3.x features, then you need use analyzer as specified in the path below.

Start Menu ---> Programs ---> Business Explorer -

---

> Choose SAP BW 3.x -

---

> Analyzer (SAP BW 3.x).

But once you open the BW3.5 workbook with BEx 7 and save it, it gets migrated to BI7 and you will not be able to open/run it with BW3.5

Thanks,

Kalyan