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) / Analysis Services Proj...
Microsoft Dynamics AX (Archived)

Analysis Services Project Deployment skipping Database Creation

(0) ShareShare
ReportReport
Posted on by Sohaib Cheema 49,438 User Group Leader

As I proceed for deployment of Analysis service Project, using standard AX wizard, it does not result in creation of a Database on SSMS Analysis services.

I cannot suspect security here, because I am able to login on SSMS Analysis service.

 

So, I got two questions here

 1) What moment AX should create Analysis services Database

a) At time of analysis services installation, as we run AX setup

b) At time of deployment of Analysis services project using available wizard

2) What could be possible reason due to which AX is not creating DB on SSMS, despite we can see Analysis services projects inside AX AOT 

 

 

 

 

*This post is locked for comments

I have the same question (0)
  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,438 User Group Leader on at

    Update.

    For 1st question it takes option b)

    i.e. As we run AX wizard for deployment of Analysis Services Project , that moment at runtime, It creates DB in SSMS Analysis Service.

    I experimented it on another server.

    I am surprised to see why Microsoft removed a useful option which was available in R2 version of AX. It was about, allowing a user to select whether he/she wants to create a new DB at run-time or want to deploy analysis project on an Existing DB.  The below image is from early version of AX2012, it is no more from AX2012R3.

    1200.SQLSSIS.png

  • Lance [MSFT] Profile Picture
    Lance [MSFT] on at

    There's no error message?

    Not sure on this one, but I'd start by confirming if it is even trying to deploy to the same server you are checking.

    There is a table named BIAnalysisServer or something similar.  That holds this info. Its also shown in a form on the Analysis Servers form on the Tools -> BI tools menu.

    Make sure there is a record for your ax parition which holds the name of the server you want to deploy to and that IsDefault is set to true on that record.

    After you deploy, its supposed to create an additional record in table BIAnalysisServicesDatabase to hold the name of the analysis services database to which it should connect for the current Ax partition.  The isDefault flag on that record should also be true.  You can check if that record was been created or not.  

    On the Advance tab you can also set the log file path and it should log some info for project generation, update, or deployment.

    If all else fails, you could try stepping through the deployment code.  The deployment step is wrapped in x++ code so it should be possible to step through it to see what's happening.  The method to look at is BIAnalysisServicesProjectController.deployAnalysisServicesProject

    P.S.  If you have only one AX partition, than you can deploy the project from Sql Data tools and then manually add the records in BIAnalysisServer and BIAnalysisServicesDatabase table indicating which server you are using and what olap database to connect to.  

      The deployment wizard normally adds a filter to each data source view query to filter data to only data for the current AX partition and then it updates the connect string to point to the sql database and deploys the project.  If you don't use ax partitions, then you don't need the filter.  In that case, you could just open the project in sql data tools, manually update the connect string yourself, and then deploy it from sql data tools.

    Hope this helps,

    --Lance

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