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) / Can not see standard c...
Microsoft Dynamics AX (Archived)

Can not see standard cubes in AX 2012

(1) ShareShare
ReportReport
Posted on by ARPIT CHAVHAN 4,359

Dear All,

I am trying to deploy the standard cubes in AX 2012 R2. The steps I followed are as follows.

1. Installed Sharepoint 2010.

2. Installed EP.

3. I could see the role center page on home screen.

4. Run the SQL server analysis project and deployed the DynamicsAX project.

It took a quite long time, but when it is finished, I didnt see any cubes on the roles center page.

I tried restarting the server itself but in vain.

Can anybody please guide where I went wrong or what did I miss ?

Thank you.

*This post is locked for comments

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

    Hi Arpit,

    Can you browse the SSAS Cubes directly on the analysis server? e.g. through SQL SSMS, BIDS, Visual Studio or even Excel?

    What edition of SQL are you using: Standard, BI, Enterprise etc?

  • ARPIT CHAVHAN Profile Picture
    ARPIT CHAVHAN 4,359 on at

    Hi Terry,

    I browsed via excel, it is showing data.

    we are using SQL standard.

  • Suggested answer
    Guy Terry Profile Picture
    Guy Terry 28,924 Moderator on at

    [quote user="ARPIT CHAVHAN"]

    we are using SQL standard.

    [/quote]

    That's your problem. You need SQL BI or Enterprise (or Developer). Or more, technically, the edition of SSRS that is installed into Sharepoint needs to be BI or Enterprise.

    It's not clearly written down anywhere, in my opinion, in any AX literature. Search for the phrase 'Power View' here:

    https://technet.microsoft.com/en-us/library/cc645993(v=sql.120).aspx

    I think you'll also find that the 'Analyse data' buttons (e.g. on the All customers list page) don't work either.

  • ARPIT CHAVHAN Profile Picture
    ARPIT CHAVHAN 4,359 on at

    Hi Terry,

    We have installed the cubes on the same version of SQL on different server and its working fine. I can see cubes over there.

  • Guy Terry Profile Picture
    Guy Terry 28,924 Moderator on at

    Do you have the SSAS server and database defined at System Admin -> Setup -> Business intelligence -> Analysis Services -> Analysis servers?

  • Juan Rafael Profile Picture
    Juan Rafael 405 on at

    Hi.

    After you deploy the SSAS project, you've processed ?, you process it from the SSAS to refresh the data, so users can view this data AX must add the SSAS (Star -> SQL Server Management Studio -> SSAS - > SSAS Properties -> Security (Add to AX users).

    Regards,

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