Best Of
Re: Time Settings
@ClarenceAndre Yes!
Well, sorry it took me so long to get to what you were after. Thanks for being so patient.
On to the next one!
Re: How I Built It: Dynamic month, quarter, and year filter
@JonFerneau Thank you! Also glad to hear that you are able to implement and use this at a client!
Agandhi
Re: Integrating Securely: Using the Anaplan REST API with Certificate-Based Authentication
@kpasko You will take the certificate files that you receive from the vendor of your choice and need to convert them to PEM format. You can follow steps on converting to PEM format through the Interactive CA Certificate Guide pasted below. This will allow you to "choose your adventure" based on the certificate format that you are starting with. Feel free to reach out if you have any troubles!
https://anaplanenablement.s3.amazonaws.com/Community/Interactive+CA+Cert+Guide/story.html
Re: How to deal with 3 dimensions having many to many relationship?
Why don't you just create a list with the Code (Store) and Code(School) combination from your first module with the Store as the parent
Then create a subset for the School and Store that will be TRUE, if the combination is legal.
Then create a third module with the dimensions Store_School subset, Subject and Type.
Create a line item (list format) from the Code to get the School
Create a line item for Subject (if sys module is not available)
Create a line item for Type (if sys module is not available)
Create a line item in this third module as SKU, and the lookup using School, Subject and Type.
To filter, create a line item to check the first occurence of the SKU per Store.
Please tell me if this seems fine :)
ramonito
Re: How I Built It: Dynamic month, quarter, and year filter
Brilliant work here! It definitely simplifies time filtering for UX dashboards where I have seen other solutions involve quite a few complex steps. I am implementing this on some of our work already! Thank you for your contribution!
Re: Have total in summaries to only include sums of only the items users have access to
Miran
Re: The Anaplan Way ¦ My Presentation
Thank You very much @JosephPhilp634 . I really appreciate your kind gesture.
~Anand
How I Built It: Dynamic month, quarter, and year filter
Hello Anaplanner Community! I’m excited to participate in the ‘How I Built It’ video series with a dynamic month, quarter, and year filter tutorial.
This video will walk you through how a dashboard can dynamically update time on all tables and charts. This enables multiple users to have different filters enabled on the same dashboard.
Key features:
- Users can choose if they would like to see months, quarters, years, or a combination of them.
- Allows multiple users to have different filters enabled using the same dashboard.
- The grid and chart updates in real time without requiring the use of the refresh button.
Check it out:
Questions about the video? Leave a comment!
Check out additional 'How I Built It' tutorials here.
…….
About the Author:
Arjun Gandhi has been in the Anaplan ecosystem for 8+ years and 5+ years as a Certified Master Anaplanner. He is the co-founder at Tekplanit, an Anaplan Partner and has worked in dozens of industries and implementations across finance, supply chain, and sales.
Agandhi
Re: Convert a number to Date
Hi @melliott ,
First you need convert number to text
second you need to break data to day, month, and year
third you need to convert data (day, month, year) to DATE
Here the Blueprint
Regards,
Panji
Panji
Re: Level 2 Sprint 2/3 SYS08 issues with Parent Family
I think you have not mapped product list to product family , please reimport product list to map to prod family hierarchy , then SKU P1 parent will be identified
