I'm building a model with drillback to transactions.
Are there ways around the following behaviors?
1. If the SUM functions used to generate the drillable amount include time, the drill to transaction fails if the source module containing the transactions doesn't contain time (but uses a line item mapping transaction date to time). The only way I've been able to get around this is to create a false time dimension (i.e. list) ... so that the SUM statement isn't based on Native Anaplan Time, but rather based on a list value (that maps in native time). Short of adding Native Time to my transaction module, is there a simpler way around this?
2. When the transaction module opens (upon drillback), the column settings are always only default. Is there any way to present a view that has custom column widths (or saved view)? I have the default view customized the way I'd like to see it, but the drill to transaction ignores it.
Thanks!
Paul