Hi Everybody, For some reason, in my Has Data? Query, I get this with the right formula, with everything true? To get my volume upload to work, I had to change both the module and the volume line to "…
Hello, An import I have is importing "mysterious", untraceable numbers into fields. I have a module with dimensions of time (month), B3 Sales Org, P2 Material. The line item I want to snapshot is "Sal…
Hi All, I'm trying to import data into the list P3 SKU . I couldnt find the view Build SKU in SYS12 SKU Details module though i have created and see it in the left pane Any suggestions Thanks
Hi Everyone, I am able to do the exercises but struggle to understand what is happening conceptually, given I am used to an excel world in finance! For example, with employees, at it's simplest: I wou…
I am trying to create a saved view in DEM03. I have pivoted and filtered the data, but when I try to show only the Baseline and Initial Demand Forecast I get this error. I get the error when I select …
I'm trying to import the product.csv, but I can't seem to make it import properly. It's importing the product code instead of the name, which ends up leaving out important data such as the size and th…
Hello, I'm having an issue in which a sum of rounded items is still showing some unexpected decimals. See screenshot below. Is there a workaround for this other than using formula as the summary metho…
Hi there, Module 1 has a model calendar, and module 2 doesn't use it. The model calendar has two future years & past years. I wanted to summarize the boolean of Module 1 in Module 2. I didn't get the …
Hi all, I currently have one line item with 2 dimensions, and the numbers are percentages. I essentially want to strip out one of the dimensions in a new line item but to have all the percentages mult…
Hi, I have the following module: Lists: E1 Employee Time: Month Versions: - Line Item: Salary I need a pivot with the employees as rows and month by column. All fine uptil now. But then I would like t…
Hello, We have a dashboard which features a smart filter for sales rep. When you select a name from the smart filter, the corresponding grid's selector only holds the accounts owned by that rep. This …
I'm looking to ensure my modules are as small as possible. In addition to other optimizations I would like to ensure every list item that is contained in some of my bigger reporting modules is needed.…
HI, Have a module with assets and time dimension, some of the assets starts from the middle of the year. when on selection of total assets, The "No of payments" lineitem not showing sequential numbers…
Hi, Would like to know how to create a Formula with the following structure for a Line Item (1). Closing Balance of Line Item (2) as of the end of the month, and this will show/happen only on the 10th…
Hi, I started doing my L3 certification in 2021 and found that some of the data files provided in the training course had 2021 data while the Check your build sections had snapshots of 2020 model data…
Hello, I've tried a handful of combination with this import, but I'm just not grasping the mapping concept even after the tutorials. Could someone please help me match this up? Thanks
hi, have 3 lineitem, a, b,c wherein c= a+b, a = previous(c), b= a*rate of interest, But, however, getting a circular reference when writing a formula in the lineitem "b". Below is the screenshot of th…