Main Request : I need to do in Board something looking like this :
1st pager must change impact selection of the first column, 2nd pager on the second column and 3rd pager on the third column. Do note that all 3 pagers are based on the same operational dimension : Scenario.
I have a hard time figuring out how to do that and I'm hitting many limitation of Board on these attempts :
- Interactive selection + Apply Selection to Block : Doesn't solve the issue as I don't have the possibility to add 3 pager on the same dimension
- Best idea so far : Duplicating my cube 2x times, replacing with a different "manually" replicated scenario dimension in each cube. It should allow me to have 3 pagers on the page and work well in the the dataviw two. However, it's a lot of work to ensure data synchronization and a lot of memory usage and disk space for only a display feature.
If you have any idea or opinion on the matter I'm very interested!
impossible request : Also user wanted to be able to reset default value for pager 1 & 2 when I change the value in 3rd one. For exemple, when you set 3rd pager to 2018 RF4, pager 2 is should reset to 2018 RF3 (your previous forecast) and pager 2 should reset to 2017 RF4 that is 1 year previous.
Side Rant : I literally can stand Pager anymore in Board There so much limitation and so many bugs. Can we have a complete overhaul of them even if it breaks backward compatibility?