Skip to Content
author's profile photo Former Member
Former Member

Cannot see newly added dimension members in EPM excel

I have a strange issue where a user cannot see the newly added dimension members of an unsecured dimension from EPM excel. The user has same task profile and data access profile as other users who can see these new members. The DAP of the user is AdminMbrAccprf.

This user tried logging in from other machines and was able to see those members. Other users logged in this user's machine and they were also able to see all the required members.

Please help me understand the reason behind this.

The following have been tried by the user on his machine:

- Log in and log off

- Refresh cache data

Appreciate quick help.

Regards,

Sowmya

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Mar 24, 2015 at 03:15 PM

    Try C:\Users\<username>\AppData\Local\EPMOfficeClient\Metadata

    Remove everything there, log user in, see if that helped.

    Alternatively, before that in EPM Add-In try "Clear Metadata Cache" and then "Refresh metadata for..."

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 24, 2015 at 05:43 PM

    Hi Sowmya,

    Generally in most of the cases,

    A Dimension created in the web will not appear in the epm excel when their is not even single member exist in the dimension.So,make sure that even single member exist in the newly created dimension.

    Make sure that user trying to access the dimension is in the team which is alloted in the task profiles as well in the DAP AdminMbrAccpf. You can also add the user in the DAP individually.

    In worst cases create a new team with the user who is facing the problem and assign newly created task profile and also assign newly created DAP. This should work because when i faced the same problem i had done this.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Durgaprasad,

      The dimension is not a new one. New members were added to this dimension.Other users having the same DAP and task profiles can see all the members. When this user logs in from other machines, all members can be seen.Other users try to login from this users machine, there is no issue.

      Regards,

      Sowmya

  • author's profile photo Former Member
    Former Member
    Posted on Mar 24, 2015 at 06:42 PM

    Sowmya,

    Did you try Vadim and Dinesh's suggestions? I have tried both of those when this anomaly occurs and it has corrected the issue.

    One other suggestion since the problem appears local, try uninstalling and reinstalling the add in.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.