It's the second step of the customization of Microsoft Dynamics AX (DAX). Remind that our aim is to put a custom business process into DAX. On this step we already have database structure - defined tables and datatypes. And we will try to give to an end-user an ability to input data in database. In other words we will design some forms.
Alex's Tech Diary
Database Developer Blog
Monday, November 3, 2014
Put custom business process into MS Dynamics AX. Part I: Data design
Some time ago I had to make acquaintance with Microsoft Dynamics AX 2012 R2 (hereafter DAX). It should be investigated as one of potential applicant to the deployment as ERP system in company I am working on now. Furthermore first considerations show that some our business processes can not be placed into DAX from-the-box. So a customization, extensive enough, would be coming.
I decided to share my little experience and show how to put your specific processes into DAX.
I have obtained the information from MSDN, Technet and related blogs.
Just to remind, I am not an expert in DAX but all recipes below work for me and I hope would be usefull for you at the beginning of knowing DAX.
I decided to share my little experience and show how to put your specific processes into DAX.
I have obtained the information from MSDN, Technet and related blogs.
Just to remind, I am not an expert in DAX but all recipes below work for me and I hope would be usefull for you at the beginning of knowing DAX.
Friday, June 7, 2013
Integration JasperReports into Oracle E-Business Suite (OEBS)
Some years ago I was asked to design a report in MS Excel format in OEBS. Also received xls file had to be zipped and sent by email. Last two requirements could be easy implemented using Java. Since I had already decided to use Java I attempted to integrate JasperReports into OEBS too. In my oppinion JasperReports is more powerful reports' generator than Oracle Reports 6. Withal JasperReports has build-in export a report in xls format.
In those days I used OEBS 11.5.10.2. It had jdk 1.4.2_04 on board. There were some troubles with choice of JasperReports version. Although JasperSoft declared that last version compatible with jdk 1.4 was 3.7.1, in my case only 3.2.1 version shew stable work. Unfortunately I can't find respective link on Jasper Forum now to prove this assertion.
Well, let's do, step by step, all things we need to receive a simple report in xls format.
In those days I used OEBS 11.5.10.2. It had jdk 1.4.2_04 on board. There were some troubles with choice of JasperReports version. Although JasperSoft declared that last version compatible with jdk 1.4 was 3.7.1, in my case only 3.2.1 version shew stable work. Unfortunately I can't find respective link on Jasper Forum now to prove this assertion.
Well, let's do, step by step, all things we need to receive a simple report in xls format.
Monday, February 4, 2013
Invoking RESTful web service in Oracle PL/SQL
UTL_HTTP package allows to invoke web services via pure Oracle PL/SQL. Here the invoking of RESTful web service will be shown. Obviously, server where Oracle is deployed must have an access to host with web service.
To perform of the invoking the following steps should be done
To perform of the invoking the following steps should be done
Saturday, January 26, 2013
SUM for strings in Oracle
At times I have needed in an aggregate function to build a list of varchar values in single row inside a group. Something like SUM aggregate function but for strings. I wanted to have for each group a list of strings separated by defined delimiter.
Monday, January 21, 2013
Parent/child dimensions in Jasper Analysis
Here I want to share my experience of using a dimension based on tree-like table. As database engine I used Oracle.
As known tree-like table is a table that has pair of columns, usually called as ID and PARENT_ID. Values of PARENT_ID column in children rows reference to values of ID column of their parents. Usually tree's element without any parent is called root, an element that has children is called node and an element without any children is called leaf.
As known tree-like table is a table that has pair of columns, usually called as ID and PARENT_ID. Values of PARENT_ID column in children rows reference to values of ID column of their parents. Usually tree's element without any parent is called root, an element that has children is called node and an element without any children is called leaf.
Sunday, January 20, 2013
Simulation of outer joins in Jasper Analysis
JasperReports Server (Pentaho Mondrian behind the scenes) doesn't use outer joins when parses schema file to build analysis view. Today, at least.
Here I am describing the one of possible ways to change JasperServer behaviour as though it can handles outer joins. We don't have to make changes in any configuration, the solution just encloses manipulations with SQLs have used in schema definition.
Here I am describing the one of possible ways to change JasperServer behaviour as though it can handles outer joins. We don't have to make changes in any configuration, the solution just encloses manipulations with SQLs have used in schema definition.
Subscribe to:
Posts (Atom)