How to use function of BPC for Excel "EvNXP" - SAP Community

Hi.

I try to make 3 or 4 nest table to use Function "EvNXP",

but I failed.

Please teach me how to configurate "KeyRange" and "DataRange" .

thanks.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

Answers (1)

Hi,

For EVNXP ; EVDRE Syntax:=EVDRE("1X2")

In the A1 type =EVDRE("1X2") ---> press Enter, the follow the EVEXP syntax.

Regards

CSM Reddy

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

You should be using EVDRE which performs both the expansion and the data retrieval. EVNXP is a legacy expansion function that is maintained for backwards compatability mainly.

That said, the syntax for all the functions is explained in the on-line help guide in BPC. Choose eTools>BPC for Office Help from the toolbar or select Also See from the action pane.

Ask a Question