If I forgot to enter a value or made it as blank in a cell in grid, how can I show a validation or something that will prevent me from saving that particular grid without that data.
Can somebody please assist me in getting a workaround for the same.
Anaplan does have some limitations in regards to data validation. Specifically, it cannot prevent a missing value. In addition, it can't prevent many incorrect values.
This said, there are some things we can do to flag bad (or missing) data, as well as prevent that data from being shared in downstream models or applications.
First, we can use Conditional Formatting to highlight where values are either invalid or missing. In most cases, the conditional formatting rule is tied to a 2nd (often hidden) line item that contains a formula that evaulates to some specific numbers that help control the related conditional formatting colors.
Second, where data is being exported to another model (or application), we can apply filters that remove the bad data from the export, so that only validated data gets exported.
It goes without saying that we can create (what I refer to as) Audit Dashboards that allow us to quickly see our key data filtered to only show invalid (or missing) values. This way, we can fix things without having to search too long.
Cheers!
Thank you so much paul for the woraround.
Hi, i have a source that uses a connection to Skutrak, and i selected 3 columns when i created the source, now i want to bring in a 4th column, do i have to recreate a source from scratch and then use that in a new transformation view and do all the work i did again, or can i update the source column selection, and add the…
We have 2 dataspaces (Training and Current), the training one had a link to a list in a Model. When i tried to add a link to the same list in the Current dataspace, the link showed as ticked and i could not select it. Does this mean you cannot link to the same source in 2 different dataspaces? It shows a tick in the LINK…
Would someone advise how to find the App hub. I am following the module directions but I do not see it on my end.
