Forum Discussion

tteeple's avatar
tteeple
Regular Visitor
9 years ago

SSAS dimension visible with Visible property set to False

I still see some dimensions that have their Visible property set to False in the cube.  The Dimension Usage tab shows False as well as the dimension on any perspectives.  It works for some dimensions...
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi tteeple,

 

When we connect to SSAS in desktop in live connection, all hierarchies and dimensions should be the same as on databased engine. I would suggest you check if dimension attributes visible on SSAS side firstly.

 

In addition, based on my test, when we set the AttributeHierarchyVisible as False for the dimension attribute. If it's referenced in user-defined hierarchy, still be visible in hierarchy when we browse the cube.

 

Best Regards,
Qiuyun Yu

tteeple's avatar
tteeple
Regular Visitor
9 years ago

v-qiuyu-msft  Thanks for responding.  The issue is with the entire dimension, not just a single attribute.

As you can see, I have the Visible property on the entire dimension in the Dimension Usage tab set to False.  The dimension still shows up in Power BI, both Online and Desktop, so it can't be a gateway issue.

I have other dimensions set to False and they do not show up.

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    Hi tteeple,

     

    I can reproduce this issue. And I already reported it internally, will update here once get any feedback.

     

    Best Regards,
    Qiuyun Yu

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Icon for Community Support rankCommunity Support
      9 years ago

      Hi tteeple,

       

      I got the information that dimension visibility is not reflected correctly in CSDL acquired from AS Engine. The incorrect CSDL is an AS Engine bug. And you should submit a support ticket to SQL support directly. Please notice that AS Engine bugs typically take longer to get fixed for users because of their slower release cycle.

       

      Best Regards,
      Qiuyun Yu

      • tteeple's avatar
        tteeple
        Regular Visitor
        9 years ago

        Thanks v-qiuyu-msft.  Can you provide me with a link of where to submit a support ticket?  I don't see anything on the SQL Server page for tickets.