About lps

lps · ‎06-04-2020

Hi all Thank you so much for your advice and suggestions. It works wonders.

lps · ‎06-04-2020

Hi I am trying to create a filter to apply to 'INP Module - No of Frequencies' so that result below can be achieved but am hitting humps. If the North Track and East Track in 'ss NE' matches the Track L2 column in SYS Module, then the Expected Result is that Serv under North Track and Serv under East Track should appear under East Track.

lps · ‎05-27-2020

Hi The above two DBs are to be assigned to Product Supply Managers. Whilst one of them is assigned via Landing DB, how can the other be assigned?

lps · ‎05-27-2020

@smithevan18 Below is the Saved As another view to be imported in FPA. In FPA, only All Regions data are read (as per mapping screen) . As expected, when this 'Run Import' was clicked, the import failed.

lps · ‎05-27-2020

@smithevan18 Below the screenshots. E.g. DEM04 FP&A model The Location and SKU Codes are in Column 3.

lps · ‎05-26-2020

Hi Is it possible to provide more than one: 1) landing page to one group of users? 2) master view to one group of users? I am asking this for knowledge enhancements and would like to hear from the community how these are addressed.

lps · ‎05-26-2020

Hi In importing from INV05 and DEM04 (both having Subsidiary Views which are used for mapping) via 'Connect to Anaplan Model', I tried different Saved View pivotings until I successfully imported from a Saved View with no page selector. Based on the various tries above, my observation is that the Saved View must not contain page selector in order such import to work. I hope this is not the case due to the number of rows that can potentially be generated (row limit per module?). Grateful for ideas from the community for further understanding

lps · ‎05-12-2020

@ChrisMullen, it works Initially I got an API error message in doing this and I found the solution to it (addressing the API issue) at: https://community.anaplan.com/t5/Known-Issues-and-Workarounds/Error-when-editing-an-import-data-source-in-a-model-that-has/td-p/49129 https://community.anaplan.com/t5/Anaplan-Platform/Amending-existing-Imports/td-p/30614

lps · ‎05-12-2020

@ChrisMullen I have the same error and tried remapping the data source i.e. Actions > Manage Import Data Sources. In doing this, I got a message stating that An import data source ("Level 2 Data Hub - .........) already exists for this object. I tried re-importing 9 Import data from HUB for Importing Historic Volumes and still got the same error : Model object "'DAT03 Historic Volumes'.Export" could not be located. Is there anywhere else I can check to trouble-shoot?

lps · ‎05-11-2020

David, yes, you are spot on with the concern. As data for both of these are imported, this leaves a potential for out-of-sync. I am aware that in a spoke Model, e.g. Supply Chain, subsets can be defined and thus eliminating the out-of-sync issue. There seems to be a potential for out-of-sync in Data Hub model as these are imported in SYS07 and SYS12. Please refer to @einas.ibrahim 's reply. I would like to hear from those who are experienced if importing this way is a best practice and what are the reasons not to define Distribution Center as subsets in a Data Hub model? Below is the activity for SYS12 from Level 2 - Sprint 1 - Data Hub

lps · ‎05-11-2020

@einas.ibrahim Yes, that's exactly my concern. The examples given were from the activities in the Data Hub model.

lps · ‎05-10-2020

Hi In the activities, we were to import into SYS07 - Location Details and SYS12 - SKU Details. The Distribution Center for the above were loaded. As they both appear to be independent, does it mean that there is always a chance of mismatch between them? E.g. In SYS12, Chicago is selected but in SYS07, it is not selected. If this is so, how can these two be integrated so resolve possibility of such occurrence. I am a newbie and just checking my understanding.

lps · ‎05-09-2020

@einas.ibrahim Oops, I meant Column E - Distribution Center? My apologies. So, basically, I have uploaded the same as your explanation except for Column E which I uploaded to Location Flat list as well in addition to SYS07 module. Hence, Distribution Center was uploaded twice. Reason why Column E was uploaded to Location Flat list (Subsets) was because it was defined in this model which was downloaded as part of the Activity.

lps · ‎05-09-2020

@einas.ibrahim Thanks for you detail explanation. I have uploaded the same as your explanation except for Column D which I uploaded to Location Flat list as well in addition to SYS07 module. Reason why Column D was uploaded to Location Flat list (Subsets) was because it was defined in this model which was downloaded as part of the Activity. I shall reload the Location Flat list without Column D. If I come across an Activity requiring upload of Column D to Location Flat list (Subsets), I'll raise a post here. At this moment, I find it interesting that 's Location Flat:Distribution Centers?' (refer to the screenshot above) was created without having to load Column D though I am sure I'll find out more as I proceed to the other Activities.

lps · ‎05-08-2020

@einas.ibrahim I hope I understood the requirements correctly Here are the details. Locations.csv The activities says to import above locations.csv file to Locations list. Subsequent activity says to use same Locations.csv file to import to SYS07

lps · ‎05-08-2020

@MaartenGijbels Thank you so much for your effort in this. I am getting the same result as your example based on the publishing of 2 separate page selectors i.e. 1) from Product (in which the module was published) 2) from Product Family (in which the module was not published) and synchronisation of these 2 pages selectors in DB. Thanks again for the validation.

lps · ‎05-07-2020

Hi I have imported Distribution Centre into Location Flat list and SYS07 Location Details. Is this the intent? It would seem that importing into both places would mean that any changes would have to be updated in both places. What is the purpose of importing twice in both places or are we to import into Location Flat list and use formula to reference the information into SYS07?

lps · ‎05-07-2020

@MaartenGijbels I could only managed to publish the PRODUCT list if I use the page selector from a module that has been published. If I want to publish the PRODUCT FAMILY page selector, I would have to use the page selector from another module that is not published.

lps · ‎05-07-2020

@MaartenGijbels, thanks. Out of curiosity, as the current page selector in the Saved View that is published to DB is Product, is there any way to publish just the Product Family (parent of Product) as Page Selector?

lps · ‎05-07-2020

嗨在仪表板-可选活动,应该the page selector for Product related be at Product or Product Family level?

About lps

Re: Boolean Filter to match List Subset and List i...

Boolean Filter to match List Subset and List in Mo...

仪表盘——产品补给和股票除外...

Re: Level 2 - Conclusion - INV05 and DEM04 - Impor...

Re: Level 2 - Conclusion - INV05 and DEM04 - Impor...

Dashboards - Landing Page and Master View

Level 2 - Conclusion - INV05 and DEM04 - Import wi...

Re: Level 2: Sprint 2: Error while running the 9 I...

Re: Level 2: Sprint 2: Error while running the 9 I...

Re: Level 2 - Sprint 1

Re: Level 2 - Sprint 1

Level 2 - Sprint 1

Re: Level 2 - Sprint 1 User Story 1 Distribution C...

Re: Level 2 - Sprint 1 User Story 1 Distribution C...

Re: Level 2 - Sprint 1 User Story 1 Distribution C...

Re: Level 1 - Dashboard - Optional Activity - Add ...

Level 2 - Sprint 1 User Story 1 Distribution Centr...

Re: Level 1 - Dashboard - Optional Activity - Add ...

Re: Level 1 - Dashboard - Optional Activity - Add ...

Level 1 - Dashboard - Optional Activity - Add Loca...

Re: Level 2 - Sprint 1

Re: Boolean Filter to match List Subset and List i...

Re: Level 2 - Conclusion - INV05 and DEM04 - Impor...

Re: Level 2: Sprint 2: Error while running the 9 I...

Re: Level 1 - Dashboard - Optional Activity - Add ...