About Star

Star · ‎05-27-2020

@einas.ibrahim Thanks for the validation. It certainly doesn't provide good User Experience. We'll have to make do with changing of page selectors until this is resolved.

Star · ‎05-25-2020

@Lkishko You need to: 1) Pivot the Line item to first column. 2) Right click the Shipping Costs line item and select Hide. Cheers 🙂

Star · ‎05-23-2020

@Misbah I like your detail explanation which is really helpful. In Step 4, where should the logic be written? What is the purpose of it?

Star · ‎05-22-2020

@Misbah If the Time dimension is not synchronised, then it will not synchronised with the time at the page selector which we want it to. Below diagram showing Time synchronisation removed.

Star · ‎05-21-2020

@Misbah Do you mean this? Reference - https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/POST.html

Star · ‎05-20-2020

@smithevan18 Thank you very much for your detail explanation. I finally got it 😀 and managed to recreate a sample for the benefit of those who need further understanding. In Anapedia, the diagram showed 2 boxed in orange. I would have thought -1 (Jun) should be boxed instead since the example given is 3,000 but I could be wrong.

Star · ‎05-20-2020

@smithevan18 Please refer to the details below: a) Confirmed PO Delivery = OFFSET(PO Submitted, -Final Shipping Time Weeks, 0) b) Confirmed PO Delivery Test = POST(PO Submitted, Final Shipping Time Weeks) With the above formulas, the results are as in Diagram 1. Am trying to understand why Confirmed PO Delivery is in Week 6 instead of 7 or is it supposed to be in Week 6. Essentially, am trying to understand the difference between OFFSET and POST. It will move to Week 7 if the formula is changed to OFFSET(PO Submitted, -Final Shipping Time Weeks - 1, 0) -> Diagram 2

Star · ‎05-20-2020

Hi 1) I am trying to get some sense on POST and OFFSET with the following 2 line items: a) Confirmed PO Delivery = OFFSET(PO Submitted, Final Shipping Time Weeks, 0) b) Confirmed PO Delivery Test = POST(PO Submitted, Final Shipping Time Weeks) and appreciate explanations on it. 2) If testing above, for Confirmed PO Delivery, if I switch to -Final Shipping Time Weeks, it did not push to Week 6 (2nd diagram). Why is that so? Thanks.

Star · ‎05-18-2020

In the following diagram, the FY18 and All Periods are displaying 30 as Jan is 10 and Feb is 20. I would like it to display the total that I can view, i.e. 10 and if I can view Jan and Feb, it should be 30 then. I tried different combinations of Any, None and All in the Summary Method and the results are either 30 or Blank. Is there any chance of getting it to display 10?

Star · ‎05-18-2020

@johhdorma, indeed it works. Thank you. 🙂

Star · ‎05-18-2020

@johndorma, you mean both the names of the dB are displayed or both the DB are opened? Sorry for this being so particular as am a newbie..... Not sure of the ins and outs of the system yet.

Star · ‎05-18-2020

Thanks for your explanation, @MaartenGijbels. Appreciate it. I am putting the details here based on our email conversations to close off. Please feel free to correct as necessary. 1) One would have to click on each individual dashboard. 2) There might be a situation that there are different Saved Views for the same module to be given to different roles. By virtue of having access to the module, they can invariably open a DB which they should not. But because they have access to the module, they could open it. That's why I asked if there is a way to restrict this access. One way to resolve this is to use the content panel to "guide", the users to the correct dashboards. (Not display dashboards that aren't relevant.) Regards

Star · ‎05-17-2020

The landing DB for the a) Product Family Manager is Global Demand Assumptions; and b) Account Demand Manager is Detailed Demand Review DB The Product Family Manager is able to open the Global Demand Assumptions and Detailed Demand Review Dashboards. 1) Is there any way for the Product Family Manager to open above both DB at one click rather than having to select open twice? 2) If we want to restrict access of the PFM to Global Demand Assumptions only, how can this be done? Thanks.

Star · ‎05-17-2020

@einas.ibrahim I got it 🙂 I had initially thought access to lists (Role ==> List) must be given in order for Selective Access to work, which I now understand as not required. Thanks.

Star · ‎05-17-2020

When I view Global Demand Dashboard as a Product Family Manager, I am able to view and change the Account list as per below: However, the Product Family Manager is not given access to Accounts list. I would have thought the Accounts page selector would not be accessible by the Product Family Manager. Would like to learn from experts on information relating to this.

Star · ‎05-17-2020

Hi Often, when I view the DB, it defaults to either of the following views: If it defaults to the first diagram, I would have to change the page selectors so that it changes to the second diagram. I would want to view as a default is the second diagram. Is there some setting that needs to be done to achieve this?

Star · ‎05-13-2020

