The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

darpan13's avatar
darpan13
Contributor
4 years ago

Customize Dimension Filter based on Fiscal Year Period

SOURCE: ONESTREAM CHAMPIONS Hi Team, we have a situation in which we need to create a new dimension every month, and can obsolete the earlier one for the next period, that works perfect. no Issue...
dashboards
Parameters
NicoleBruno's avatar
NicoleBruno
Valued Contributor
4 years ago

Hi Darpan,

Is the filter the regular entity filter? If you can make it a parameter, you can set up that parameter to list specifically only the entities you want and maybe you have a dynamic dashboard - one for prior periods and one for the current period - that uses the two different parameters. Not 100% thought out on the dynamic dashboard but maybe it includes the parameter based on the workflow vs global time (provided you keep your global time current). If workflow time = global time, use the current period parameter/dashboard. If not, use prior period parameter/dashboard.
Take this as just a brainstorming exercise on my part as I clearly don’t fully grasp what you’re doing but maybe you’ll find it useful. Otherwise (and I know I’ve suggested this before), I always find an email to the support team useful for additional brainstorming suggestions as they’ve seen much more than I have.
Good luck.
-Nicole