Retrieving Variables and Values using EPM Functions

[ALinetzky]

Hi Experts

Does anybody know how this fuctions works with and example?

32.26 EPMVariableList

Applies to: SAP BW (INA Provider) connections.

This function retrieves the list of variables for the query for the specified connection. You can display the

variables:

● in the current cell, where a specified character separates the variable names.

● in one or more dropdown lists

32.27 EPMVariableValue

Applies to: SAP BW (INA Provider) connections.

This function retrieves the value(s) currently selected for the specified variable. The value(s) is (are) retrieved in

the cell in which you enter the function.

I already checked the EPM Add-in for Microsoft Office User Guide but is didn't say anything helpfull

Regards

Ariel

[Former Member]

Hi Ariel,

You open excel, log on to a connection.

in in empty cell type =EPMVariableList

then click on the fx button, see pick, and it will guide you through.

Andy

[ALinetzky]

Dear Andy

I already do that but i didn't find how to use it, for that reazon I would like and example who to use it.

I checked the gide EPM Add-in for Microsoft Office User Guide (2014-06-13  version) but it doesn't have examples

Have you had use it before?

Regards

Ariel

[Former Member]

Hi Ariel,

I don't have unified version of BPC.

are you connected to a unified model?

what values have you tried for those parameters.

Andy

[ALinetzky]

Hi Andy

I am working with BPC 10.0.

I thougth that funtion worked for BPC Reports, and according Vadim these functions work for Bex queries

Thanks

Ariel

[former_member186338]

Hi Ariel,

To my mind the mentioned functions are not applicable for BPC.

B.R. Vadim

[ALinetzky]

Dear Vadim

These fuctions are for Unified model?

Regards

Ariel

[former_member186338]

Hi Ariel,

It's clearly stated in help: "Applies to: SAP BW (INA Provider) connections."

And if look on connection types:

4.4.2 SAP BW (INA Provider) Connections

Using the SAP BW (INA Provider) connection, you can do the following:

• Work with BW queries (with or without variables).

• Retrieve data, using reports.

• Enter and save data, using input forms.

• Execute planning function for BW Integrated Planning, using what are called in the EPM add-in "data processes".

...

And some info about 10.1

Unfortunately I don't have 10.1...

Vadim

[ALinetzky]

I don't either, have BPC 10.1

I thougth that funtion worked for BPC Reports, and according you are saying these functions work for Bex queries

Regards

Ariel

[former_member186338]

Yes, for BPC 10 it's useless.

Vadim