Save current view user specifically

[former_member268345]

Dear all,

is there a possibility to save the current view settings in 7.5 in a user specific way?

So that depending on the user, the selections in the current view can be saved either locally on the user's client or within BPC.

Appreciate your help

Tammy

[krishna_priya1 · Accepted solution]

With the help of VBA MACRO(EvMNU & SETCV) you can achieve this . But you might need to hard code user ID 's in the template , which is not best practice . Another draw back is,scope of this solution is template . ie in every template you might need to place this MACRO . If the requirement is with less number of users & there are less number of templates , you can go with this approach .

Hope this helps.

[Former Member · Accepted solution]

Hi,

SetCV sets the CV.

Are you sure that you can use this function to set different CVs for different user IDs?

[krishna_priya1 · Accepted solution]

Hi Nilanjan,

User ID needs to be hard coded in template and maintained in table with below format. Based on logged in user corresponding CurrenvtVIew parameter can be picked with VLOOKUP . And this value can be passed to EvMNU function.

USERID CVParameter

USER1 Category=FORECAST;ENTITY=E1

USER2 Category=BUDGET;ENTITY=E2

[former_member268345 · Accepted solution]

Hi,

thank you for your quick and helpful answer.

We use about 50 templates and have around 80 users.

How do you estimate the performance impact when using the VBA workaround with 80 users?

[Former Member]

Hi,

I dont think you can save separate CVs for different users.