EVLCK question/problem

[Former Member]

Hi,

In our application we use CATEGORY, ENTITY and TIME for the work status and overall it works fine. However, I tried to create an Excel report using the EVLCK funtion and it doesn't seem to work at all.

The input for EVLCK are AppName, Parameter and Member1 through to Member5. I thought that since we use only 3 dimensions to control the work status, my EVLCK would look like this.

EVLCK(AppName;0;Category;Entity;Time)

The only result I get from this is #ERR. I then changed the order of the dimension and left the Parameter (0 above) blank but that made no difference at all. I then manually created an EVLCK which referenced all my dimensions, but all I get then is #VALUE.

I can run the standard work status report and all I need to select are the category, entity and time and I get the correct work status as a result. However, I would like to show the work status in my standard input schedules at the top so I need the EVLCK to work.

Has anyone experienced this before?

Thanks,

Arnold

[Former Member]

Hi,

You need to mention the members of the work status dimensions, for which you want to see the work status information. So, an example would be:

EVLCK(AppName,0,ACTUAL,ENT1,2009.JAN)

You need to adjust the function as per the members you have.

Hope this helps.

[Former Member]

Hi,

that's exactly what I meant in my post, though instead of naming the individual members in the formula I used cell-references.

Thanks,

Arnold

[Former Member]

Hi,

Can you just try the formula by hard-coding the members and the application name? Keep them within double qoutes, something like:

EVLCK("Finance",0,"ACTUAL","ENT1","2009.JAN")

And keep the case intact. If you have the member as ACTUAL, then write it as ACTUAL, instead of Actual.

Let us know how it goes, if you just hard-code everything in the function.

[Former Member]

Hi,

makes no difference, I ran it as

=EVLCK("CONSOL";0;"ACTUAL";"E_1136";"2010.AUG")

but I still get #ERR as the result.

Thanks,

Arnold

[Former Member]

Hi,

Which SP are you using. I think you should try to upgrade it to SP06. I saw some similar error pertaining to the previous SP.

Hope this helps.

[Former Member]

Hi,

we are on SP07 Patch 1.

Thanks,

Arnold

[Former Member]

Hi,

BPC 7.0 or 7.5?

[Former Member]

7.5

[Former Member]

Hi,

Can you try this on ApShell? Do you similar error in ApShell also? If yes, then I would suggest you to log this with SAP.

[Former Member]

It works fine in Appshell even though the work status for the Planning application is not set up (no dimensions set to be used), so I will ask our technical gurus here and if they cannot find the problem we will log it with SAP.

Thanks,

Arnold

[Former Member]

Hi Did you find the problem for your solution, could you please update it am having similar problem

[Former Member]

The 'solution' in our case was to restart the server.