What's the best way to create a truly dynamic input template?

Question

TS

What's the best way to create a truly dynamic input template?

Asked about 5 years ago

Always looking to improve our templates - we still have duplication of templates because we haven't found a great solution to truly dynamic rows (account codes that change based on Choose criteria) AND dynamic columns

Budgeting and Forecasting Software

Corporate Performance Management (CPM) Software

Financial Close Software

Comment

1 comment

1

Looks like you’re not logged in.

Users need to be logged in to answer questions

Log In

Alexandra H. · Answer 1 · 2020-07-08T10:33:24-05:00

AH

Alexandra H.

Director of Financial Systems at Campus Advantage

0

1

Answered almost 5 years ago

You have to map the choose options as their own measures and in a separate block. They have to be able to return independently from the the dimensions their choices determine.

delete edit

Looks like you’re not logged in.

Users need to be logged in to write comments

Log In

Reply

TS

Trevor S.

I'm not sure what your second sentence means. Could you elaborate more or illustrate with an example? In our case, we want to have separate Department Choices infer different parent level account code hierarchies. For example choosing Dept 1 will have mapped accounts 1000-2000 in rows 1-10 in the template while choosing Dept 2 will have mapped accounts 2000-3000 in rows 1-10 in the template.

delete edit

What's the best way to create a truly dynamic input template?

About Vena