How to get Current Fiscal Year from Time, as a number, when Current Period is not set in the model

Hi, can I get help in how to derive Current Fiscal Year, set in Time, as a number when Current Period is not set in the model?

I see how to get year if Current Period is set with year(currentperiodstart()), but what to do when it's not used? We currently have a line item in a Time Filter module that requires the year to be input. I'd like to automate this based on the FY in Time so we dont forget to update yearly....is this possible-simply? It's not a big deal to input, but...

thanks in advance

Accepted answers

rob_marshall

@vazqulu1

So, without using the current period in the Time settings, no. But, what you can do, create an Anaplan Connect script that uploads todays date into a line item every. day, then you can turn that into your year. Also, the way that is shown and done, I would have done that differently and not hardcoded that line item to a year, in your case 2020. Instead, have that as an input on an Admin dashboard so it is easier to change.

Hope this helps,

Rob

All comments

rob_marshall

@vazqulu1

Hope this helps,

Rob

vazqulu1_*39348

Thanks for the quick reply!

That stinks, we should be able to reference, just like the current period. Maybe I'll submit for enhancement...I cant believe if no one else has requested it prior.

That was the reason for my post, I dont want this to be hardcoded. But, loading the day daily sounds like more work than desired. It wouldnt be correct for the first few months of the year, when the old year is not yet closed. For example, we are just switching to FY21 now.-- end of Feb.. 😞

rob_marshall

@vazqulu1

Oh, it has been requested (having a line item figuring out what today is), but it is a bit more complex than what people think. You have to take into consideration time zones as well as what is the date if you restore a model (is it still todays date or is it the date of when it was restored, etc.). With that said, it is on the roadmap, hopefully it will come out in the near future.

Rob

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…