About mpeck

Is it possible to set the scale of a conditional format to the Max and Min of the values being displayed.   It is often the case that depending on which end user is reviewing the data the values there in are vastly different and setting a max and min that is unervisal is impossible.   Thank you, Mark ... View more

I have a data set I would like to open to end user with a line item (Cost Center) set as a list(also cost center) with Selective Access enabled. I would like the functionality to filter the data set so that end users will only gain access to their respective Cost Center(s).  I know the workaround for adding cost center as a dimension, however this greatly increases sparcity and due to the size of the cost center list is detrimental to system performance. I'm open to other workarounds that don't impact performance. Thank you, Mark P ... View more

I am trying to use a lookup based on month to return versions. We have 12 versions one for each month in the current year. I was thinking I would create a mapping table with months as a dimension and format a line item as version to use a lookup. Is it possible to format a line item as versions. If not, any other workarounds would be appreciated. Thank you, Mark ... View more

I want to print my model map on a big sheet of paper so I can get a good look at it. Can I export the map to a PDF or similar document somehow? Thank you, Mark ... View more

Can I bulk copy data and formulas within a certain module? I want to move all of my actual data from a previous year into another version, but only for one specific module. My only solution so far is to export the data and reimport, which is tedious.  Any information is apprciated. Thanks, Mark ... View more