-
Level3. Account Territory
Hello, I am using SYS07 to load territory data in QUO07. I understand that they have different dimension however, Anaplan accepted the reference but not showing the info. any hint how can I solve it? SYS07 QUO07 Thanks.
-
Level3. Commission Forecast
Hello, I have my total target per sales rep yearly as seen below and the numbers does match with ones in the study material: In the Commission forecast I am using monthvalue formula to compute the commission forecast but the numbers are not showing up. Please advise: P.S I have tried quartervalue also and it didn't work.…
-
Data not pulling in Dashboard from dource module
We have a problem. About us - we have a smaal-medium size model of about 23GB with about 200 users. We operate arou d 50 or so Business Units rolling up through Divisonal and Group structure Most User interaction is through Dashboard (though there is a fair amount of Excel Add-In reporting) which has DCA locking applied. A…
-
Level 2 Model exercise
Hi team. what is the formula to be applied for line item Has Data? in the spring 1 exercise 1.5.7.2 Add Formula to SYS13 Line Item the hint is not helpful regards, Baskar
-
Level3. Net Commission%
Hello, Can you please guild me what does "Net Commission%" represents? Thanks,
-
how can i do it ?
Module dimensions : time , lines , zone Goal : display lines following this rule
-
集計
製品の工場での生産データがあり、それを製品ごとに、各工場では何個生産したか集計した表を作りたいです。どうすればいいでしょうか。3つの工場で生産があるものについては、TRUEとしたいのです。
-
Need help for the optimizer error
Hi Team, We are getting error while running the optimizer. Can you please guide whether the error is due to time or some constraints or some data issue? Please find attached the image for your reference.
-
Error while updating formula for REV05 unit %
HI There, While updating the formula for REV05,I am getting the following error. Can anyone help me out. 'REV04 Price Growth Rates'.Unit Price%[LOOKUP: 'SYS04 Location Details'.Country, LOOKUP: 'SYS06 Product Details'.Product family]
-
Level 3. QUO06 Tenure Calculation
Hello, Can you please review my formulas here: i am not sure why I see 5+ years here for everyone: Thanks,
-
Level 3. Build Sales Role and Sales Reps
Hello, Sales Role and Sales Reps# are flat list in Sales Planning Model. In the Sprint2, the ask is to create import to build them up. I am using SYS09 Employee Details module in Data-Hub, but it is not working. Any Advice? Thanks
-
Boolean Filter for Salary Rank function
Hi, I want to only show the top 10 earners in each department (List hierachy E1 Department is top and E2 Employee below). I have created a RANK that will give organize numbers lowest to highest based on each department, But the numbers do not "start over" for each department. So there is only one department, that has RANK…
-
Level3. Create Action with filter
Hello, As explained in the Level3 study material, I added country and segment as properties to "G4T Territory>Account#" but I still can't see them in filter section when I create an Action. Please advice. Thanks
-
Help needed to get the data by pulling from two time scales
Hi, i want to get volume data based on the line item 2 to my target module which is at year level. But my source having the time dimension while i am writing the formula no values are coming
-
YTD / YTG Functions
Hi All, Looking for a bit of guidance here, around YTD / YTG functionality, do people tend to use the elements that are shown in the model calendar, or do they do in a different manner and if so how? I would appreciate any guidance and pro's / cons that people could advise. For reference, we don't use native versions,…
-
明細データの合計
下記のようなデータで、Flgの合計が1以上ならXのような式を作りたいのですが、どうすればいいでしょうか
-
dependent dropdown multiple condition
Hi, Is there a way to make a line item( dropdown list format) to have multiple conditions? example : I want my GL account dropdown to be filtered based on the account type selected (parent of the GL account) and based on the cost center selected? GL account is dependent on both the cost center selected and the account type…
-
How to import date from one model to another
I'm not sure if there was a new update that changed the process? I cannot import a date from one model to another. I am trying to import the dates from A01 to A06. I think the checkbox on the mapping page is new. I've tried different variations but can't seem to get it to work. Thanks in advance
-
TEXTLIST- multiple dimensions
Hi Could any Anaplan pros please assist with a TEXTLIST aggregation? I am not sure how I would do this over multiple dimensions. It is basically concatenating all the applicable pages numbers into one text based line item for each employee / report version / user. I have attached the blueprint. The line item I am trying to…
-
Formula for calculating Time Coverage
Hi everyone! I'm having trouble in resolving these request in Anaplan. Basically I've got 2 line items in a module with Time Scale Weeks: Expected Sales Quantity = Qty of Product that is expected to sell in every week Final Stock Quantity = Qty of Product in Stock in every week The request is to calculate for each week of…
-
L@ Model Building UX pg's
Hi, Not Understanding how to choose which Context Selectors levels are needed for certain List. It is on the Exam and I have watch the recommended videos and just need more explanation. Thank you
-
Breakback with rounded integer numbers
Hi, Is it possible to set a Breakback function with auto-rounding? We're working on a project where exploiting breakback is useful. Product units should be integer, never fractional, but we can't find how to auto round numbers derived from breakback function without setting a process. Is there a way to let user insert a…
-
Browser Slowness when Model Building
Has anyone else noticed that after 15-30 minutes of model building activity (opening modules, opening lists, updating formulas, opening split views, toggling from blueprint to module view, etc.) that browser tabs slow down and stop responding, and has to be restarted. Been an issue for a few weeks now. Hardware and…
-
Can someone plz post a relevant use case and user story related to investment banking
I have completed my level1 and 2 certification, I am looking to go little deeper into investment banking for an asset management company use cases, modules and lists. appreciate your feed backs and posts bala
-
Mapping time when importing csv file
Hello I have an issue when mapping the time when importing a csv file could you pleae help?
-
Mapping time when importing csv file
Hello community, I am blocked when mapping the time when importing a csv file: my model is set as Year and in my csv file I have a colum named Year with FY. I have error when mapping those, please see images below. Can you please give me some ideas?
-
Need a filter for FY months
Hi community, I need a formula to filter my module months based on current fiscal year. For example, if my FY is 24 (FY24), I want to filter the module to show all months for FY24 (Jan to Dec). After that, I want to show text 'Actual' for actual months and text 'Forecast' for forecast months. Below is a illustration of…
-
Level 1 11.3.4
Hi, Even if I enter the formula as instructed, The sample and answer are different. Any help is appreciated. Thanks. This is my model: This is the should be:
-
Level 1 10.2.6
Hi, Even if I enter the formula as instructed, it is not reflected. Any help is appreciated. Thanks.
-
Level3. Territory>Account module
Hello, I created a module in Data-Hub to transfer the territory>account to Sales Planning model in a numbered format to use as a dimension. However, I am pretty sure that something is incorrect with my module cause all the accounts listed in each territory repeatedly. Any idea what is wrong here? Thanks,