Hi,
I have a module where teams are required to input weekly but at a specific schedule
e.g. week ending 7th, 15th, 23rd, and last day of each month.
Is it possible to configure this?Thanks
@CommunityMember113484
If you model is using a weekly default calendar you can configure the format to be 'week ending.'
If your model is using a monthly default calendar it is not possible to use a time dimension to achieve this.
However, you could create a list and use this in your module.
You will then need to map this list back to a monthly time period using a systems module.
Hi Chris,
My model is dimensioned by weeks already. I've now changed to week ending, but I need it specifically for the dates mentioned each month: 7th, 15th, 23rd and last day of month - is this possible?
Thanks
You can set the correct sequence of weeks by updating the 'end of fiscal year'
Sorry for not getting this - I'm not getting w/e 7th, 15th, 23rd and last day of month?
It is not possible to create a calendar where the week ends land on the same day numbers each month as the length of each month is not equal.
How many weeks are you expecting to see in each month?
Are you using a 4-4-5 or other combination of weeks to build you model calendar?
Can you post a screenshot of your current time settings.
Yes using the 4-4-5. Current time settings below:
What you are asking for is not possible.
The closet I have managed results in the following;
Use the following settings;
The months simply do not follow the required pattern to generate what you are looking for.
Ah okay, thanks for your help. I did something similar in 2021 to get close.
Thanks again,
Has anyone gotten an error like this when you have SSO and you are trying to use the Excel plug in? We have some users that get the screen below but some don't. We have checked that all users have the same version of Excel. Weird part about the screen below is it actually says the connection was successful.
Hello everyone, We are trying to use Anaplan Connect in order to push data from a dwh to Anaplan Data Hub. To do so, we need an authentication by token. We can't make it work, we receive the following error: ERROR 16020 |-- Anaplan API: Invalid key path Any suggestions? Thank you all in advance for the help! Michele
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
