[ ax2012 ] dependent deletion check / not allow edit PK

Dependent deletion check

dependent_check_before_delete

use DeleteAction : Restricted   =  not allow deletion if there is an dependency

use DeleteAction : Cascade = allow deletion and delete related record

more detail : http://amazingax.wordpress.com/2013/01/13/microsoft-dynamics-ax-2012example-of-cascaderestricted-and-cascade-restricted-delete-action-property-for-a-table-relation/

Not allow edit PK

ax_allow_edition

[ ax2012 ] BI analysis server

Setup server name

System administrator > Setup > Business intelligence > Analysis Services > Analysis server

analysis_server

Manual run cube

Way1 : run in SQLServer

right click at cube > process

analysis_server_sql

or or or ….

Way2 : run in Ax

File > Tools > Business Intelligence (BI) tools > SQL server analysis services project wizard

Select Deploy > click Next

The settings ( i.e. Server name ) can be find in the Windows `SQL Server Analysis Services Project wizard`.

ref : http://blogs.msdn.com/b/dynamicsaxscm/archive/2014/06/26/warehouse-key-performance-indicators-in-microsoft-dynamics-ax-2012-r3.aspx


How to auto run cube 

1.

1_1a0a7202-f92f-403a-aaec-e1838caa414cCube Process

2_50131bb3-39ae-4b76-85c5-978b0f12a9f1Script to Clip

3_89c18bdb-cd85-4c40-b0f7-255172a4f574New Job

4_4ecc577b-cbd8-4283-858f-5cf350667bbcPaste Command

ref : http://www.symantec.com/business/support/index?page=content&id=TECH193699

2. set the schedule of agent

schedule_process_sqlserver_agent_

schedule_process_sqlserver_agent

3. view status by SQL Server agent > Job Activity Monitor

job_activity_monitor_

job_activity_monitor

http://technet.microsoft.com/en-us/library/dd309669.aspx

Tips : How to solve `Agent XPs disabled`

1. check if `agent xps` is exists

EXEC SP_CONFIGURE 'Agent XPs'
the configuration option 'agent xps' does not exist or it may be an advanced option

2. enable advanced option to see all of the advanced configuration values

EXEC SP_CONFIGURE 'show advanced options',1
GO
RECONFIGURE
GO
EXEC SP_CONFIGURE 'show advanced options'

3. Run sp_configure again to check the value for Agent XPs

EXEC SP_CONFIGURE 'Agent XPs',1
GO
RECONFIGURE

ref : http://www.mssqltips.com/sqlservertip/2729/how-to-start-sql-server-agent-when-agent-xps-show-disabled/

[ ax2012 ] batch

How to view the AOS instance name

System administration > Common > Users > Online Users
aos_instance_name

If the batch job stuck in Executing… status, try to change to Cancel.. then Withhold.. then we can change to Waiting.. again.

System administration > Setup > System > Server configuration

`AOS instant name` with `is batch server` ticked

is_batch_server

System administration > Setup > Batch group

selected_server