Platform

Misbah

@karank Alright! Although the data set that is being exported is pretty small but running the script every minute is sort of aggressive. I would test it thoroughly with as many users in the system as there could be from the business (concurrency) and see if there are any issues. Thanks, Misbah

Misbah

@karank Well I had posted a similar query a few weeks ago where in I wanted to use Keep Alive Scripts which would have basically kept my model alive and it wouldn't have let model hibernate when there was an inactivity for more than 60 minutes. But that approach was turned down by David Smith stating its wise to let model hibernate like any other computer. Although you are not doing it exclusively to Keep Alive your model but indirectly you are keeping your model up and running all the time, which might have consequences in the long run - (don't have anything to back that up with facts) Thanks, Misbah

Misbah

@pradeep You are unable to make circular reference in a module -Can you please throw some more light on this? What is the requirement? Misbah

Misbah

@rob_marshall Thanks for your time! But the intention of using DCA was so that I could avoid having a Flat line for Line B which are showing zeroes before the Non Zero Value. The workaround that you have shown is actually the reason for me using DCA so that I do not get a flat line for Prior Months Zeroes. Hope that makes sense Thanks, Misbah

Misbah

Hi Planners, While I was working on graphs I found something weird going on while Publishing graphs using DCA. I am not sure if this is supposed to work exactly the way it is or is it a bug in the system. I have a Module with two line items Line A & Line B across monthly timescale I am using DCA Read Only for Jul, Aug & Sep and I am hiding numbers for Rest of the months - See attached document for snips When I publish the Line Chart graphs for these two lines I found that Jul, Aug & Sep Values of Line B are being shown in Jan, Feb & Mar Timescale - See attached document for snips I think DCA looks for first non Zero Value and places it accordingly in the timescale. Did anybody else experience this? Thanks, Misbah

Misbah

@Vladimir Not sure if I understood your requirement correctly. Is your requirement to generate two line graphs for two key figures (Budget & Actual) and Not taking Budgeted Zeroes into consideration while populating the line item chart for Prior Months. Isn't there any number sitting in Budgeted cells for prior months? Misbah

Misbah

@kdoan I agree with @caleb.maxson . Module to Module Imports are way better in terms of performance and effectiveness. Here is the article from @DavidSmith that may help you in understanding it factually. https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Import-from-File-vs-Module/m-p/54113#M8509 Thanks, Misbah

Misbah

@pradeep Your source model might have changed its place. You may want to to check the mapping in SOURCE MODEL and direct it to the correct source. Also see if the module has not been deleted accidentally. Thanks, Misbah

Misbah

@Chamanpreet None that I am aware of. It takes all the conditions for constraints and there is no way it can be ordered as per our preference. Thanks, Misbah

Misbah

Apparently there is no way we can publish line items as page selectors in NUX. We have dashboards which are driven by pick lists and NUX doesn't provide us the ability to do so. Thanks, Misbah

Misbah

@DavidSmith Thanks for Sharing!

Misbah

@DavidSmith I think this approach will work when there are new Exisiting + Delta Keys in the new file. Can such approach be taken when we want to see only the updated parameters of the existing unique key? Lets say Unique Key doesn't change but only its attributes change. Thanks, Misbah

Misbah

@MadhabikaM You have got to link the Temp Module with the Master Module Use FINDITEM function in the Temp module and see what is missing/updated from the master module. Create LineItem in Temp Module - List Formatted with Master List Formula should be FINDITEM(Master List, NAME(ITEM(Temp List))) Then Use LOOKUP function to pull the original parameters from the Master List and then compare. Thanks, Misbah

Misbah

@davraes First its invalid because there is no logic in the formula and you need to add few more paranthesis here and there as @kavinkumar suggested. However @Jared Dolich has already given you much more simpler, faster and effective approach of doing it. Happy Planning! Misbah

Misbah

@Jared Dolich How we have done it is by having System ID set to no expiration. However as per Anapedia - if your integration is SSO Enabled, it should work even if passwords have expired https://help.anaplan.com/anapedia/Content/Administration_and_Security/Tenant_Administration/Security/Certificates.htm Thanks, Misbah

Misbah

@Jared Dolich I think System ID has to be set for No Expiration from company's Network team. Not sure if there is anything that CA will dictate anything. Thanks, Misbah

Misbah

@VSekar Initial reaction to your query is that Anaplan lets you do that but doesn't recommend hard coding to list items. Also since it is a production list it will not let you do it directly (workaround is to have mapping module for hard coding). However can you please explain a little bit more on your requirement. Thanks, Misbah

Misbah

@gtrevino It is readily available you can download it but if you want to practice you can build it as well. If you are 299 certified then just download it and follow the instructions of uploading the files as and when required and if you are not then continue building it and make sure you watch all the videos and go step by step Thanks, Misbah

