Smart View mass "validation" against PBCS - any better way to do this?
SummarySmart View mass "validation" against PBCS - any better way to do this?
I was recently asked by an end user for an input spreadsheet to facilitate mass data input, with 'validation' of the members.
Boiling this down I created a template which has as many dimension members hard coded as possible, leaving only the minimum columns to be copied in as base values.
My idea being - 'paste your member data' between columns A to D (cost centre, account etc), press refresh, validate that all members have either #Missing or numbers against them, paste the numbers you want in e - whatever, press submit, validate that the numbers showing are now equal to the values you copied across.