Hi @JaredDolich In SYS02 the time scale is already set to Half yearly. Also the formula is set to TRUE. But still the columns FY20 & FY21 appears in my module (DAT04 Distribution Center Parameters). However, in the 2nd point you have mentioned - ' Then use this line item as a filter in your saved view'. Can you please make me understand how to do this step. Thank you, Gourav
... View more
Hi @rahulborkar Inspite of 'hiding' FY20 & FY21, can I select (H1 & H2 FY20, H1 & H2 FY21) and do Select Selection and then save the file?
... View more
Hi, I am unable to get the result as per the screenshot with respect to Create Saved View for Export (1.6.3.3). I gave Time dimension as Half-yearly only. But still the columns FY19 & FY20 appears in my module ( DAT04 Distribution Center Parameters). Please find the screenshots for reference. Thanks in advance.
... View more
@ateodore Try this: Delete the entire Parent column in Roles.csv file and save it. Then delete the Roles list in the model and recreate the Roles list. Next import the Roles file (leave parent field blank). Then give All Roles in configure tab. And then try the formula - Gourav
... View more
Hi @AshokJosh When you click on import the file, rows and columns window will open. Then you change to 2 After that it will take u to Mapping window. Map it correct. Time: column headers G3 location: g3 location P2 product: p2 product Volumes: volume or fixed line item - Gourav
... View more
Hi @ateodore When you import Roles, at the time of mapping keep the Parent field blank. Later go to Configure tab and at the Top Level Item name it All Roles Then you put the formula and check. - Gourav
... View more
Hi @hannaaberg Sorry for late reply I better suggest you to delete the entire module and re-do it. The same thing happened with one of the cohortian. She deleted the entire module and did it again. Cheers
... View more
@hannaaberg Move employees to 'pages' and then see how it will reflect. Also please join this Slack group if you haven't yet https://join.slack.com/t/04certifiedmo-mkm8985/shared_invite/zt-zqjcsmqb-ByYg4FdiOH1jBGy987XuCA Thank you, Gourav
... View more
Hi @HemachandanReddy I got the result finally. I mentioned the Top Level (All Departments) to wrong list (--Employee Lists--). Later when I changed the Top Level (All Departments) to E1 Departments, then I results uploaded correctly Attached screenshots for reference. Thank you so much for the assistance - Gourav
... View more
Hi @gulmuneer Well I also faced same issues like the same how you have faced. But I had to redo the complete module, since I also did not get any other way to do changes. - Gourav
... View more
@HemachandanReddy Now there is one more error, data hasn't loaded for Shipping costs, Rent, Utilities, Shared Costs & Other costs. Please find the screenshots attached for reference. Thank you Gourav
... View more
@HemachandanReddy It has worked. I have given the Parent Hierarchy for E1 Department as "--Employee Lists-- (All Departments)" and the formula has been accepted. Thank you so much for the assistance - Gourav
... View more
@JaredDolich In the learning it was mentioned to copy REV04 and paste and do necessary changes like name change/dimensions change. I did it accordingly which did not help me to carry forward the 5.0%. Now when I deleted the REV05 module and recreated manually rather than copying, the 5.0% automatically carried forward. Thank you so much Jared for your time and help. - Gourav
... View more
@JaredDolich The formula do matches as per yours which was provided. Attaching screenshot for your reference. I also attached dimensions screenshot.
... View more
Hi, Need help for 9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module It was said to enter 5.00% for the FY19 Unit Cost % in REV04 Price Growth Rates module, but it hasn't carried forward to the Unit Cost% for FY19 in REV05 Price Growth Rates Staging module. Please refer the screenshot for reference. - Gourav
... View more
Hi Harsha, When creating import action we will see first window which talks about Data headers and Data Rows. So by default Header is 1 Data row is 2 Please change it manually and make Header as 2 Data row as 3 Once this is done and then you map Time - Column Headers (Change date format pattern: Periods -> YYYYMM) Location - Column 2 Product - Column 1 Line items - Fixed Line item Hope your result will come. -Gourav
... View more
Hi Jared, The model calendar has been set in the same manner. But still it's showing me in dd/mm/yyyy. Is there any other solution for it Thank you, Gourav
... View more
