OLAPObjects copy input from n level

[shinymcshires]

I'm trying to publish a web input page via OLAPObjects Publisher 5.0. I've got two view expansions - a row and a column. There is a cube that is set up to allow for percentage or flat amount modifications (to n-level employee compensation elements). I've got the DBRW input formula within the row that is part of the view expand.

Ideally, it would be nice to only require the user to input once and have it applied to all n-level elements within the dynamic subset, but I can't for the life of me figure out how to do that (there's probably a way to do that with a rule, right?)

Here's the source spreadsheet:

whatif.JPG (191.85 KiB) Viewed 3275 times

And here's the resulting xml file:

whatifOLAP.JPG (218.35 KiB) Viewed 3275 times

Thank you in advance for your time.

[Mike Cowie]

Hi Richard:

So are you just hoping to have an input value repeat across employees? If the value doesn't change for each employee then you could capture it in a cube that doesn't go to the employee level (via a single cell in the workbook) and use it in rules, if needed. If you do want the value to potentially change across employees you can't exactly have a TM1 rule do this since a TM1 rule wouldn't let you change a value once the rule takes effect.

If you simply want to fill all cells in the expansion with the specified value, you could also take a look at the OLAPObjects fill functionality - this would let you, either through keyboard shortcuts or the addition of a fill button, push an entered value down, across, etc. It's basically like the Repeat option in data spreading, but it predated data spreading and we just stuck with the name "Fill", going forward.

There are probably other variations on this theme you can do via your TM1 model and/or workbook, too, but what I mentioned are the first things that come to mind.

Hope that helps give you some options/ideas.

Regards,
Mike

[shinymcshires]

Wow. I am in your debt. That worked perfectly! Thank you so much for your help (again!)!