Column mapping not possible for a specific column?

Column mapping not possible for a specific column?

Steps to try first:
  1. Check the Setup Manager and messages window for any errors that may point to the issue.
  2. Look through the System Model for a role in the user table (None Found)
  3. in SQL run a query to check the columns in the table

When the application has to change from CD to TX it cannot have multiple values to switch to. After an adjustment to the data column mapping should function.

The reason the column is not appearing is because there is no primary key (or ID) in the view. The application requires a primary key either created in the design of the table or view before hand or a column that could serve as one. Be sure to check the system model for roles in the table and messages if you notice something is wrong with column mapping. The message window may point out the issue after regenerating the system model.

    • Related Articles

    • Application cannot find column mapping?

      If Arkieva is not fable to map the columns to the table,  the table is probably in another schema than the dbo. Even if you are able to map the column to other tables, if the table is in another schema, the column mapping will not function because ...

    • "Object reference not set to an instance of an object" error?

      This error occurs when the source table does not have CD values for the selected attributes. Column mapping must be done to whichever attributes you want to be able to sort by CD & TX.

    • Inventory Planner has no downloaded data?

      Check if the composite Id Column in the fact table only features zeroes. If so, execute 'UpdateCompositeDimensionsForConstellation'.

    • Connect to Azure Web Database?

      Currently it is not possible to connect to Azure because the database discovery service is not configured to work with Azure. 

    • Font size too large or too small?

      Arkieva does not display well when the dpi settings are too low or too high. We recommend changing the device's display resolution (if possible) to 1920 x 1080 and the size of text, apps, etc. to be 100%.