Union view basics and common issues in AX 2012Continue reading
Views in Microsoft Dynamics AX 2012 are basically virtual tables which contents are defined by one or more sources of data.
In Dynamics AX 2012 views enables you to use the power of SQL Server more efficiently than simply creating complex queries from the code.
Let’s imagine a situation where you want to combine data from multiple datasources. To achieve that you can use union views.
First you must create Union Query. When you do that you must remember about few things:
- Number of columns and their type must be the same on each datasource,
- There is no conversion between types (neither explicit nor implicit),
- You cannot use union query to update records,
- Field names that union query uses are taken from the first datasource.
For each datasource except the first one you will have the possibility to select UnionType, which is basically asking you if you want to have duplicates (UnionAll) or not (Union).
For the sake of demonstration I created two tables with one field of type string and one of type integer (which I will not use) and then created following query of QueryTypeUnion.
Next step I created a view and drag and dropped Query1 into it.
Next step is to select wanted fields from datasrouce Table1_1 into the (View2 -> Fields), if you for some reasons forget to do this you will have the following error:
“You are not authorised to access table ‘View2’ (View2). Contact your system administrator.”
Another issue that you might stumble across is when there is a mismatch between UnionType on datasource of the view and on the union query used or there are different QueryTypes on different datasources.
“Invalid column name 'UnionAllBranchId'.”
If everything was created fine and there are no errors, you can use your view in the system just like a regular table.
The retail industry is still dealing with the effects of the pandemic that lasted almost three years. In addition to this, further global events are causing disruption to the supply chain or financial stability of many retailers globally. As the industry confronts new challenges shaped by economic and geopolitical factors, it also faces trends influenced by changing customer expectations and needs. Here are 5 developments and trends to watch.
An interactive, AI-powered support for sales, customer service, marketing, and supply chain - Microsoft Dynamics 365 Copilot leverages generative AI and natural language processing technology to perform simple, yet time-consuming daily tasks that workload employees but can be automated.
Every company management facing a system change wonders what steps should be taken to ensure that this change does not cause turbulence to its business. Identical dilemmas are faced by any IT company that provides services to implement a new system. I will focus on these dilemmas today.
Artificial intelligence (AI) and machine learning (ML) technologies are changing business every day - just as new tools and services are frequently emerging to expand their use cases. PwC estimates that the impact of these technologies on the global economy will add approximately $15.7 trillion to its value by 2030 (1).