web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Hide icons for OLAP Po...
Microsoft Dynamics AX (Archived)

Hide icons for OLAP Power View Report Designer in AX 2012 R2

(0) ShareShare
ReportReport
Posted on by Community Member

We are implementing Microsoft Dynamics AX 2012 R2 and although we did deploy SSAS and the Dynamics OLAP Cubes, we are not going to use Power View at this time because we deployed SharePoint Foundations 2013 which does not support Power View.  However users are clicking on the icons for Analyze Data Reporting on the different modules and are confused with the bogus error that says the OLAP Cubes have not been deployed.  It seems that whether you plan on using Power View or not these icons are available and just give an invalid error when trying to use them.  Does anyone know a way of hiding these icons within the UI?  We are showing those users that need more dynamic information on how to create Excel Pivot tables and connect to the OLAP Cubes.  Thanks in advance.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Guy Terry Profile Picture
    Guy Terry 28,924 Moderator on at

    The 'Analyse data' button appears to be a Menu Item of type Action. It can have one of three names, depending on which module you launch it from, but they all begin CreatePowerViewReport....

    If you find one of these menu items in the AOT, you can right click on it and do Add-ins -> Security tools -> View related security roles. Scroll to the right of this window that appears, and you will see the Privilege responsible for giving the users access to this menu item.

    For example, on CreatePowerViewReportCustCube, I see that the privilege 'View collections customers pools list page' has access.

    Head to Sys Admin -> Setup -> Security -> Security privileges.

    In the little white box (top-left) if I type 'View collections customers' and hit the green arrow >, that privilege appears in the tree on the left. In the middle of the screen, under 'Permissions' I can change the Access level for CreatePowerViewReportCustCube to No access.

    And repeat for all privileges for all three Menu Items!

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Great and detailed info Guy.  Thank you so much.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans