About davargas

Hello, I am trying to create an inventory model for a bunch of server farms. i have one csv file with over 15000 machines. For each machine, it shows its location, its manufacturer, the model, how many cpu cores, and a cpu factor. I want to create a module that shows me the average of cpu cores x cpu factor per location. Because the csv file has over 15000 rows, I am not quite sure how I should import the file to obtain my target module. To start off, I want to have a module that just shows how many machines there are per location. So it would just be how many rows read back each location. Really stuck and now sure how to start. Thank you.  ... View more

Hello, I have a module with two line items. This module has product list on pages and line items on rows. 'Max Slots' has a formula that returns the MAX value of a given product from another module. For the other line item 'when' I am trying to return the month or time period that the MAX value takes place. I am trying MONTHVALUE but I can not get it to work. Any suggestions?  ... View more

I am trying to create a module with the following line items (dimensioned by products in pages and line items in rows, time does not apply). when a product is select from pages: Max slots - display max value across any month When -  display the month that the 'Max' appears Width Factor% - user input  Width Interval - display months where the values for selected product are > 'Width Factor%' of Max   This module is sort of a reporting module for my main module that shows the number of slots each product uses each month. Please help with the formulas for this reporting module(except for 'width factor%). thank you *note that 'when' and 'width interval' should both be able to display multiple months if necessary   ... View more

I have module D03 that shows how many slots each product family uses. D03 is dimensioned by Time on rows, and PR2 Product Family list and 1 line item 'Slots' on columns. I am trying to write a formula that 1. references data from another module, and 2. does some calculations for all the data in each item for PR2 Product Family.  IF      ITEM ('PR3 Product Name') = 'SYS06 Capacity Pointer'.Capacity Pointer THEN     'D02 Planned Capacity'.Corrected Capacity / 6 ELSE     'D01 Slot Forecast'.Slots   The IF and THEN part are for 1. It references data from another module and inserts it into a specific item in PR2  The ELSE part just returns the normal data for the module.   In this case, objective 2. does not apply to that specific line item in PR2, so it works perfectly to just enter the calculation in the ELSE part. I am trying to do something like this. IF      ITEM ('PR3 Product Name') = 'SYS06 Capacity Pointer'.Capacity Pointer THEN     'D02 Planned Capacity'.Corrected Capacity / 6 ELSE     'D01 Slot Forecast'.Slots * ('D01 Slot Forecast'.Slots('PR1 Product Lines'.All Products - 'PR2 Product Families'.other))   This doesn't work obviously because in the ELSE part, it is just referencing the list items rather than referencing the data corresponding to the list items in this module. I want the rest of PR2's 'Slots' to calculate (Slots * (Slots/(Total Slots-Other Slots)) 'other' is a list item in PR2 and 'Total Slots' is just the total of all slots in the module (also a list item). How can I reference specific data from the module when writing a formula? I want to make calculations using members of the list. In excel I can just click on a cell and write a specific formula, what would the equivalent of that be on Anaplan?  ... View more

I have created Line Item subsets and certain modules for filters for other modules. My ultimate goal is to assign different line items to different list items (across the hierarchy as well). I have  P1 Product Lines, P2 Product Families, and P3 Product Names. I have module D07 which shows how many slots each of P2 Family uses. I am trying to make calculations with the data but I can't because when writing a formula I can't reference list items, I can only reference line items. I am using this filtering method to assign certain line items to certain list items, but I can only do it to one Product list instead of multiple like I want (P1 and P2). Is there a way to set the 'Applies To' tab in the module blue print view to multiple lists of the same hierarchy? That way my filtering method can also apply to the P1 Product Lines List because I need the 'Total Products' as a variable for my formula.    For more info, see https://community.anaplan.com/t5/Anaplan-Platform/Chart-UX-Constant-Module-Calculations/m-p/143124#M38187 where you can see filtering method I am using.  ... View more

Hello, I am trying to build out a very specific UX dashboard. I am trying to create a chart that displays all the data from a single list AND also add one additional data row that is from another module.  Module 1: D01 Slots Pages: Version, Locations, Teams, Resources Column: Time Rows: Slots (Line Item), Products (20+ items)     Time (Months) Product Slots data (multiple rows)   Module 2: D02 Capacity Pages: Version, Locations, Resources Column: Time Rows: Slots (Line Item), Products (20+ items)   Time (Months) Max Slot Capacity data (single row)   I would like to create a new module, D03 that looks like the following: Pages: Version, Locations, Teams, Resources Column: Time Rows: Slots (Line Item), Products (20+ items)     Time (Months) Products Slots data (multiple rows) Max Slot Capacity Slots data (single row) Essentially just D01 with the addition of the one line item in D02. Both modules D01 and D02 have the same dimensions, except for D01 having 'Teams' as a page and D02 does not have 'teams' at all. The goal is to have a UX chart graph the data of slots per product and also impose the Max Slot Capacity on the graph as well. I have tried everything but still can not quite figure it out. Rearranging lists and system modules is not an option.  *Note: One of the list items for "Products" is 'CAPACITY'. I tried writing a formula for the 'Slots' line item to return data depending on the name, so all the items named 'CAPACITY' would just return data from D02 and boom problem solved, however that did not work either. ... View more

Hello, I am trying to build a UX dashboard that displays data from two different modules. In D01 Slots (PAGES: Version, Locations, Resource Groups, and Teams. COLUMNS: Time. ROWS: Product Names and one line item "Slots"). Module D01 allows me to see the number of slots each product uses. In D02 (PAGES: Version, Locations, Resource Groups. COLUMNS: Time. ROWS: Product Names and a few line items, the most important being "Planned Capacity". In the UX, I want make a chart that shows all the slots used by each product in D01 but also plotting "Planned Capacity" from D02. I've tried many things, but I just can not figure it out. I was wondering if there was a function that check the name of a list item and returns data based on the name. For example, in the list "Product Names" that both D01 and D02 use as a row dimension, there are items called "CAPACITY" that I would like to carry the data from D02 to display on the graph. I've come up with  IF   NAME (CAPACITY)  THEN  'D02 Planned Capacity'.Corrected Capacity  ELSE  'D01 Slot Forecast'.Slots I feel that I am either fairly close or very far off. If such function does not exist, then what other options could I try exploring?      ... View more

I am trying to build out a UX dashboard for a module that contains a list of products and imported data that shows how much resources each product uses(the resources is defined by one single number per month). In another module I have a specific line item that contains our total max resources (number). I am trying to create a UX chart that has all the data from module 1 but I want to impose the single line item data from module 2 that shows the resource capacity. So basically I am trying to create a graph that combines the data from two modules Is this possible at all? ... View more