About UMAMAHESH

Hi-Experts,   I Have a requirement for that I need your help.   Module name: Summery module Dimension in the module - Time, Category, Product, customer   I wanna move to all products(except fruits) sales data to one customer(AR Channel). Fruits data move to another channel(FR Channel).     IF ITEM(Customer) = Customer.AR Channel then Sales upload.Total ELSE IF ITEM(Customer) = Customer.FR Channel THEN Sales upload.Total[LOOKUP: PRODUCT. Fruits] ELSE 0   But this formula was not working. How to move to some sales data to one channel and another portion of data to another channel.   Please help me with this   Regards, Mahesh     ... View more

Hi Experts,   We are using the Anaplan model from the last 3months.   Now, when I check the history I am not able to see any history of the model.   Is there any setting for showing history in Anaplan ??   Please help me with this.   Regards, Uma     ... View more

Hi Experts,   I have a requirement.i am confusing how to resolve this kindly help on this.   In One module       Row Axis - Product and Customer lists                               Column axis - Lime Item and time lists                                Page Axis - Measure list There are 5 line items. For each line item i want to saw different time periods that also based on user selection.   For suppose user selects 2018 year Then Line item 1 to 3: Show all years Line Item 4 : Show 2018 year only (Its possible by using filter but when i applying filter it shows only 2018 year and line item 4 only) But as per my requirement i want show line item 1 to 3 all years and line item 4 specific selection period. I Line item 4 period based on user selection.     Regards, Uma   Is it possible. Kindly suggest me on this ... View more

Hi Experts,   I am trying to export Module.   In the Module  Row Axis have:Product list    Column Axis:Line Items      Page axis :Time,Customer   When i try to export the module .CSV format. The data showing in excel like as followes.  Page selector dimension members showing top of the sheet.   But the requirement is need to be show as followes   Kindly suggest me on this.   Regards, Mahesh ... View more

Hi Experts,   I have a requirement and i am confusing how to resolve this.   First Module    Row Axis:Product    Column Axis:Line Items Second Module Row Axis:Flat Product  Column Axis:Line Items   Both Product and Flat Product have same members.   I am trying to multiply First Module line item * Second Module line item.   How to write formula different list items in different modules have same members.   i am trying to write formula by using lookup,Select,Sum function. but I am not able acheive the solution.   Kindly help on this.   Regards, Mahesh ... View more

HI Experts,   We have line items  Line item:1 :   FCST_1 Line item:2 :   FCST_2   based on FCST_1 convert into Rounded value.   Both line items are text format.   First item data in dot(".") format but we need to convert comma(",") And we need round off the FCST_1 line item.   For suppose FCST_1 = 1.2498   then by using some formula we need to convert into 1,25.   Hope you help on this   Regards, Uma       ... View more

Hi experts,   How to write "concatenate formula" in anaplan.   We have 3 proprties in Customer list. I want to concatenate first and second properties into 3rd property. The format of the properties is "Text".     Can you please suggest me.   Regards, Uma ... View more

Hi experts,   we mainatained joining date, Resigned date and last working day  properties in employee dimension.   Based on those properties we need to calculate previous 6 months Organization Active employees and resigned employees count.   We create one module called headcount planning module.In these scenario current period is july-2018. In these module we need to show the Position wise,Location wise actual headcount data. By using Joing date, resigned date and last working day properties we need to calculate data.   For eg: in Jan 18 100 employee joined in the organization and 50 employees are left. Then in jan month actual headcount is "Currently working employees+Jan recruited employees-Jan left employees. Same way we need to calculate previous 6 months actual Headcount data need to be display.   Hope you undestand.   can you please suggest me.   Regards, Uma   ... View more

Hi Experts,   In Employee list we maintained one property called Reporting Person. In Reporting person property we maintain reporting employee names for eg: manager reporting to owner , Supervisor reporting to manager,Staff reporting to Supervisor.   In Selection When i select Owner position then Show all owner combination data in one report Its working correctly. In second report we need to display all descendent members of Particular Owner. (i.e managers,supervisors,staff under Particular owner)     in the above screenshot Sravan is owner under his have some managers,supervisors and Staff employees.All descendent employees display in second report.         ... View more