About SudhirY

SudhirY · ‎12-05-2021

Is there any issue with the formula for Local Currency? - Although it's fetching the correct result, want to check if there is anything else I'm missing. regards Sudhir

SudhirY · ‎12-01-2021

The screenshot in lesson 3.3.5.3 also displays incorrectly. I think it should look like this instead of Maybe I'm yet to discover this in upcoming lessons.

SudhirY · ‎11-29-2021

The course video stopped at 6:51 and was not able to load further.

SudhirY · ‎11-29-2021

Hi Jared, I was able to build the classic Dashboard, but when it comes to synchronizing at hierarchy P2 Products the Dashboard is not refreshing for change in the SKU selection, I'm I missing anything? To be specific, if we change the SKU page filters to an SKU of a different product category the table is not refreshing automatically. The table is refreshing only if we select the product category and then the specific SKU under that.

SudhirY · ‎11-28-2021

You got the right Growth Percentage. please check the Baseline Forecast.

SudhirY · ‎11-14-2021

It worked, however, the L1 13 is not loading yet, remaining lessons in L1 are loading properly.

SudhirY · ‎11-12-2021

Hi All, when even I login to the Learning.anaplan.com I see the below confirmation window pops up on every refresh inspite of providing the Acceptance confirmation. Wondering if this something local to me or anyone else facing this issue as well? In addition the course content is not getting loaded - appreciate any inputs. By the it was energizing Anaplan Event and picking my sleeves up to complete L2 before 2021 close. regards Sudhir

SudhirY · ‎04-28-2021

To fix the issue we had to use a new line item in time filter module with Brough Forward feature enabled and it worked!

SudhirY · ‎04-28-2021

Hi @AaronW , We got management blessing today to go with soft pilot of the POC model we build in Q1. Looking forward for a smooth pilot early May.

SudhirY · ‎04-27-2021

Thanks, @ChrisAHeathcote for the earlier response. We figured out the issue is driven by the Brought Forward selection. If we disable it then Time Filter module is visible. In the scenario I'm handling I need to use the Brought Forward feature. How do we overcome this issue as we need to publish few saved views in a dashboard for user input? #Broughtforward #Timefilters

SudhirY · ‎04-27-2021

They are the same time dimensions - Model Calendar - Months.

SudhirY · ‎04-27-2021

I created a new Module 'Time Filters' but still, I don't find that appearing in the filter view in the working module.

SudhirY · ‎04-27-2021

Hi All, Hope everyone is doing safe during this pandemic. I'm trying to apply filters on time dimension on a standalone basis, but unable to do unless I bring in other dimension to columns. When I change the view I lose the time filter based on a line item in the same module - 'Current Year?'. Any reasons why Filters become inactive with change in dimensions? How do we go about keeping filters active even after changing dimensions? hope there is a quick and easy way to deal with this than a long workaround. regards Sudhir

SudhirY · ‎03-01-2021

Enjoying the journey so far, I got the values into Collect Module for the second, third and fourth line items above, but strange, I don't see any values in the respective Report Modules. - shows Zero - I'm sure I should be missing something here.

SudhirY · ‎03-01-2021

Hi @JaredDolich @rob_marshall I tried the approach provided in the post labelled - Variance Analysis With Native Versions Made Easy. Unfortunately, it's not fitting my scenario as I can only fetch one data point for the scenario on Variance Analysis, my requirement is to pull four data points (fixed line items) overlayed with the specific variable time period and version as chosen by the enduser. I'm able to activate LISS Versions Transactions for only one line item of the four required. Appreciate any help here. regards Sudhir

SudhirY · ‎02-28-2021

Thanks @JaredDolich In the scenario I'm working with there are multiple dimensions and datapoints - it feels like the approach native version variances will complicate the model I'm working. Is there no other simple way to call a specific data point for a given version dynamically? regards Sudhir

SudhirY · ‎02-27-2021

Hi , I'm trying to pull specific data based on the version selected by the user. I tried using Lookup and Select but didn't work. Any smart ways to fetch the specific values from the selected Version dynamically? The table where User can select the Base or Compare Version - this is from the list items Trying to fetch data from another table for Variance Analysis Calcualtions. This is the list of Versions Compare Version General List Base Version General List regards Sudhir

SudhirY · ‎02-25-2021

Hi I'm looking for this functionality as well, what are the alternate ways to get the sum based on Boolean, please? regards Sudhir

SudhirY · ‎02-24-2021

Thanks, Jason, amazing and simple! you made my day!

SudhirY · ‎02-24-2021

Hi all, I'm trying to fetch Start Month of a Quarter input by the User. I created a line item for input by the user formatted as Time Period Quarter and another Line item formatted as Month. I tried multiple ways and looking for help to fetch Start Month (say for selection of Q1 FY20 - looking to fetch JAN 20 similarly for end month Mar 20). Tried below but didn't work regards Sudhir

SudhirY · ‎01-25-2021

We got an opportunity to take up an internal project, working on a prototype model by stretching the skills learned so far, completed around 25% of the scope. Thanks to the community members and also for providing the platform.

SudhirY · ‎01-21-2021

Hi All, Can someone help me how to hide zero-value line items in a model or dashboard (within the dimensions). regards Sudhir

SudhirY · ‎01-17-2021

Hi Rob @rob_marshall Extended your thought and came up with the following for previous year current quarter - do you see any issues with the multiple nesting of NEXT Function?

SudhirY · ‎01-17-2021

Thanks @rob_marshall , awesome it worked 🎯!

SudhirY · ‎01-15-2021

Can anyone help me what's the best way to identify - Current Year Current Quarter, Current Year Previous Quarter, Previous Year Current Quarter using DCA and Boolean.

SudhirY · ‎07-15-2020

Thanks Vignesh! I tried remapping the source model as well at each import step. When I do this I see a new line in Source Model screen. As and when I kept remapping the model, the count of sources and imports started to switch to the new connection. I wasn't sure what I was doing this right, but after your note and checking with other colleague, was able to figure out that its normal to have such issue with the first import process in SC Model. May be worth for Team Anaplan to clarify it its the intention to have two lines for the same source model. regards Sudhir

SudhirY · ‎07-13-2020

Dear Community, I'm facing show stopper while running the historic volumes import into Supply Chain Model from the Data Hub Model. I ensured the source model is mapped correctly in Supply Chain Model. Further also checked at the individual import step to see if the object is referred correctly. Still, I'm getting below error. "Model object "'DAT03 Historic Volumes'.Export" could not be located" Appreciate any help. regards Sudhir

SudhirY · ‎06-28-2020

Thanks Einas, realized it!

SudhirY · ‎06-28-2020

Dear APC, Can any one help me why I get to see mismatch in Employee names when the file used is same for creating the Employee List and Employee Details Module. I tried to delete the Employee list and re-created the new List and loaded employee names from csv file. Same csv file is used to load the Employee details - but failing to do the auto match. Its a huge list of Employees and I'm forced to do the manual match for 111 employees. This is time consuming and laborious. Not sure where I'm going wrong with this. Appreciate any help. regards Sudhir