//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)
Replaces the value of the specified dimension attribute from source to target in D365FO
Replaces the value of the specified dimension attribute from source to target => LedgerDimensionDefaultFacade::serviceReplaceAttributeVal...
-
Posting Vendor invoice based on Product receipt public void postPurchaseInvoiceJournal() { VendPackingSlipJour vendP...
-
protected void executePostingDataPerOrder(str _salesId) { SalesFormLetter_PackingSlip salesFormLetter_PackingSlip...
-
Code for reserve and unreserved sales order lines Inputs : SalesLine, InventDim (Combination to reserve), Qty Note : To Reserve -> Pass...
No comments:
Post a Comment