01-12-2022 04:12 PM - edited 01-12-2022 04:13 PM
SOURCE: ONESTREAM CHAMPIONS
Hi everyone,
Has anyone used the Dashboards for advanced line charts to show a few years of actuals and the current year of budget? I am trying to show actuals for 2019, 2020, and 2021 and 2021 budget by month and cannot figure out how to get this to come through. I set up a cube view with my account in the POV and the Time in the column and a combination of scenario and time in the rows since i don’t want to see budgets for every one of these years.
Thanks,
Cindy
Solved! Go to Solution.
01-12-2022 04:12 PM
Cindy
This may be suitable to your question. Advanced Chart Type is XY2D. Cube view has UD8 members on the row and Time by month on the column. The UD8 members are essentially: Actual Current Year, Actual Prior Year, Budget Current Year etc. The dynamic calc for each member leverages T#POV to return the appropriate fiscal year.
Terry
01-12-2022 04:12 PM
Cindy
This may be suitable to your question. Advanced Chart Type is XY2D. Cube view has UD8 members on the row and Time by month on the column. The UD8 members are essentially: Actual Current Year, Actual Prior Year, Budget Current Year etc. The dynamic calc for each member leverages T#POV to return the appropriate fiscal year.
Terry
01-12-2022 04:13 PM
Thanks Terry - what a brilliant way to solve this issue.
01-14-2022 05:36 AM
Nice solution @TerryLedet . Alternatively the same can be achieved using BI Viewer component.
I personally found the BI Viewer to be easier and more flexible than "Chart components" but it has its own drawbacks