How to get variable value in BI 7.0 Workbook (Excel 2007)

[shady_shen]

Dear experts,

We are creating workbooks with BI 7.0 BEx Analyzer Addon 7.10 (Excel 2007).

And we'd like to get the variable value (that are passed to the backend using the variable screen) so that we can reuse it as an input value for planning function execution later.

Any idea on how we can achieve this is high appreciated.

Thanks in advance,

Shady

[shady_shen]

I'm afraid I haven't made my question understood clearly.

What I am looking for is a method to get the value of variable inside excel (e.g. put it into a cell / range of a worksheet, so that we can reference it and use it as an input for planning function execution).

Please advice.

Thanks in advance,

Shady

[shady_shen]

Thanks for your reply.

But what I am asking for is how I can get the variable value under the context of BEx Analyzer (Excel) rather than in the backend system.

Regards,

Shady

[former_member205352]

If its saved as variant then it will be accesible on the variable entry screeen.There will be variant button.

Edited by: Praveen G on Oct 11, 2008 5:34 AM

[former_member205352]

If the variable values entered are saved as variants then it will be accessible in RSRVARIANT table.

Hope this helps.