Hi @Quentin, Are you able to provide some screenshots of the current set up? it's hard for me to visualize what the issue is. I'm thinking something must be wrong with the way the count is working at the lower level. If that team only has 5 employees, and you have 3 in dashboard 1 and 2 in dashboard 2, at the M1 level it would add up to 5. Thanks, Kathleen
... View more
Hi @stiwrx1 , Did you double check that the list which you have the line item formatted as (LTC06 Fiscal Month), has codes in the Production model? If the list is set up as production data, it may differ from the Development model. Thanks, Kathleen
... View more
Hi ruben.garcia@peakepm.com It seems like the issue is because you are not referencing the private key at all in the script. In the successful scripts that I have run on 1.4.4, you have to 'set' the public certificate (what you already have) and set the private key. See the example below. set CERTPATH="D:\prod_anaplan\prod_anaplan_connect\CAcertificate.pem"
set PRIVATEKEY="D:\prod_anaplan\prod_anaplan_connect\private.key:" Hope this is helpful. Thanks, Kathleen
... View more
Hi @Star To determine the first MONTH of each year (timescale set to month), I would recommend using a boolean formatted line with a formula along the lines of MONTH(ITEM(Time)) = 1. To determine the first WEEK of each year (timescale set to week), it is a little tougher. I would translate the week into a year so the line item would say FY18 for every week until reaching FY19 and then say FY19 for the 52 weeks. Then, you could have another line item that says if Year line item > Previous(year line item) then TRUE (i.e. would work out to say IF FY19 > FY18 THEN TRUE). Kathleen
... View more
Hi @sunilramakumar , You are using the WEEKVALUE() function, but trying to grab data from a yearly formatted module. What you really want is the YEARVALUE() function, so it will pull the yearly value into the week you are looking at in your target module. Kathleen
... View more
Is there a filter on time for the second view? If the modules are just referenced in the formulas, the Product Family Manager does not need to have access to them. If there is a module being used as a FILTER, the role needs access to that module to have access to the filter being applied. If the chart is using the second module, the chart should be fixed once the security on that second module is working correctly.
... View more
@davidmccarty Yes! Now if you try to run the import actions you shouldn't have any issues as all the data should be pulling from the Data Hub with your name on it now.
... View more
In the Settings gear, click on Source Models, click the Data Hub **Your Name** and then click Edit Mapping at the top and map it to Data Hub David McCarty. Hope that helps!
... View more
I would do something like this, I believe the Final Filter line item at the end here is what you're looking for. What I did was use 'Ratio' to get the parent level of Week to have a '1' in it even if the Week was not selected. See below for the blueprint. NOTE the applies to on 'Technical' is blank. The Ratio on Level 1 is Technical / Technical. The Ratio on Level 2 is Level 1 / Technical. Hope this helps!
... View more
It would be helpful if the references throughout the model to subsets of lists appear where you click on General Lists and have the three reference columns over to the right. Having the subset references separate, you have to click on the list, click into the subsets tab, and then scroll to the right to review the three reference columns. Since it is still all part of the list it would make sense for it to appear in the general lists. When going through all of the references to a list (for any reason) it is painful to have to remember to click into the subsets and check those references separately from the full list.
... View more