@einas.ibrahim Thanks so much for your explanation and screenshot. Very helpful indeed. @Yash1 's suggesting was really good in proving that zero was not exported from target. The reason why I was asking in the first place was because I was looking at it from the perspective of model size. I thought zeros would take up space and was wondering why there were zeros in the target module when the source did not have. Thanks, again 🙂

Star · ‎05-13-2020

@MaartenGijbels @Yash1 Zeros are not exported. I tested by manually doing a Data Export (Include and Omit Empty Rows) and the Exported file are the same. @Yash1, I also tried your suggestion of using a negative number and changing the condition to Historic Volumes >0. The negatives were not exported. Again prove that zeros were not exported. The source model is pointing to the Saved View whereby zeros are suppressed. I then reset Target Dat03 Historic Volumes.Volumes to NO DATA and then to Number again. When it was set to NO DATA, the view was blank (not zeros). After switching to Number again, the blanks changed to zeros. So, the question is how to set these to blanks before even importing.

Star · ‎05-13-2020

Historic volumes are imported to Supply Chain model - DAT03 Historic Volumes from Data Hub model - DAT03 Historic Volumes.Export (Saved View). Data Hub model - DAT03 Historic Volumes.Export is a Saved View with filter criteria displaying Historic Volumes <> 0 so that data with zeros are not displayed and hence not exported. When this was imported to the Supply Chain model - DAT03 Historic Volumes, zeros seemed to be imported....well, at least they were displayed. I checked the Saved View file Data Hub model and the filter was applied. I am trying to figure out the reason for it. Has anyone encountered this before? Any feedback is much appreciated. Supply Chain model: Data Hub model: Saved View

Star · ‎05-13-2020

@MaartenGijbels, thanks for the validation 🙂

Star · ‎05-13-2020

Hi In the diagram below, the formulas for Current period? and Current period2? produce the same result i.e. Jan 20: 1) Current period? ---> CURRENTPERIODSTART() = START() 2) Current period2? ---> ITEM(Time) = TIME.'Current Period' In what way would they be different?

Star · ‎05-05-2020

@einas.ibrahim Got it. Thanks 🙂

Star · ‎05-05-2020

Hello @einas.ibrahim The Actuals can be input or imported.....more likely to be imported. Yes, you are correct. it would have been calculated in a transaction system and budget and forecasts are user inputs. Yes, saw the formula scoping. How is it then read in conjunction with Versions in the blueprint for a particular line item?

Star · ‎05-02-2020

@filip.sypniewski Thanks for your reply. I had a look at your screenshot again and got what you meant. Perhaps I did not specify in more detail of what I was trying to get at. What I am looking at is whereby there are more than 3 Versions lines....e.g. Actual, Budget, ForecastQ1, ForecastQ2 In the workshop, the example given was 3 Versions, hence, Budget? = NOT(Actual? OR Forecast?) was used. In a situation whereby there are more than 3 Versions, how can NOT be used or is there any other substitute function that can be used?

Star · ‎05-02-2020

@filip.sypniewski Because there are two versions of Budgets i.e. Budget 1 and Budget 2 or even more.

Star · ‎04-30-2020

Hi In defining SYS09 for Version details, Budget? = NOT(Actual? OR Forecast?) If there is an additional version called Budget2 as below, and Budget? is to be tick-marked under Budget (orange box), the formulas NOT(Actual? OR Forecast? OR Budget2?) does not seem work. Is there any other function that can be applied?

Star · ‎04-30-2020

@fabien.junod , @nathan_rudman Thanks for the replies and confirmation. Appreciate them.

Star · ‎04-27-2020

@nathan_rudman Tried using G1 in a module but seems like the calculation for countries is still required in order for G1 to be calculated, which in the example below would use just as much space. In this instance, REP05 - Test 2 --> Sales Revenue - Converted Region's formula is ''REP05 Local Currency P&L - Test 1'.'Sales Revenue - Converted'[SUM: 'SYS03 Country Details'.Region]' and REP05 - Test 1--> Sales Revenue - Converted's formula is 'Sales Revenue * 'FX01 Currency Rates'.Rates[LOOKUP: 'SYS03 Country Details'.Local Currency]' Not sure how your suggestion works. Would you be able to provide more information?

Star · ‎04-26-2020

Hi Each individual country enters data in their local currencies. However, for the reporting in USD, it is to be done at Region level only. There is no need for Country level. Right now, I managed to convert at Country level (REP05) and the Region data will automatically be rolled up. If I do not want to store converted data at Country level and I would just want to report in USD at Region level, how can this be done?

Star · ‎04-23-2020

@Filip.syniewski Oh, I missed that...got confused between 'fixed line item' and 'line items'. It worked. You're a star 🙂 Thank you.