About abhi1017

abhi1017

Hi @Epratt Check Summary Methods for Margin% Lineitem. Guess it should be set to formula rather SUM. This might be specified in the course content, please check and update the summary. ~ABhi

abhi1017

Hi @Epratt It Seems to be Syntax error. While writing a formula , refer the line items directly from the modules rather typing them. Here, refer/pull forecast period? line item directly from SYS00 module rather typing/copy-pasting the formula directly. ~ABhi

abhi1017

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

abhi1017

@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

abhi1017

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

abhi1017

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

abhi1017

hi @Jatendu , Your SYS03 module should be dimensioned by G2 Country list. Pls. share screenshots of SYS03 module to help you further. ~ABhi

abhi1017

You can Create and publish on the same page( along with other module views). P.S.:- Use the default module view directly to create the required view rather creating a saved view.

abhi1017

Hi @pdekas , We have done a similar requirement through NUX. 1.Use custom view in NUX rather module view 2. Use the EYE option and select the list that has to be customized 3. Select the list members from required levels. That should work. Worked for me. ~ABhi

abhi1017

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

abhi1017

Hi @lcapon Seems to be hidden. Pivot the module. Line items>> columns , Time >> Pages. If still not seen, right click and select show all. ~ABhi

abhi1017

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

abhi1017

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

abhi1017

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

abhi1017

What is the dimension of TEST module ? (Do you have time dimension in it?) Is aoa_2_region parent of aoa_3_pod .?

abhi1017

1. Create a module to select the region.(List formatted lineitem -region) 2. I have created a TEST module to create the graph. Assuming Salespersons = Countries rollling to regions. The filter line item here is used to filter based on region selected from Select Region module created above. 3. Create a saved view in the test module with filter lineitem as filter. 4. Publish Select lineitem from Select region module as field card Publish Saved view on NUX. PS: Once you select a region from dropdown ,refresh the page and chart will reflect the selected region. Hope it helps. ~ABhi

abhi1017

Hi @DarrenS 1. If its NUX ,you could directly select to show only the region level from page selectors and sync the page. 2. Classic NUX - Create a filter A filter module with a list formatted region line item. A boolean formatted line item in the graph module referencing the above region lineitem. (Item(region)=List formatted) Use this boolean lineitem in Graph saved view to filter w.r.t to the region selected. ~ABhi

abhi1017

Hi @DarrenS Yes, you can setup a filter. If Salespersons roll up to the Country/region then automatically Salespersons will be displayed based on the region selected. (But this not the case here) If Region is an attribute of Salesperson ?(If yes, then what is dimensions of your graph module.?) Could you please share a screenshot of module/graph. ~Abhi

abhi1017 · ‎04-06-2021

@lcapon Do you want to see only 2020-2021 in the module and the respective months.? If yes , then you need to change the No. of Past years in time settings to 0. Pls. check your time settings with the screenshot above and change it as depicted. Else you need to create a filter as you have created for months. ~ABhi

abhi1017 · ‎04-06-2021

Hi @lcapon , 1. Check your time settings. Should be something like in the screenshot below. 2. The module is dimensioned by Weeks and in order to create a line chart you need data at month/period. So you need to create a filter to filter the module by months using a SYS00 Time Settings by Month. Save the view once filter is applied on filter. Use this saved view for Linechart. ~ABhi

abhi1017 · ‎04-06-2021

Hi @tonybol The error is due to the Timescale in CSV not getting mapped to the Anaplan Timescale. Use Custom Fixed-Position Pattern as highlighted in the screenshot below. In the Box you need to type the same format as it's in the CSV. In this case format should be :- YY-MMM Edit the Action , update and RUN. ~ABhi

abhi1017 · ‎04-06-2021

Follow Steps 3 & 4 from the previous post for the respective action.

abhi1017 · ‎04-06-2021

Hi @lcapon The reason for this error is because Source object is missing/unmapped for the import action that you are executing. 1. Go to actions >> Copy the Source Label for the Import action 9.1 and use the search bar to search in Actions > >Import data sources 2. Click edit and locate your saved view in the datahub which you have created and update it. 3. Go to Actions -> Imports, edit the Import action 9.1, Check and update the mapping. 4. Run the action 9.1 ~ABhi

abhi1017 · ‎04-06-2021

hi @austin.call Yes, i had encountered the same issue. I had Dev, QA and Prod in one NUX app. Now, moved Prod separately to a new app and optimized all models, and the lag has reduced to max 5sec for Dev and QA. The time Lag while switching from one model to another is based on your model performance. Optimized model is directly proportional to the loading time. Better optimized model ,reduced loading time. But also have encountered cases where the model is optimized in best possible way but is still takes considerable amount of time for loading. You could move the models to another apps based on the Users and roles. ~ABhi

abhi1017 · ‎04-02-2021

Hi @ZachChurch I guess you have activated Selective access for G3 location list. Go to General List and untick all Selective access check boxes. ~ABhi

abhi1017 · ‎04-02-2021

hi @ZachChurch Since E2 Employees is a Numbered list you should map with code instead of Employee name. Map E2 Employees>> Column 2 : Code Numbered lists are read by codes.

abhi1017 · ‎04-02-2021

The mapping is incorrect there hence you see the error. Map:- Family Name >> Product Family Blank >> Parent Family code >> Code Similarly you need to do for E1 departments as well. Product Family is the highest level in hierarchy hence you don't need to map any parent to it.

abhi1017 · ‎04-02-2021

Step 1.- Pls create and run import action for P1 Product family and E1 Deparments. Step 2:- Run E2 and P2 Import actions. Note:- Only if step 1 is successful and data is visible in those lists ,step 2 will be successful. Else share screenshots of P1 and E1 import actions

abhi1017 · ‎04-02-2021

Could you pls share screenshot of your E1 department list.?

abhi1017 · ‎04-02-2021

Is your E1 department list populated ? If not pls update/populate that list first as E1 department is parent of E2 Employees. Then run the E2 Employees action. Share screenshots of E1 department if problem persists.