About Misbah

Misbah

@saranshsaini In your import mapping... instead of mapping "Fixed Line item" to DAT03 Historical Volume Line Item use "Column 1" That should fix it Misbah

Misbah

@aishabhy05 If you wish to load the source file again then go to Actions->Import Data Source->New Source ->Upload New File (make sure that the name of the file matches with the file that was loaded earlier) I would have said since it is past 48 hours you need to upload the file again. But this made me think otherwise. @ben_speight what is the correct behavior here? https://help.anaplan.com/ebc01b56-7b57-4e36-93de-acfdb75a8441-Overview-of-Private-and-Default-Files#Access2 Misbah

Misbah

@saranshsaini Care to share your mapping screenshot.

Misbah

@Rahul_Rathod That functionality should be on the roadmap. That's what I believe.

Misbah

@saranshsaini Ah I see what do you mean. If you look closely they are different because one is for Products and another for SKUs. For example in your screenshots P3 SKU of Level 2 Model : all these codes are for Products and not for SKUs which looks right because all the SKU's have failed to Import. Now go back to your data hub and see if your source module view looks like this. If it is then check the Import mapping . Should be like this Hope this helps Misbah

Misbah

@dsoomar002 Nicely done! One stop shop for CA Integration related queries.

Misbah

@ankitaga2000 Drop an email to academy@anaplan.com Misbah

Misbah

@Shawnm See if this helps https://community.anaplan.com/t5/Releases/Announcing-the-Anaplan-Connector-for-Power-BI/ba-p/89942 Misbah

Misbah

@JaredDolich No,No,No. That was always there but it doesn't open the source module. It only opens up the model for you.

Misbah

@JaredDolich No, I didn't like it that's why I gave only 5 kudos 😛

Misbah

@akshaysawant Hijacking Mr. Dolich's thread:) Let's say: If your source module has 3 dimensions: Products, Customers and Countries and your target module has 2 dimensions only : Products , Customers If you try to refer the data from source module to target module then there are two possibilities 1. Anaplan automatically takes the data from the top level of Countries dimension and bring it to Target module provided you have the "Top Level" Set for Countries dimension 2. Anaplan will throw you an error saying that Formula is invalid as Countries doesn't have an Inbuilt Top Level. In your case you must have already Top Level Set for the dimension which was not matching between the source and target modules Hope that helps Misbah

Misbah

@lcapon Two things - If you are copy pasting make sure you have the following artifacts in the model (spelling mistakes or spacing also counts) Just check if the name of the module is REV04 Price Growth Rates Just check if the name of the line item in REV04 Price Growth Rates is Unit Price%. Check out the space between Price and % sign. Hope that helps Misbah

Misbah

@aneeta1 Your formula looks to me. Can you please check the spelling of Country in Country Made In Line item. Your formula shows county made in- missing "r" Hope that helps Misbah

Misbah

@g.mahesh I thought you were looking for earliest date. Anyway glad that MAX worked By the way the name is Misbah.

Misbah

@g.mahesh Try using MIN function like MIN(A,B,C,D,E) Hope that helps Misbah

Misbah

@edeblacam This Article was written way back in mid 2020. Here is the video that you should watch as ALM in NUX is available right now. https://community.anaplan.com/t5/Best-Practices/Application-Lifecycle-Management-for-the-User-Experience/ta-p/65921 Hope that helps Misbah

Misbah

@Ajinkya Please do not wait on. Log a ticket with Anaplan Support and they should be able to fix it. I was in the same situation a year back and I got it fixed. Misbah

Misbah

@RalfdeGier Name your export action exactly what you want the file name to be. For example if you want your file name to be "Extract Data.txt", your export action should be named as "Extract Data" and you can wrap this export action into a process and you can name process whatever you wish to. Hope that helps Misbah

Misbah

@ShivankurSharma As other champs have mentioned this usually is achieved with the help of LOOKUP but if you are running it in a loop you will get circular references. Hope you are not referring the same line item (Line item B) where you are writing the formula. Formula should be like : Line item B = Line item A[LOOKUP: SYS Mapping Module. Mapping Line item] - this should give you the previous year's value if the mapping is done accordingly. If all this doesn't work then I would say convert the module into Native Timescale dimensioned module and use Time based Functions & then reconvert the module back into Custom Time dimensioned module - Not an ideal solution but indeed the last resort for you, Hope that helps Misbah

Misbah

@ChrisHeathcote Are you saying both the SUM's don't work?. I see this as a typical use case of SUM & SELECT - reason being In Source Module you have 5 dimensions L4 Archive Period Future Year Archive LISS OUT01 In Target Module you have 4 dimensions L4 Archive Period Future Year LISS ARC Between these two modules 3 dimensions are common whereas 1 differ and another one is missing in the target module. The one which differs is LISS. In order to tackle this you already have a mapping module dimensioned by LISS OUT01 which has an attribute of LISS ARC and you are using SUM on that line item to pull the values- perfect On the other hand the missing dimension in the target module (Archive list) can't be summed upon. However Anaplan will bring the totals automatically if it has top level set. Alternatively it can also be tackled with SELECT if you wish to pull the value of any specific list item. This is what I believe is happening. Please tell me that I am right in assuming everything here:) Misbah

Misbah

@Shailendr See if this helps. Full Article https://help.anaplan.com/7b025de8-75ba-4bb2-9109-867edb26ec4b-Procure-CA-Certificates

Misbah

@swapnil_J Even I don't recommend using subsidiary views but would you care to share what exactly are you trying to achieve by doing so. That probably may lead us towards the right approach

Misbah

Thanks @anand.shekhawat and Welcome to the group. Points taken, we will surely try to incorporate those when we start our meet ups. Stay tuned!

Misbah

@swapnil_J Well you will have to dimensionalize your second line item with List X. See if this helps

Misbah

@AlejandroGomez Well my hypothesis says that we can't use aggregation functions (SUM, MovingSUM, TIMESUM etc) on Time Period Formatted Line items if that particular line item has Time dimension in its module.

Misbah · Re: 3.2.11.3 Create Saved View for Combination Cha...

@Cynthia1 Glad that it fixed the issue

Misbah

Welcome @abhinav_tripathi So we have music composer in the house. Great. Well, we all learn from each other and it gives me an immense pleasure to say that we will try to help as much as we can to get you there where you want to be.

Misbah

Welcome @Arnab_116 Getting to know more use cases outside our domain is something that I always liked and it seems that you too like it. You are at the right place Sir.

Misbah

Welcome @Suneela Amazing, great to see Chartered Professional Accountants in here. We will surely take that into consideration when we do our first event. Stay Tuned

Misbah

Welcome @JaredDolich Honoured to have you onboard. This group will benefit a lot from the the experience that you bring along. Let's learn & grow together.