Alternative to SELECT:TIME.ALL PERIODS?

ChrisAHeathcote · 2024-02-26T18:54:53+00:00

There was an error rendering this rich post.

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?

Accepted answers

rob_marshall

@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.

All comments

rob_marshall

@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

Quick Links

Can you help?

Unanswered questions

L2 Import DEM01
Hi all, i'm trying to import the file DEM01 csv but i don't know how to do it How do i select th evalue of DEM01 if the time value is on column? thanks a lot Andrea
ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…
Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…