Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor
4 years ago

Rule to Pick Scenario based on comparison between POV time and Time set for column in cubeview

Originally posted by Thomas Regehr Hello,  We have a report that needs to transition between the Budget scenario and Actual scenario as we move through the year.  Ideally the user will select a p...
Finance
ChristianW's avatar
ChristianW
Valued Contributor
4 years ago

Why simple if you can solve it complicated?

Here is the simple solution: T#POV.AllPriorInYear:S#Actual, T#POV:S#Actual, T#POV.AllNextInYear:S#Budget

you can find it here:

The other concepts might be helpful in more complicated situations.