About abhi1017

@Donna Marie    Yes, the motive of the task is to apply conditional formatting to the line items identified. You can use amount line items for CF rules.   ~ABhi ... View more

Hi @SriNitya    I guess this can be achieved by filter based DCA. 1. Create another lineitem override forecast. 2. This lineitem should be only be editable when forecast version is selected. 3. Apply DCA on this lineitem. Create another lineitem(boolean formatted) say Forecast edit  :- If Item(version)= Actual or item(version) = budget then false else true. 4. Apply this in override forecast lineitem in Write section. 5. Create a final lineitem where data is aggregated/pulled from the primary and override lineitem.     ~ABhi ... View more

Hi  @zbeat    Assuming the entire data is received as a bulk. 1. Create a unique list based on the transaction data.  2. Create a module dimensioned by list created above and lineitems in the excel/source.  3. Covert/transform the lineitem in date form depicted above into the required week format. 4. Now, use week formatted lineitem to pull the required data from the trasactional module using SUM/LOOKUP functions.   Hope it helps. ~ABhi ... View more

Hi @TamparaDora ,   In order to populate this module :- 1. This module should be dimensioned by P3 SKU. Check whether P3 SKU list has been populated with the data. If not, first populate the P3 SKU list. 2. Once step 1 is complete. In the SYS08 module, CODE lineitem will accept the formula you have written above. 3. Now, the task is to populate the data in distribution center line item in SYS08 module from the excel file provided in course content. While creating an import action MAP:- CODE (Lineitem in module)  >>  CODE(Column in excel sheet) Distribution Center (Lineitem in module)  >> Distribution Center (Column in excel sheet) Product Lineitem in module can be driven by formula as its parent of SKU so formula can be PARENT(ITEM('P3 SKU')) If you have problems in the import actions, check the existing actions in the model, similarly follow and map for the action you are creating.   ~ABhi ... View more

@harishroshan    1. Value of INV02 is not matching with course content  - Only first grid in in Course content could checked with INV02. Data in INV02 is depended on data in INV01 - Safety Stock exception count lineitem. This lineitem is populated based on ending inventory and Safety stock target. Hence,  check the values of ending inventory and Safety stock target lineitems (ex: summary method) 2. sku is not showing - In the course content depicted is a UX prototype which needs to be created by the learner. This UX prototype can be build using multiple modules. Therefore, the 2nd and 3rd grid in  UX prototype are from INV01.   If still not answered, may i know why you are looking for SKU in INV02..? Or could you please explain what exactly are you looking for, to help you in a better way..?   ~ABHi     ... View more

HI @harishroshan    Sorry , i guess i didn't understand your problem earlier. Now, Acc. to my understanding , you need to create a Stock exception review UX page. The view that you have built is right for the first grid as depicted in the course.   For 2nd and 3rd grid answer lies in the question you have asked. In country summary, stock safety flag i have given a formula but its not showung Sku list in the module, and if inv01 safety count flag should be ticked but what should be ticked? Think over and explore:- 1. Which module is dimensioned by SKU ? INV01 or INV02? 2. Can you create a saved view by Pivoting the dimensions as in Course content ? 3. Apply conditional formatting on Safety Stock exception count lineitem.   Hope it helps. ~ABhi     ... View more

 Hi @harishroshan ,   The formula you had written seems perfectly right. Just a small change though a major missing. Hint :- Check the time dimension of  INV02 module w.r.t INV01.           Pls. go through the course content again.   ~ABhi ... View more

Hi @shadmani    This a awaited update in the NUX. Might be raised on idea exchange. For now, you can achieve this by creating an export action with the properties required and publish it on NUX.   ~ABhi ... View more

@swapnil_J    The filter lineitem that u have created has version dimension applied to it ? If yes , pls. remove, if its not being referenced anywhere else. Else , create a new lineitem without version dimension to it and use this lineitem in NUX to filter the page selector.   ~ABhi ... View more

Hi @swapnil_J  Adding on to @abhay.kanik . You can apply this filter directly on the NUX DB while time is in page selectors. Attached a part screenshot that might give you a hint.   ~ABhi   ... View more

Hi @harishroshan    1.  For Beginning inventory IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory. The formula written is close but needs a little tweak in the first part :- Instead of 1st forecast year you need to use "Not 1st week of Timescale" as data has to be identified and fetched through a conditional statement  based on weeks .   2. Reorder flag my formula OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0 Seems Right.   3. shipping weeks  'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product] Shipping Time weeks is calculated based on the products and the type of  Shipping method used for the respective products. The formula is close, add shipping methods to find the right shipping time.   ~ABhi ... View more

Hi @lcapon    Its a Syntax error, try 'EP06 Current Employee Details'.Start date. Also, Create a module for ES005 Employee details attributes rather using list properties.     ~ABhi   ... View more

You need to create a filter as i had mentioned in earlier posts. And use that in this module.   Hope you are able to figure out else we can connect.     ~ABhi   ... View more

Hi @DarrenS    In the saved view, right click on the salesperson dimension>> Select levels to show >> untick Region. Save the view. Else share screenshot of the saved view.   ~ABhi ... View more

Set Time to "Not applicable" for filter line item. Then Formula should work. ... View more