About Sorna Raja Prabhu

Sorna Raja Prabhu

Hi @CommunityMember115525, Thanks for the reply, YES It is possible. It Can be done in 2 Ways 1. Click Insert button in versions and Create a new Version. 1.1 On the Right Side you can see Edit from and Edit to Column where you have to enter the time period. 1.2 If you want to insert more than 1 version, you have to create a CSV file, and you have to mention Edit from and Edit to columns for the version that you have to assign the time range. 1.3 Click import button on versions tab to import the CSV file into versions. 1.4 Finally you see the module with versions as a dimension looks like this. You can also place this import action into a dashboard for ease of use. Hope it helps 🙂 Thanks, Sorna Raja Prabhu

Sorna Raja Prabhu

Hi @CommunityMember115525, Can you elaborate, What is meant by as-of Version.? if you want the user to add versions in Anaplan YES it is possible: 1. It can be attained by creating an import action. 2. It can also be attained by pressing the insert button in version settings. Thanks, Sorna Raja Prabhu

Sorna Raja Prabhu

Hi @adpinto, Anaplan works well regarding export action. But the thing to be noted is Don't change the existing export action, instead create a new saved view from the main module and perform the export action and mark it as new saved export action. It Should Work. If my answer doesn't help please post some screenshot for better clarity. Thanks, Sorna Raja Prabhu

Sorna Raja Prabhu

@Sravan_Kumar We can revert back in 2 ways Option 1. Ctrl +Z Option 2. On Settings, we can see history, All our changes are recorded here. Check, where you have to restore, click on that history and select Restore to ID. Hope it Helps 🙂

Sorna Raja Prabhu

Hi @Sravan_Kumar As mentioned, we have to convert yearly values into weekly values. This can be achieved by using YEARVALUE() function. Hope it helps, Thanks, Prabhu

Sorna Raja Prabhu

Hi, This Can be achieved without using any function also, My Approach is I hard coded day count as 1. Notice, You have used Time Dimension in WEEK format, so you won't get the correct number of calendar days instead you will get the number of days based out of the week. Note: You can turn the summary off for certain line items if you don't need it. Hope it helps, Prabhu 🙂

Sorna Raja Prabhu

THANKS VIGNESH, IT WORKS. 🙂

Sorna Raja Prabhu

Thank you so much Lipchean, It works. 🙂 🙂

Sorna Raja Prabhu

Hi, I am facing a problem, can someone solve it, please. I have a module which has Employee, Time Range(FY01 to FY15) as Dimensions Line Item - IP(List format), Growth % (Number Format) IP Line item is user input, by selecting a list item from a dropdown. Growth % - Value(Name(IP)) - Will change to number format. Let's assume that the user enters the value in the IP Line item for an employee from FY01 to FY04. as a result Growth % is also calculated from FY01 to FY04 My objective is when a user enters (LAST ENTER) the value in the IP Line item for an employee in FY05. That particular value should be copied to till the end(FY15). Likewise when a user enters the value in the IP Line item for an employee in FY06. That value should be copied to till the end(FY15). For Example Emp-1 IP Growth % FY01 2 2% FY02 4 4% FY03 5 5% FY04 3 3% FY05 5 5% -----> Last Entered FY06 5 5% FY07 5 5% FY08 5 5%

Sorna Raja Prabhu · ‎12-11-2019

Thank's Vignesh. It Works

Sorna Raja Prabhu · ‎12-11-2019

Thanks Misbah.

Sorna Raja Prabhu · ‎12-11-2019

Thanks, Kavin If Current is marked as true for Actual Version, then writing a formula in Target Module (SourceModule.SourceLI) will populate the actual version's data. But, my purpose in writing the formula is to calculate the variance between actual and forecast. In this case, can't I able to use select particular versions to populate in my target module( if Current is marked as false in version ) Thanks, Sorna Raja Prabhu

Sorna Raja Prabhu · ‎12-11-2019

Hi, In version settings, I have 2 versions 1. Actual 2. Forecast but none of those versions are marked as True for Current (Refer screen-shot). I Created 2 Modules 1. Source Module 2. Target Module Source Module has Versions and Locations as a dimensions, Line Item - Source LI (Number) Target Module has Locations as a Dimensions, Line Item - Target LI(Number). When I write a formula(Source LI[SELECT: VERSIONS.Actual]) to get the actual value, It throws an error. After that When I Mark True as Current for Actual Version my formula works. May I know why my formula works if it is marked as true. A screenshot is attached.

About Sorna Raja Prabhu

Re: Creating an As-Of Version

Re: Creating an As-Of Version

Re: Saved Export Actions

Re: ALM Cell value

Re: Data import of different Dimension

Re: Days in Month

Re: Copy last entered cell value to all

Re: Copy last entered cell value to all

Copy last entered cell value to all

Re: Select Function using Versions

Re: Select Function using Versions

Re: Select Function using Versions

Select Function using Versions

Re: ALM Cell value

Re: ALM Cell value

Re: ALM Cell value

Re: ALM Cell value

Re: Days in Month

Curious to know the Best Practices for Model Clean...

Re: Days in Month

Re: Copy last entered cell value to all

Re: Copy last entered cell value to all