-
Build Dynamic YTD/YTG with Non-Native Time
Hey Builders, I'm working on a project which requests a report that requires non-native time due to needing YTD/YTG at the end of each year to track variance on last year's YTD vs current year's YTD. The period to reference in the YTD is to dynamically change as the Current Period is updated within every year, regardless…
-
How can I change the name of the list as a text?
I have a list name 'Group' and it has "city", "state", and "country" as value. Then, I have other lists named 'City', 'State', and 'Country' and those list contains its own items. City = New York, LA, Chicago, Dallas...... State = NY, CA, IL, TX....... Country = US, CA, ...... In a module, I have three line items named…
-
Level 1 Model Building Exam - Model Building Activity 5
I got myself in a little bit of a pickle when I created the in SYS08 Employee Details. I created the Role item as a text format. Now realizing it needs to be a list item format. It will not let me change or delete the item. I am stuck in a pickle. Help! Any guidance you an provide is much appreciated. Thanks! Mike
-
Variance module using item subsets
Good morning team. I have a labour model that I am looking to add a variance module to and need some assistance understanding my options. As we have a number of different versions, using native versions for the variance is inefficient and will cause the model to grow much larger than required. The planning module currently…
-
Filter based on User dimension
Hi I am having 2 dropdown selections "Start Date & End Date" which is with respect to default users dimension. There is a date formatted line item (Load Date) in target module which is dimensioned by a list "A" and not having users list as dimension. Now, the target module needs to be filtered out based on the logic (Load…
-
How we built the famous word game : Wordle!
You all must be aware of the global phenomenon of “Wordle”. The way this little and simple word game struck the world is amazing! We loved this game so much, we tried to test our beloved software, Anaplan’s, limits yet again and tried to recreate this game on it. This is how we built Wordle on Anaplan inspired from…
-
LIS INDENTION
Hi Team, Is there a way to fix the LIS Indention of those identified as Parents, other than unticking the parent button in the source module, please? Please see screenshot for the sample indention being mentioned. Appreciate your assistance. Thank you, Elaine
-
Filtering based on User selection
Hi I have 4 modules, with hierarchy regions set up. All 4 modules with dimensions are described in ss. I want to apply a filter on last module for only the countries selected for particular user but I am unable to do it.
-
Import script as stopped working, but the manual import runs succesfully
I am importing data from Snowflake and successfully saving the csv file, this has worked for about 2 years They changed their column headers, I then downloaded the new format csv, and created a new import using this file, which works 100% However, when i add the new import to the script it crashes at the import stage…
-
How to use one of the column as a drop down or context selector in DAshboard
-
Line Item Subset SUM
Hi there! I have growth assumptions on different cost lines in module(A) where am using a Line Item Subset for cost lines and regular line items in different years. In another module(B), I calculated the Net revenues also using Line Item Subsets and the COLLECT() formula. Now I am trying to build a third module(C) where I…
-
Having a editable and non-editable grid
We have this list which has a Questions as a property This is the module where changes have to be made using DCA. First line item (Questions to ask) should pull the questions from the list DCA has been applied according to which first five cells have the read access and the next four have write access I want to have the…
-
Difference from hours
Hi All, How do i find from the start time and end time the difference and further convert to mins? Example : my start time is : 18.40 and end time is : 17.05 Another Ex : Start Time is :12.00 and end time is : 02.00 Thanks
-
How can I get PY Sales Revenue from Sales Revenue in a module without a time dimension?
I have a module without time dimension but there is a column with the sales revenue date. My formula for PY_ar date is just the ar_date minus 365. Can I leverage these two to get PY Sales revenue for a particular territory? I tried the following and got errors: Sales_Revenue[lookup: territory_id, lookup: PY ar_date] Sales…
-
How to make text rollup's at top level in hierarchy as blank and visible at other levels.
Hi Everyone, I am looking for a solution for text rollup's in summary in hierarchy. I have a model with 4 levels of hierarchy. In a module , I am using L4 Product list as Dimension. There I have added a Text Format Line item called " Client name" with summary as First Non blank. It contains formula to Identify which…
-
How will sync option work in dashboards
I would like to understand how will the sync option help to activate all the Grids with one selector
-
What is the difference between Time sum and Moving SUm
Hi I want to know what is the difference between Time sum and moving sum. Scenarios that we use them individually
-
Importing a list from Hub into Spoke Model
Hi Experts, I have an import set for a list from data hub to my spoke model. My concern - the list items in the list on Data hub keeps changing based on the updates made in the upstream system. As an example say in Nov - I had the id ABCD1 as a list member in Data Hub and also in Spoke model when data was pulled. Now in…
-
Error Message: Mapping have a common LIST format
Hi all, I am trying to assign the territory to the accounts that matches the attributes. However, because I am using the same list for my Product L2 and Product L3, I am getting the error below. I understand that this is due to my line item format be: build a product list hierarchy is not an option because I want the…
-
Level 2 - Sprint 1 Activity 1.3.6.4 Create Import Distribution Center Details Saved View
Hello, For the SYS07 Location Details I believe we need to have some formula to populate this table. This is a little tougher because these are flat lists that are not linked via hierarchy. Can anyone guide me help how to generate the country, region and distrubtion center in SYS07 ?