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 im…
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 …
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 bee…
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 …
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 …
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…
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 …
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 und…
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…
Hi I have a month formatted line item in one module, how can I get a boolean line item to check off in that month in another module? In my SYS65, I have a month formatted line item "MOB to time" For e…
Hi there, I am trying to build this kind of P&L view : where 2023 FY figures come from another module where the line items are planned on a monthly basis. The idea is to forecast every year after 2023…
Hi, I have set up selective access on a list and limited the user to one list item. This works as from the context selector at the top of the page, they can only see the one list item I gave them writ…
Hi Guys, For an import from Data Hub to my spoke model for a module - I am seeing additional entries in my spoke model for a certain month that do not exist in the data hub. I looked at the history to…
Hi guys, I have created a saved view in one of my modules. my module has 4 dimensions + line items. Time, Cost center, GL account and version. My saved view has selected a few versions, cost centers a…
Hi, I have a line item which is equal to (Monthly income)/(yearly income). How can I reference the yearly income (or calculate it), I have the monthly income as input. Thanks
Hi, Good Day All. Does anyone know how to build the calculation modules that calculate a Factory’s production capacity. This is the formula I am using: Production capacity = number of machines*number …
Hi I have a module with employee details to calculate their monthly payout. The payout is based on the % attainment stored in the same module. The % attainment need to fall in a defined range (capture…