Alternative to SELECT:TIME.ALL PERIODS?

ChrisAHeathcote
ChrisAHeathcote
in Modeling

Hi,

Is there an alternative to SELECT:Time.All Periods which will allow us to query whether a line containing time contains data not equal to zero across all time periods. The target line item does not contain time.

I would usually just use SELECT but I would like to get the same outcome without having to use All Periods in my time frame.

Iv tried using ANY but cant seem to get this to work.

Thoughts?

Best Answer

  • rob_marshall
    rob_marshall
    Answer ✓

    @ChrisAHeathcote

    Hey bud….I think the only way to do what you want is to have All Periods. Now, you can definitely use a Boolean with an ANY on that. And with the top member, you don't have to use the select if your target doesn't have time.

Answers

  • ChrisAHeathcote
    ChrisAHeathcote

    @rob_marshall I already use ANY extensively in the model to validate mappings and so on. But you've confirmed what I thought that there isnt an alternative.

    I have thought about using TIMESUM to query a line to see if it is not equal to zero and therefore the dimensions at that intersection are in use but this will not account for movement which net to zero over time.

    Sometimes you just have to take the hit.

    Thanks for getting back to me so quickly.

    Chris

Categories