Workbook : BexGetData( ) Formula.

[Former Member]

Hello Experts,

I am trying to save a workbook developed in BI as an excel. I have used BexGetData( ) formula to map the data from the corresponding infoObjects from the infoprovider.

But it is not saving as an excel. A blank worksheet appears while opening it.

Please let me know your expert comments on this.

Regards.

[Former Member]

Hi Richa ,

Open the same workbok again and in design mode select the analsysis grid and assign data provider .do all necessary requirements and DO NOT Save it as it is .Go for save as option and give new name for it , &Save , close it .When you open it next time it will be available.

Its a Std problem with BI 7.0 because of improper config .

You cannot do any changes to existing workbook and save .You can save but changes wil not be effective when you open it next time .you have to go for save as .

Regards

Vels