topic Re: How can I accomplish an Applymap Call like function while on a sheet or chart? in App Development

How can I accomplish an Applymap Call like function while on a sheet or chart?

coleturegroup — Tue, 26 Nov 2024 21:43:48 GMT

Question: How can I accomplish an Applymap Call like function while on a sheet or chart?

GET THE CURRENT USERID AND PASS IT ALONG:

Currently in the LOAD SCRIPT CODE:

LET vUser=right(OSUser(),8);

Map_UserID:

Mapping LOAD

"EmpUserID",

BUSINESSUNIT

FROM [lib://XXXXXX/YYYYY/Employee.qvd](qvd);

// Note: THIS BELOW SETS IT TO THE RESOURCE WHO PERFORMS THE LOAD REFRESH:

// The Where clause seen below works to the Applymap call to complete getting the user region.

[Emp Hours]:

LOAD *

FROM [lib:///XXXXXX/YYYYY/EmpHours.qvd]

(qvd)

Where RegionBU = Applymap('Map_UserID','$(vUser)')

// Usually returns SysAdminBU unless I personally reload it

;

NOW ON THE SHEET: I need to retrieve the current user logged onto the App/sheet:

I ADDED AN ACTION to the sheet:

Set Variable Value: TO

vUser

Value: TO

=right(OSUser(),8)

How do I get this current Users BUSINESSUNIT?

Thanks in advance, this is a puzzler...

Re: How can I accomplish an Applymap Call like function while on a sheet or chart?

marcus_sommer — Wed, 27 Nov 2024 12:17:26 GMT

If you load the User-BU mapping a second time as a normal (distinct) table you could query the information - either directly to the field if there is only a single record when if the same where-condition could be applied or by multiple values with an expression like:

fieldvalue('BUSINESSUNIT', fieldindex('EmpUserID', right(osuser(), 8)))

Re: How can I accomplish an Applymap Call like function while on a sheet or chart?

coleturegroup — Wed, 27 Nov 2024 14:17:21 GMT

load the User-BU mapping a second time as a normal (distinct) table you could query the information. Are you talking about a partial reload?

Re: How can I accomplish an Applymap Call like function while on a sheet or chart?

seanbruton — Wed, 27 Nov 2024 15:02:36 GMT

Hi @coleturegroup

Appymap and its partner Mapping Tables only is active while loadscript is running. When the script ends then all Mapping tables are dropped for optimization reasons so indexing is also completed.

That is important for consideration on scripting planning as you can drop tables anytime, but a MAPPING table is always there until the end. Larger mapping tables does affect performance as well.

I hope this helps.

Re: How can I accomplish an Applymap Call like function while on a sheet or chart?

marcus_sommer — Wed, 27 Nov 2024 15:03:15 GMT

No, it hasn't any relation to partial/incremental measurements else just loading the data into the data-model.

Re: How can I accomplish an Applymap Call like function while on a sheet or chart?

coleturegroup — Wed, 27 Nov 2024 16:20:12 GMT

Marcus, when I execute the fieldindex function with my ID for example returns the number 1000 which when feed it to the fieldvalue function returns NULL.

We have 1040 distinct ID's tied to 22 BU's in the distinct load table. I think that is why it returns a Null.

Any ideas?

Re: How can I accomplish an Applymap Call like function while on a sheet or chart?

marcus_sommer — Wed, 27 Nov 2024 16:26:07 GMT

I think a normal set analysis may also return the wanted result, maybe:

only({< EmpUserID = {"$(=right(osuser(), 8))"}>} BUSINESSUNIT)