About prabhu

Hi @AmruthaB ,   I tried ur scenario, it works well for me.           Thanks,   ... View more

Hi @ThiruT ,   Such kind of error occurs if you have access issues.   I also believe you need to be a workspace admin in both workspaces.    Please double-check & make sure you have that level of access.   Let us know if you are facing the same.   Thanks, ... View more

Thanks @fabien.junod. It really helps a lot.... ... View more

Hi @Rajasekhar,   PROBLEM 2:             Thanks, ... View more

  Hi @Rajasekhar ,   PROBLEM 1:               Thanks, ... View more

Hi @tompatrick.ting,   I am sorry. I know that i am late to this discussion but i replicated your scenario and it works well for me which means Numbered list codes in my data hub are automatically mapped to Numbered list Codes in my spoke model.   I am not sure why are you facing this.   But one question to you 1. Have you first loaded the numbered list to your FPA model...? I think you might have forgotten to load numbered list.   Before loading to the values or data to the module first you have to load the list.     Thanks, ... View more

Welcome 🙂 ... View more

hHi @kunal_311,   You should read the passage very carefully.   1.    Here you need to understand the particular sentence "USER Selects a month". You need to understand whether formula is needed or not. Also this statement clearly states when a user inputs in month dimension module then it should reflect in week dimension module.      2.   This statement says you have to study about summary type for boolean(ANY/ALL) https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Summary_Methods.html     All the best Thanks, ... View more

Hi @CommunityMember111277,   You need to check your Final Sales Targets Formula.   Check the example 8.2.5, This example will give you an idea (order which you have to follow in IF ELSE statement).   Work on Example 8.2. using paper and pen and get the logic correctly.   Your redistribution factor is different form the example.     All the best. Thanks, ... View more

Hi @CommunityMember111277,   You need to check your Final Sales Targets Formula.   Check the example 8.2.5, This example will give you an idea (order which you have to follow in IF ELSE statement).   Work on Example 8.2. using paper and pen and get the logic correctly.   Your redistribution factor is different form the example.     All the best. Thanks, ... View more

Hi @VGSonawane,   To Overcome this error follow these steps.   Step 1:   Go to Actions -> Import Data Sources   Step 2: Click the particular source object and select New Source -> Connect to Anaplan Model.     Step 3: Select the saved view in Data hub which you have created.   Step 4: Go to Actions -> Imports, edit the respective actions and map accordingly.     Step 5: Execute the Action.   if you face the same error "Model Object Could not be located" for other actions then follow the steps which i have mentioned for the respective actions.     Thanks,   ... View more

Hi @MadhabikaM,   Try my approach   1.      1. Lets say this is a module which i want to publish.     2. Create a system module and mark true for all child and set the summary as none.     3. Create a new Module with Product L1 as Dimension. and 1 line item (NO DATA)     STEP 1: Publish Product L1 Dimensioned Module.   The reason for creating this module is because, there is no functionality in NUX for publishing Page selectors. Only a module which has dimension can be published as page selectors.     STEP 2: Publish your actual Module (Product L2 Dimension)       Finally:     Thanks, ... View more

Hi @srishtinahata,   Please check whether this answers your problem.     Thanks, ... View more

Hi @srishtinahata,   Try this let me know if it helps     Thanks, ... View more

Hi @nehatomar,   I couldn't able to figure out why it is showing error, i feel formula is correct.   Make sure you have 2 dimensions in Emp03 Module (E1 Departments and E3 Role).   Try not to write everything in the formula, instead double click the formula bar and click the required line items. So that it should automatically populate.   or else split the formula into 3 portions to check exactly where the error occurs. 1. if Employed? then 1 else 0 2. if Employed? then Salary else 0 3.  'EMP03 Employee Drivers By Role'.Bonus % [ LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role ]   Thanks, ... View more