Misbah

@Ankur.Sonthalia 1. Nope, we cannot. Atleast there has been no communication from Anaplan on this 3. It doesn't eat up any space 4.As of now ALM refreshes the underlying modules, which in turn refreshes your pages on NUX. Hope that helps Misbah

Misbah

@usha.cherukuri If I understood you ask correctly, you can do it this way: Create a Line item which will clear out the data for the Periods Selected and more importantly store the data for the rest of the periods.And then you import the data into original line item. Lets say : You have a data in Module 1 Line item 1 and you want to clear out the data based on the periods selected. In this case create another Line item - Line item 2 and write a condition IF Time Boolean is checked(Module you might have already created to Check from which periods data needs to be cleared out) THEN 0 ELSE Line Item 1. Final Step is Import Line item 2 into Line Item 1 Hope this helps. Misbah

Misbah

@gtrevino Please go thru all the videos and listen to those carefully. Most of the answers are based on the videos. Go step by step by building Thanks, Misbah

Misbah

@pradeep Since this is a certification related question, community recommends figuring it out and doing it on our own so that we know what kind of things we need to look out for. However as @nathan_rudman already suggested Issue seems to be with the mapping. Even I feel it is so Here is a tip from my end: Your Line Items should be mapped as Column Headers or Fixed Line Item, You can map rest. Thanks, Misbah Thanks, Misbah

Misbah

@RobinSilk That would be your model built in Level 1 Training. Alternatively you could have downloaded it Thanks, Misbah

Misbah · ‎10-16-2019

@Niko1703 @DavidSmith Can you please guide him! Thanks, Misbah

Misbah · ‎10-14-2019

@usman.zia I am glad that you found it informative. Thanks, Misbah

Misbah · ‎10-14-2019

DON’T USE SHOW/HIDE FEATURE ON PRODUCTION LISTS We recently had faced an issue – On the dashboard there was one production list (Let’s say P1) as one of the dimension of a module. We had created a saved view by using Show feature on P1 page selector because we wanted to show only a few list items to the end user and not everything. Although we were able to see it perfectly on the Dashboard in the Dev environment but when we pushed the changes to the Production environment we found that there was an error on the same grid of the dashboard and the error said “No Access” on the page selector. We thought it might be because of the subsets have not been checked in the production environment but that wasn’t the case. We spent almost a day in our analysis and found out that it was Show feature that we had used on the P1 page selector. Most of us might already know that we shouldn’t use Show/Hide on the production lists but let me share my analysis on it anyway. Production Lists have the 12 digit unique identifier which an end user don’t get to see but in the backend Anaplan understands the list items thru their 12 digit unique numbers. For Example P1.ABCD When we use Show/Hide Feature Anaplan remembers that particular 12 digit number (from backend although end users see the description). Front End – P1.ABCD (END user see this) Back End – 123456789876 (ANAPLAN use this) - You have asked Anaplan to Show this Since this list is a production list, most likely your 12 digit numbers in the Production environment will not match with the 12 digit number from the Dev environment (because it might have been deleted once or any other reason) – hence the mismatch and the error “No Access”. Outcome - Always use Filters on the production list if there is any such requirement. Thanks, Misbah

Misbah · ‎10-11-2019

@Jsdeloria21 It would be great if you accept it as a solution so that this case can be closed (provided it solved your problem) so that other community members don't reply to your query Thanks, Misbah

Misbah · ‎10-11-2019

@Jsdeloria21 I think it is because of the time mapping issues in the import action. Can you please edit the Time mapping in the Import action from "Dates" to "Match Names". You should be good. Let us know if that doesn't work. Thanks, Misbah

Misbah · ‎10-11-2019

@karank Can you try this and see if this helps Remove Round Function from the formula and - and keep your decimal places in the output line item to 2 or 3 whatever your requirement is For example in my case I have kept the setting as as 4 Minimum significant digits & 2 Decimal places. I am getting the desired result because Anaplan automatically rounds it if you keep lesser decimal places than the input line item. See Screenshots in attachments Thanks, Misbah

Misbah · ‎10-11-2019

@vsbwofficial Assuming you are going with two module approach where your second module ( Expected Repair item return module) has Month in a dimension and Cee Cee Shop Module has Day as a dimension. Do following steps Go to Expected Cee Return Date Line Item in Cee Cee Shop Module and change the Summary to "Last Non Blank" for Time Period Then Go to the Second Module and Just refer the Expected Return date & Incoming from First Module as Anaplan will automatically roll up the numbers from Days to Months. No SUM is required. Hope that helps Thanks, Misbah

Platform

Academy

Master Anaplanner

Programs

About Misbah