Dynamics AX
  RSS Feed  LinkedIn  Twitter
Want to turn you're data into a true asset? Ready to break free from the report factory?
Ready to gain true insights that are action focused for truly data informed decisions?
Want to do all of this across mutliple companies, instances of Dynamics and your other investments?
Hillstar Business Intelligence is the answer then! (www.HillstarBI.com)

Hillstar Business Intelligence for Microsoft Dynamics AX and NAV on Mobile, Desktop, Tablet


Let us prove to you how we can take the complexity out of the schema and truly enable users to answer the needed questions to run your business! Visit Hillstar Business Solutions at: www.HillstarBI.com

Tuesday, April 24, 2012

AX 2012 - Process Cubes Error: translations in Standard Edition




I hope everyone is having a great week so far. Like I said in a previous post, I love spring, and we got a cool reminder these past two days in the south that it is still spring. 37 Degrees at night is way to cold for my blood, this close to May. With that cool reminder of spring, let me jump right into today's post. You might get this error message: "Only dimension attributes and attribute relationships can have translations in Standard Edition" When you process cubes, after deploying them in AX 2012 on a SQL Server Analysis Services, Standard Edt.

If you happen to get such a message, and need help getting past it, make use of the following steps and you should be back on track for processing those out-of-the-box cubes.



What you see in the above image is the location of the Analysis Services Project. This is what you want to make sure and delete. This is what is used to actually build, or update the cube structures. It houses the Datasource, Dataview, and all cube, dimension, etc. setup and design. This project can be accessed, via highlighting it, after deleting it, and then right click, and left click on edit.

Moving beyond this project however, once you have deleted it, the next step is going to be update the cube designs. You can do this, through the Business Intelligence tools menu option, for the "SQL Server Analysis Services project wizard".



The next screen you should see is the 'select option' form, in which you need to select the Update option. This will take the Analysis Services Project, and use it to build out the cube structures in the Analysis database. Since we want out-of-the-box, then this is the option we want to take.







Now having a success on the verifying screen, we can move on to the confirmation of changes.



This, now will show changes across the board from the project. Seeing this means that all of the elements will be dropped and recreated. This is critical for changing the translations setup. In doing this, you should be able to move on to processing and not have any such issues moving forward.

Now that this is taking care of you should be able to process cubes without such issues. You will run into this, if you are trying to get your out-of-the-box AX 2012 cubes, deployed and then processed on a SQL Server Analysis Service's Standard Edt. Finally, I will leave you with, I have this now running on SQL Server 2012. More on that, and other topics later! Till Next Time!

Update: For those of you who run into any issues with the update choice, you can also go with Deploy. Doing so will take the Analysis Services Project, deploy and process it. This all assumes out-of-the-box, when talking about this issue.





Follow Me @:
RSS Feed  LinkedIn  Twitter

"Visit the Dynamics AX Community Page today!"

Labels: , , , , , ,

3 Comments:

Anonymous Anonymous said...

thanks Brandon, It help me a lot.
Francisco
ITC Group

3:40 PM  
Blogger Pacome said...

Hi Bradon,

I got an issue during the updating process. Just after the "Confirm change" step the system give this error

C:\Users\ggbelai\AppData\Local\Temp\2\lxbwfsph\Dynamics AX.dwproj does not exist.

do you have any clue ?


Thanks.

8:38 AM  
Blogger Pacome said...

Hi Bradon,

I got an issue during the updating process. Just after the "Confirm change" step the system give this error

C:\Users\ggbelai\AppData\Local\Temp\2\lxbwfsph\Dynamics AX.dwproj does not exist.

do you have any clue ?


Thanks.

8:39 AM  

Post a Comment

<< Home


Copyright 2005-2011, J. Brandon George - All rights Reserved