-
Recent Posts
Archives
Categories
Meta
Author Archives: jhuythieu
Data Mining – Mining Model Prediction
Time Series Query SELECT ([DC Cust Product Model].[DC Cust Product Model]) as [ModelDCCustProduct], (PredictTimeSeries([DC Cust Product Model].[Revenue],3,18,EXTEND_MODEL_CASES)) as [PredictedRevenue], PredictTimeSeries([DC Cust Product Model].[Quantity],3,18,EXTEND_MODEL_CASES) as [PredictedQuantity], (SELECT $Time, PredictVariance([Revenue]) AS [VARIANCE_REV], PredictStdev([Revenue]) AS [STDEV_REV] FROM PredictTimeSeries([DC Cust Product Model].[Revenue],3,18,EXTEND_MODEL_CASES) AS t … Continue reading
Posted in Data Mining, Machine Learning
Leave a comment
Python – Data Processing – Get data from SQL Table
# -*- coding: utf-8 -*- “”” Created on Thu Sep 26 09:33:17 2019 Magnussen Machine Learning – Forecast Time Series @author: Jake “”” import numpy as np import pandas as pd #import pandas.io.sql as psql import matplotlib.pyplot import pyodbc def … Continue reading
Posted in Machine Learning, Python
Leave a comment
GENTRAN/GIS/SI DOCUMENTATION, TUTORIALS AND OTHER STUFF
I see a lot of requests about training/documentation/tutorials for Gentran/GIS/SI. Maybe, one day I post some basic things about SI/GIS administration and maps, but now I’d like to share some links to very useful documents from IBM. Now they have … Continue reading
Keep the Filter section always expanded in AxGridView
If you add the below javascript code to your user control at the bottom of the markup file ( .ascx file) then the filter section will always be in expanded mode both during initial load as well as during subsequent … Continue reading
Posted in Uncategorized
Leave a comment
Enterprise portal datepicker gives an error on second click
Enterprise Portal – strange behaviour with date-picker Basically from same site quoted: In the web.config file you will probably find a similar line: . When you change the debug parameter to false () and execute a iisreset, this issue is … Continue reading
Posted in Uncategorized
Leave a comment
Advanced AXGridview with customs fields
<dynamics:AxGridView ID=”gridEPPurchTableEdit” runat=”server” DataKeyNames=”RecId” DataMember=”TmpPurchLine” DataSourceID=”dsItemArrival” AllowEdit=”false” AllowPaging=”False” GroupField=”InventDimId” ShowFilter=”false” AllowSelection=”false” GroupFieldDisplayName=”Site” ExpandEditableRow=”True” > <HeaderStyle BackColor=”#507CD1″ ForeColor=”White”/> <EditRowStyle Height=”15px” /> <SelectedRowStyle Height=”15px” Wrap=”False” /> <AlternatingRowStyle BackColor=”#F3F3F3″/> <Columns> <asp:TemplateField HeaderText=”RecId” Visible=”false”> <HeaderStyle HorizontalAlign=”Center” ForeColor=”white” Font-Bold=”true” BorderColor=”#D2D2D2″ BorderStyle=”Solid” BorderWidth=”1″ Width=”60px” Height=”23px”/> <ItemStyle … Continue reading
Posted in Enterprise Portal Development
Leave a comment
Method ‘item’ in COM object of class ‘Range’ returned error code 0x800A03EC ()
We need delete the export definition group (only delete the definition group we use to export and import). Create a new one and try different type of Export to or Import to.
Posted in Uncategorized
Leave a comment
How to select largest records in a group from a table
Theory is: – We need a field with unique value (such as: CreatedDateTime, Voucher Num, or an amount – select top 1) – Use Max (or Min) function to get what value you want. – Group by fields Example: Select … Continue reading
The request failed with HTTP status 405: Method Not Allowed
The request failed with HTTP status 405: Method Not Allowed. 11122009 Recently on the Axapta-Knowledge-Village discussion board, the following workflow issue was raised, the user had an error when trying to validate his workflow url with the following message being displayed: “The request … Continue reading
Posted in Uncategorized
1 Comment
Failed to find workflow configuration.
Error : Failed to find workflow configuration. This error comes when a configuration is deleted from the workflow, but refrence is still there in the workflowworkitem table so we have to delete it by running a job. //Jake – Aug 10, … Continue reading
Posted in Enterprise Portal Development
Leave a comment