//Get cube related data in AX 2012//Prerequisite//Add new references node in AOTMicrosoft.AnalysisServices.AdomdClientstatic void SSLSSASCubeData(Args _args){str cubeConnectionString, cubeQuery, value;int i, rowCount;System.Data.DataTable dataTable;System.Data.DataRowCollection collection;System.Data.DataRow row;System.Object object;Microsoft.AnalysisServices.AdomdClient.AdomdConnection Conn;Microsoft.AnalysisServices.AdomdClient.AdomdDataAdapter dataAdapter;cubeConnectionString = 'Data Source=SSAS_SERVER;Catalog=SalesCube';cubeQuery = 'Select SalesNum from SalesCube';dataTable = new System.Data.DataTable();Conn = new Microsoft.AnalysisServices.AdomdClient.AdomdConnection(cubeConnectionString);dataAdapter = new Microsoft.AnalysisServices.AdomdClient.AdomdDataAdapter(cubeQuery, Conn);dataAdapter.Fill(dataTable);collection = dataTable.get_Rows();rowCount = collection.get_Count();for (i = 0; i < rowCount; i++){row = collection.get_Item(i);object = row.get_Item(0);value = object.ToString();info(strFmt('%1. %2', i+1, value));}Conn.Close();}
Monday, September 11, 2017
Get SSAS cube related data in AX 2012
Subscribe to:
Post Comments (Atom)
Dynamically setting entire Form security access through Extension in D365FO
/// <summary> /// To check if user can get access to the Parameter form /// </summary> class SAN_ParamFormsAccessCtrl { prot...
-
Posting Vendor invoice based on Product receipt public void postPurchaseInvoiceJournal() { VendPackingSlipJour vendP...
-
protected void executePostingDataPerOrder(str _salesId) { SalesFormLetter_PackingSlip salesFormLetter_PackingSlip...
-
BP: BPUpgradeCodeLateBoundCall : BP Rule: [BPUpgradeCodeLateBoundCall]:A late bound call callingForm.refresh is made. In source system (...
No comments:
Post a Comment