Forum Discussion

Michael_Laroche's avatar
Michael_Laroche
New Contributor II
2 years ago

Cube Views not rendering data on certain dimensions for a single user

We leverage many cube view for monthly expense reporting and one particular report will not return values for certain columns that are pointed to a single User Defined dimension, but returns data for other columns.  There are no security restrictions on this or any dimension and the users security is no different that others who have no issue running the cube view and rendering complete data.  Has anyone else run into this or a similar issue? 

 

YTD 6/30/2023    
 UD4#AlphaUD4#BetaUD4#OmegaUD4#Total
Operating Expenses$100,000BLANK/NA$150,000$250,000
Cube View
  • twn1's avatar
    twn1
    2 years ago

    Can you also check on the selected members for all dimensions in the POV Pane > Cube POV ? 

  • twn1's avatar
    twn1
    New Contributor II
    2 years ago

    Can you also check on the selected members for all dimensions in the POV Pane > Cube POV ? 

    • Michael_Laroche's avatar
      Michael_Laroche
      New Contributor II
      2 years ago

      It was the Cube POV - the user had some fields undefined.  Once we defined each dimension the report rendered data for all specified columns. Thank you so much!

  • Henning's avatar
    Henning
    Valued Contributor II
    2 years ago

    Hi,

    Is there anything on the Cube's Data Access Security?

    Or does the user have a different user culture than the other users you are comparing her or him to?

    One of the two above was always the reason for what you observed when I was asked to look into it. Though this does not mean that this is the same in your case.

    • Michael_Laroche's avatar
      Michael_Laroche
      New Contributor II
      2 years ago

      Thank you for your reply.  There are no Data Access Security Settings on the Cube and the user has the exact Culture and security settings as many others.  

      • Henning's avatar
        Henning
        Valued Contributor II
        2 years ago

        Is the culture English (US)? If not, I would try that. As I said, the above is all I saw in the past. Otherwise, could you remove the user and set it up again from scratch using the exact same settings as that of another comparable user?
        One needs to dig into this then unfortunately. Test different variations until you get a hint as to what it might be. Hopefully someone else has experienced that and has another item to point you to.