About mikeng

mikeng · ‎09-24-2020

Hi @anirudh Thankyou for your time to look into this. Actually I have already tried the solution given by you but it is not giving the result as expected. Here is the snapshot of my module blueprint: The underlying problem is that i need to consider previous SKU to cumulate the quantity and that too in seqence.

mikeng · ‎09-23-2020

Hi, Currently I am doing Pareto Analysis to identify top 80% of the Sku (S3) at Department level (B5) and at SKU Group (S1). The result expectation is like last 3 columns (F to H) Note: The Sum(1791) is the total of Sku at group for the year. Please assist your ideas to achieve this in Anaplan.

mikeng · ‎03-30-2020

Dear all, My company is at the end of the project and we've just found out the Selective access cannot show the total budget amount! Particularly, we have many expense category and for example Labor expense include personnel costs (owner is HR department) and non-personnel costs (owner is general affair department) and it's a must that they cannot see each other budgets. We've already set up the selective access for both but the PROBLEM is each one can see their items under their owned category but CANNOT SEE THE TOTAL of their budget. Please kindly advise: Is there any solution to this? Right now the only solution for us is to DISABLE THE SELECTIVE ACCESS and duplicate a lot of modules with subsets and then duplicates the dashboard for each owner and that is very frustrating for both Building and then Maintaining the model. What's the use of selective access if it can not show the filtered sum/total anyway? Thanks in advance. Regards, Mike

mikeng · ‎03-02-2020

Hi all, I'm having trouble with the sum function. I have the reference module [A] as below: Then I need to sum in Module [B] that only select the "SGA" element in "P&L Total" (which is a list) but I can't. The line item needs to insert the formula is "SGA" in the image below: I've tried all sum, select, lookup, select&sum to insert the ".SGA" but the formula still doesn't work. Please help! Thanks very much! Best regards, Mike

mikeng · ‎02-24-2020

It works! Thank you!

mikeng · ‎02-21-2020

Thanks @Misbah for your very quick response. In my case, the transaction ID is unique, there's no chance for duplicates. I've already test many times in which I just uploaded again without deleting the old data for a randomly chosen date (with all the data within that date) and the results are still the same, which means the new data with the same transaction ID replace the old ones, no duplicates. Best regards, Minh

mikeng · ‎02-21-2020

Dear everyone, My company is in the 1st stage of building Anaplan. Recently, we've managed to automate the process of data integration which is to import data from our server (Microsoft AX 2012) into Anaplan. To be simplified, we have 2 step. Firstly, a batch job will download data from server (pre-scheduled) to a local file, and then a script will upload data to Anaplan. I double-check the output and it's correct without x100. In Anaplan, there will be 2 actions: firstly, it will extract the transaction ID to a list, secondly it will import data to a module. And here comes the issue: the numerical value (money amount) is multiplied with 100 and I don't want that. We've been trying but cannot find out the problem until now. Anyone knows how to solve this? Thank you so much! Best regards, Mike

mikeng · ‎02-11-2020

Thank you. The solution of Misbah suits my case.

mikeng · ‎02-11-2020

It works! thank you!

mikeng · ‎02-11-2020

Hi everyone, I'm having an issue for my chart: Anaplan auto-generates ID number for Account names (Please see the chart attached). This is because The Unique items are Account codes, and there are duplicates in Account name (with different account codes). I need to eliminate the auto-generate ID so that, for example the last 2 Items: Recruitment (#67) and Recruitment (#183) will be just one Item "Recruitment". Thank you so much! BR Mike

About mikeng

Re: Pareto Analysis

Pareto Analysis

Selective access: Sum/Total does not work!

Sum with conditions

Re: Imported data automatically multiply with 100

Re: Imported data automatically multiply with 100

Imported data automatically multiply with 100

Re: Eliminate auto-generated ID in charts

Re: Eliminate auto-generated ID in charts

Eliminate auto-generated ID in charts

Re: Eliminate auto-generated ID in charts

Re: Eliminate auto-generated ID in charts

Re: Eliminate auto-generated ID in charts

Re: Selective access: Sum/Total does not work!

Re: Selective access: Sum/Total does not work!

Re: Selective access: Sum/Total does not work!

Re: Sum with conditions

Re: Imported data automatically multiply with 100