You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Smart View mass "validation" against PBCS - any better way to do this?

edited Aug 2, 2018 2:36AM in Essbase


Smart 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.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!