Feedback

If any meta measure is added to the configurations, please ensure it is updated every time a change is made to the transaction line. For example, if I update the description of a product and press save, not only should the description be updated, but any meta measure with a corresponding column in the table should also be updated.

I have a dimension table that consists of several columns. Two of these columns are defined as NOT NULL and are automatically updated by table constraints. I want to update all columns in my dimension table using accoMASTERDATA, except for these two columns, since they are managed by the table constraints. These two columns are not shown in the accoMASTERDATA visualization. When I attempt to create a new row in this setup, I get an error because accoMASTERDATA tries to insert NULL values into the NOT NULL columns which resolve in an error. However, if I perform a direct INSERT INTO on my dimension table, I have no issues inserting new values, as the table constraints automatically populate the two NOT NULL columns. Is it possible to modify accoMASTERDATA so that it only updates table columns where there is a match between table column names and measure names? This would prevent accoMASTERDATA from attempting to update columns that are not part of my accoMASTERDATA visualization.