About TGagnon

I am working to remove Gross shipment data that is no longer found in the source DWH feed.   Shipment actuals can be removed from the source data and I need to remove those not found in the source from the Data Hub and from the spoke planning model. When the shipment actuals are removed from the source them remain in Anaplan. I have found an option for this but I'm looking to see if there is a better practice for removing the now "bad" list items.   Option: After loading the transaction ID to the list I am loading the data to the transaction detail module. In the second import that loads the module I am using the "Which target items to clear prior to import" setting set to "All Items". This clears the data from the transaction detail module. Once the data is cleared I run a delete action on the list members. The delete criteria is set to check if a cell in the transaction detail module is blank. The also requires the transactions for all regions to be loaded into the Data Hub all at the same time and not at different times for different regions. It also prevents the Data Hub from being able to only send new or modified transactions daily.   Is there a better way? ... View more

Is there a workaround for selecting a non-number line item in a Line item Subset?   I've created a filter for increasing and decreasing the number of lines shown in a dashboard table using David Smith's outline in this post: https://community.anaplan.com/t5/Anaplan-Discussions/Filter-Line-Item-in-Module-view-based-on-another-Line-Item/m-p/31059/highlight/true#M418.    The problem I'm running into is only being able to select Number formatted lines for the dashboard table. My users have a comment field that I need to retain in the view. ... View more