Hi @tompatrick.ting,   I need some clarity from your use case.   1. Does indentation means do you want to remove parent child relation...? 2. If you want to display only the child(Revenues, DOE, GAE, Net Interst) in the module then right click any list item and select "Select Levels to Show" and make "TRUE" only for child level.  3. if you want to display parent and child together without any parent child relationship                        then create a new flat list and import to the new list (start form top parent then next parent and next....). 4. if you want to only child to be present in a list then create new list and import only the child level.   All these import actions has to be taken with the help of system module. What you need to do is to create a system module with the existing list as dimension and create as many line items depends on the number of parent.   Eg: Line item 1                             Line item 2                ...........so on       parent(item(Dimension))       Parent(Line item 1)   I think @JaredDolich wants to deliver this. Correct me @JaredDolich if i am wrong...?   If my post doesn't answers your question please explain in detail.   Thanks ... View more

i @nehatomar ,   Can you share the blueprint view of EMP02, SYS08 and EMP03 module.     ... View more

Hi @nehatomar,   CHECKPOINT 1: It Seems you have written the formula twice.                                  Write it once.   CHECKPOINT 2: Check whether SYS08 Employee Details Module is created or not.   CHECKPOINT 3: Check whether Department and Country Line item (both should be list formatted line item) are created in sys08 Employee Details module.   let me know if you are still facing.   Thanks, ... View more

Hi @sosunkwo,   I assume that you are using a list to store the user's first name, last name.   Check whether the list is production or not.   if the list is marked as production then                 "you have to import once again in Test Model"   if the list is NOT marked as production then        "You should get the output" Share some screenshots, where you wrote  the formula to get the First and Last name.   Thanks, ... View more

Hi @BrandonEmbrey,   I also have encountered this.   What I used to do for such cases are.   Step 1: Create a text formatted line item in your existing module.                                          The formula should be the concatenation of the name of Dimension 1 & "-" & name of the dimension 2 & "-" & name of dimension 3.   for example, as referred to your screenshot, this line item should produce the output for the first record as Sales~10504004-Travel Fare~711005-Jan 20. and the second record should produce the output as Sales~10504004-Travel Fare~711005-Feb 20.   if the name exceeds 60 characters then replace it with code.   Step 2: Create an import action into a numbered list marking this line item as a code for the numbered list.   Step 3: Create a new module with this numbered list a dimension and 4(3 list format and 1 number format) line item. These 4 line items should be formula-driven, which means the first line item should extract  Sales~10504004, and the second line item should extract Travel Fare~711005 and the third line item should extract Jan 20 and fourth should extract its value from the module which you currently have.   Thus it helps you to produce multiple columns.   Thanks, ... View more

Hi @Sravan_Kumar,   Yes, we can do it.   read this article: https://community.anaplan.com/t5/Support/Model-copy-questions/ta-p/36577   This article answers your question.   Thanks, ... View more

Hi @nilanjan999,   Refer App Hub (https://community.anaplan.com/t5/App-Hub/ct-p/APPHUB), where you can see many anaplan models published by many companies.   Download supply chain model from App Hub.   Note: Models published by Anaplan are free of cost.           Models published by other companies are not free.   Thanks, ... View more

Hi @Jsdeloria21,   Try this if my approach works.   I am using select statement here because i am not 100% clear on your complete requirement and moreover you want to write a different logic for PARKING, that's why       Let me know if this addresses your problem   Thanks, ... View more

Hi @Jsdeloria21,   Can you clarify my doubts so that i will analyse your problem well.   1. i assume   Flr Area, units, SP(VAT -ex) are line items and Unit Mix is a dimension of a module.   2. Total/Average (Flr Area) = (Flr Area (Studio)*Unit(Studio)) + (Flr Area (1 BR) *Unit (1BR))+ (Flr Area(2BR)*Unit(2BR)) + (Flr Area (3BR))*Unit(3BR)) + Flr Area(4BR) * Unit *4BR)) /Unit(Total/Average   is it a formula written on Flr Area line item...?   3.  Total/Average (SP(VAT -ex))=(SP VAT-ex (Studio)*Unit(Studio)) + (SP VAT-ex (1 BR) *Unit (1BR))+ (SP VAT-ex(2BR)*Unit(2BR)) + (SP VAT-ex (3BR))*Unit(3BR)) + SP VAT-ex (4BR) * Unit *4BR)) /Unit(Total/Average   is it a formula written on SP(VAT -ex) line item...?   4. I tried to use Flr Area[select:Studio]*Units[select:Studio] and I got the Circular reference   in which module are you writing this formula..? and what is the line item name...?   Thanks, ... View more