About Sai_Bharadwaj_Venati

tompatrick.ting · ‎06-30-2022

Hi @anand.shekhawat and @ChrisAHeathcote Yes, I enabled the Selective access in the list and enabled the line item Filter for Selective access. My problem is once i provide the user Read Access to certain list member, that Read access will also be available in the user dropdown list. I only want to allow the user to only select those list member that they will have Write access. Regards, Tom

Sai_Bharadwaj_Venati · ‎06-16-2022

Hi, I'm facing similar issue but at monthly level. I want to sparkline for only my actual months in planning fiscal year. In my case Jan 22 to May 22 data I've applied filter on time period and context selector is showing only those 5 months but sparkline is still showing entire 12 Months. Jan 22 to Dec 22

ryan_kohn · ‎06-16-2022

There is already some great advice in this thread from @Sai_Bharadwaj_Venati and @rob_marshall. For the final step of importing the new code back into the list, make sure you specificy in the import that items are uniquely identified by the Name (#ID for a numbered list), and map both the #ID and the Code. Normally you would map imports into a list based on a unique code, but by mapping based on unique Name and providing a code, you are telling Anaplan to update the Code. See below for mapping example and you can also read more about import options into Numbered Lists.

Sai_Bharadwaj_Venati · ‎06-16-2022

Hi, If Display name is present and it's list formatted then u can directly apply name anaplan formula on that property. If it's a text field, u can directly reference it Thanks & Regards, Sai Bharadwaj https://www.linkedin.com/in/sai-bharadwaj-venati/

KubotaNatsuki · ‎06-14-2022

Thanks for your reply! I did it. Thank you！

alexpavel · ‎06-09-2022

@JEEVAK if you can associate to the "List 1" an element from List2 using a system module, then you can pull data from "module 1" using the SUM. It's exactly the same situation as in module REP02 from Anaplan Level 1: List 1: P2 Products List 2: Size The connection between List 1 and List 2 is made in system module SYS06 ( to a Product is associated a Size). Module 1: REV03 Margin Calculation Module 2: REP02 Size Margin Report Hope it helps Alex

Sai_Bharadwaj_Venati · ‎06-09-2022

Hi, This Article should help you https://community.anaplan.com/t5/Anaplan-Platform/Creating-QUARTILE-function-within-Anaplan/td-p/89381 Thanks & Regards, Sai Bharadwaj

rohan.suratwale · ‎05-26-2022

Hi @selvaam12 , You can refer to the below page link for Anaplan Snap Logic Integration. https://help.anaplan.com/24795b0e-12b0-4639-9144-d194d1212b85-Anaplan-SnapLogic-Integration https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438695/Anaplan+Snap+Pack . Hope this helps , Feel free to reach out if you need further assistance, --ROHAN

Abhishek90 · ‎05-06-2022

Thank you so much Ankit for your guidance It works perfectly fine for me. Regards Abhishek

Dovranbek · ‎05-04-2022

thank you

Sai_Bharadwaj_Venati · ‎05-03-2022

Great to hear that!!!

kerrydionbrown · ‎05-02-2022

How do I update both of those lists?

Sai_Bharadwaj_Venati · ‎05-02-2022

Yes, Change the dimension. It should work and even your import will also work now

Sai_Bharadwaj_Venati · ‎05-02-2022

Hey, Module should be dimensioned by Half year Thanks & Regards, Sai Bharadwaj https://www.linkedin.com/in/sai-bharadwaj-venati/

Sai_Bharadwaj_Venati · ‎05-02-2022

Hey Madhu, Can u please look into this thread: - https://community.anaplan.com/t5/Anaplan-Platform/Selective-access-Sum-Total-does-not-work/td-p/65581. Detailed walkthrough has been done Thanks & Regards, Sai Bharadwaj https://www.linkedin.com/in/sai-bharadwaj-venati/

Nithyashree · ‎04-28-2022

Hi, You have to assign that other actions in your process action. You can enable this process action in your Nux. Thankyou.

Aswinraj · ‎04-28-2022

Hi Venkat, It worked. Adding to your point, the dimensions should also be considered to get the values. Thanks for the contribution. Regards Aswinraj Ramesh

Kanishq17 · ‎04-22-2022

@rohithnarayan Maybe you can use alternative like TY(This year) , LY(Last Year), LLY(Last Last Year ) etc. and in a landing page mention in a text like eg when switchover is done so F22 - TY , F21 - LY and so on.

Sandeep28 · ‎04-19-2022

thanks a lot 😊

ryan_kohn · ‎04-18-2022

There may be some unicode or emoji text options that will satisfy the requirement. For example, you can have a list item with the following display text: "⚠ Must increase headcount or productivity" or " ⚠️ Must increase utilization or price to meet target." I would caution against using these if any integrations including this text are required, per the Planual best practice on emojis. Note also that emojis may render differently on different screens and browsers, or may not render at all for some people.

KirillKuznetsov · ‎04-18-2022

@telmanaga Write to academy@anaplan.com for the 90-day WS.

Baek · ‎04-18-2022

Hi, Thank you for answer! you are a genius. Thanks for your help in solving this problem. I will never forget what I learned. Have a nice day!!!

einas.ibrahim · ‎04-17-2022

Hello @Avinash90 As @Sai_Bharadwaj_Venati you can’t download a model into some sort of a file into your computer. Models have to live in a workspace. However, there are a few ways you could use to store elements of a model locally perhaps for future reference. You can export a list of certain artifacts such as the modules, general lists, actions, data sources, …etc Export a list of all the line items along with their formulas. I find this extremely helpful when auditing a model for deviations from best practices. Export data in lists. This helps if you want to preserve the model hierarchies and structures.

Sai_Bharadwaj_Venati · ‎04-15-2022

Can you provide little bit more context to the question? If it's a general question -> Anaplan model builders build models to Business as per use cases. These use cases can range from FP&A, S&OP, Incentive compensations etc. Now each use case will solve problems to business, for example a S&OP solution might help companies plan for right products at right time at right place. Similarly an FP&A use case can help companies plan for Budgeting and do various scenario analysis on top of base version which is not possible in traditional legacy systems. Thanks & Regards, Sai Bharadwaj linkedin.com/in/sai-bharadwaj-venati

neg177 · ‎04-13-2022

So I would make each one of my identifier columns numbered list and then create a flat list that concatenates them all?

ChrisAHeathcote · ‎11-09-2021

@CHSJ Create three line item subsets (LISS) for each of the three modules; LISS_A, LISS_B and LISS_C. If module A and B contain the same dimensions it may be possible to create one LISS and assign the line items from both modules; this LISS could be called LISS_AB. Create a mapping module for each LISS, LISS_A and LISS_B. Create two modules if these can not be combined or one if they can. If they can be combined then a single mapping module for LISS_AB. Add a line item to these module and format it as a list assigning the LISS_C from module C. Now select from the pick list a line item from module C to each item in the LISS_A and LISS_B or the combined LISS_AB. In modules A and B add a new line item, adding the corresponding LISS for that module. Add the formula; COLLECT() In module C reference these line items in modules A and B and use SUM function, using the line items in the mapping modules to sum the data in each source module into the target line item in module C. The formula will look something like this;Module A.NewLineItem[SUM:LISS_AMapping.LISS_C] + Module B.NewLineItem[SUM:LISS_AMapping.LISS_C] If modules A and B have different dimensions to the target module C then you will need to build in additional mappings. However, this is not stated so please elaborate if this is the case.

Sai_Bharadwaj_Venati · ‎10-19-2021

Hi, I'm unable to attend that session. If possible, can anyone share meeting recording?

Raul2104 · ‎09-23-2021

Simple and useful. thanks Sai Regards Rahul

Sai_Bharadwaj_Venati · ‎08-08-2021

They are same only difference i see is adding a filter for two years. Other than that nothing Infact, i think after creating Grid view, u need to save Grid View as Line Chart View and add filter (Use Save as feature and rename to copy paste any saved view)

Sai_Bharadwaj_Venati · ‎08-08-2021

After changing it summary method to formula, the numbers go back to normal. My question is is it by changing the summary method, it should only be applied to the summary column, not to the individual month's column? -> Summary applies to all dimensions (Time, Country, Size) -> On Screenshot you're showing Americas which is Countries L1 (Parent of Countries L2, that's why it's aggregating). Ideally whenever u calculate % it's better to use formula as summary