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) / OLAP Cubes Deployment ...
Microsoft Dynamics AX (Archived)

OLAP Cubes Deployment Error in Ax 2012 R3

(0) ShareShare
ReportReport
Posted on by srinivas pamidi 1,737

I am Just run the SQL Server Analysis Service Project Wizard in the Microsoft Dynamics Ax Client 

I am Getting Errors.

1)

A copy of the Analysis Services project being deployed has been saved to C:\Users\erp5\AppData\Local\Temp\3\Dynamics AX initial\Dynamics AX initial.dwproj.

2)

SQL server edition does not support translations. All translations (if any) have been removed

3)

Internal error: The operation terminated unsuccessfully.
OLE DB error: OLE DB or ODBC error: Login failed for user 'RIL\ERP$'.; 28000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Dynamics Database', Name of 'Dynamics Database'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'LOGISTICSPOSTALADDRESSEXPANDED', Name of 'Geographic location' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'District' attribute of the 'Geographic location' dimension from the 'Dynamics AX initial' database was being processed.
OLE DB error: OLE DB or ODBC error: Login failed for user 'RIL\ERP$'.; 28000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Dynamics Database', Name of 'Dynamics Database'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'LOGISTICSPOSTALADDRESSEXPANDED', Name of 'Geographic location' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'City' attribute of the 'Geographic location' dimension from the 'Dynamics AX initial' database was being processed.
OLE DB error: OLE DB or ODBC error: Login failed for user 'RIL\ERP$'.; 28000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Dynamics Database', Name of 'Dynamics Database'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'LOGISTICSPOSTALADDRESSEXPANDED', Name of 'Geographic location' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Postal code' attribute of the 'Geographic location' dimension from the 'Dynamics AX initial' database was being processed.
OLE DB error: OLE DB or ODBC error: Login failed for user 'RIL\ERP$'.; 28000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Dynamics Database', Name of 'Dynamics Database'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'LOGISTICSPOSTALADDRESSEXPANDED', Name of 'Geographic location' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'State or province' attribute of the 'Geographic location' dimension from the 'Dynamics AX initial' database was being processed.
Server: The current operation was cancelled because another operation in the transaction failed.
OLE DB error: OLE DB or ODBC error: Login failed for user 'RIL\ERP$'.; 28000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Dynamics Database', Name of 'Dynamics Database'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'LOGISTICSPOSTALADDRESSEXPANDED', Name of 'Geographic location' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'County' attribute of the 'Geographic location' dimension from the 'Dynamics AX initial' database was being processed.
OLE DB error: OLE DB or ODBC error: Login failed for user 'RIL\ERP$'.; 28000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Dynamics Database', Name of 'Dynamics Database'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'LOGISTICSPOSTALADDRESSEXPANDED', Name of 'Geographic location' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Country region' attribute of the 'Geographic location' dimension from the 'Dynamics AX initial' database was being processed.
OLE DB error: OLE DB or ODBC error: Login failed for user 'RIL\ERP$'.; 28000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Dynamics Database', Name of 'Dynamics Database'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'LOGISTICSPOSTALADDRESSEXPANDED', Name of 'Geographic location' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'IsNotApplicable' attribute of the 'Geographic location' dimension from the 'Dynamics AX initial' database was being processed.

4)

Errors occurred while processing the Analysis Services database: Dynamics AX initial

5)

A fiscal calendar is not specified for the ledger for the legal entities listed below. A fiscal calendar must be assigned to each legal entity’s ledger in order for cube reports to run correctly and to analyze cube data in Microsoft Excel. Select a fiscal calendar for the ledger in each legal entity to correct this error.

6)

Legal entity: DAT

I don't Know how to solve this Issue.

Please Guide ME.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi Srinivas,

    Please try updating the application to the latest CU available. Remove any customization to the dynamics Ax project. Once the same is deployed later you can import the customizations back and update the project.

  • Suggested answer
    Brandon Wiese Profile Picture
    Brandon Wiese 17,788 on at

    The error is

    Login failed for user 'RIL\ERP$'

    This suggests that the account that the SSAS server service is using (apparently Network Service on machine named ERP) does not have access to the AX business database.  Grant the computer account/network service account Data Reader access to your AX database.

  • Mazherullah Profile Picture
    Mazherullah 345 on at

    Hi,

    Are you able to fix this issue.

    I am also experiencing the same issue.

    My version - AX 2012 r3 cu10.

    REgards

  • Suggested answer
    Tommy Skaue Profile Picture
    Tommy Skaue Moderator on at

    It looks like the SSAS Service Account does not have proper access to OLTP database (The Dynamics AX Transactional Database).

    If SSAS is running on the same server as SQL Server Engine, you can find the correct reference to the service account by opening SQL Server Configuration Manager on the SQL Server. From the SQL Server Services node, you will see all the running services. Find the correct SSAS instance, right click and open Properties. On the "Log on" tab, you will find the Account Name field. Use this the value in this field when creating the LOGIN (windows authentication) on the SQL Server Instance running the OLTP database. You will need to grant db_datareader if this is standard AX OLAPs, and if you need to set this up for the Demand Forecast OLAP, it also needs ddl_admin and db_datawriter.

    On one of my sandbox machines, the account is "NT Service\MSSQLServerOLAPService".

    If SSAS runs on a different box, you will add a login that uses the machine account instead. So if SSAS runs on DOMAIN\ServerA, and SQL runs on a different server, you will have to create a LOGIN (windows authentication) using DOMAIN\ServerA$ as username. Notice the dollar-sign after the server name. The permissions for this LOGIN will be the same as listed above.

    Hopefully that will resolve your issue. :-)

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