Hi X,

I think that link is failing as it looks to be pre-signed with a 1 hour validity. Can you share it another way?

I have tried a different method, it should be fixed now.  Thanks for letting me know. 

I am still getting an error message when I click the link How-To: PAfE-PASS Centrally Managed Options.  

Fixed! Thank You. 

Hi Xavier,
thanks for the interesting videos.
The link to How-To: PAfE-PASS Centrally Managed Options returns an error.
Can you check ?
Jean-Michel

Video: PAfE-PASS Centrally Managed Options

Duration: 2:01 minutes

What You Will Learn:

- How to access the Spreadsheet Configuration interface

- Understanding the configuration menu structure

- How to configure websheet parameters for Planning Analytics Workspace

- How to disable/enable Custom, Dynamic, Quick reports and Explorations convert functionality

- The relationship between PAfELocale settings and display language

Video:
How-To: PAfE-PASS Centrally Managed Options

Key Takeaways:

1. Centralized Control

   - Learn to manage PAfE and PASS settings from a single location

2. Improved Governance

   - Understand how to enforce organizational standards

   - Control which features are available to users

   - Manage resource limits to prevent system overload

4. Time Savings

   - Eliminate the need to configure settings on each user's machine

5. Standardization

   - Ensure all users work with the same configuration

Planning Analytics for Excel Certificate Update - Quick Summary
What Changed: PAfE version 3.1.7 & 2.1.20 introduced a new IBM digital signature for the Excel add-in.
Why It Matters: Excel will show a security warning when it detects the new signature, even though it's from IBM (a trusted publisher). This is standard Microsoft security behavior.

What to do:
For Individual Users (Personal PC)
One-Time Action Required:
1. When Prompted: Click "Trust this add-in" when the security warning appears
OR
2. Manual Setup:
File → Options → Trust Center → Trust Center Settings → Trusted Publishers
Add the IBM signature

For IT Administrators (Global/Enterprise Deployment)
Centralized Options:

1. Group Policy Deployment:
• Deploy trusted publisher certificate via GPO
• Push to all domain computers automatically
• Users won't see any warnings
2. SCCM/Intune Deployment:
• Package the certificate with the PAfE installation
• Deploy through enterprise management tools
3. Registry-Based Deployment:
• Export trusted publisher registry keys
• Deploy via login scripts or configuration management
4. Pre-Installation Communication:
• Email users about the expected warning
• Provide click-through instructions
• Set up help desk support for questions

Impact: One-time action per machine, no functionality changes, enhanced security maintained. As part of our ongoing commitment to security, we are implementing more frequent certificate rotations. Please note that while digital signing keys will be updated more regularly, the publisher fingerprint will remain consistent across multiple key rotations, ensuring continuity and trust verification.

Video – UR with TM1VAL in rows and column Header

Duration: 5:24 minutes

What You Will Learn:
·     Use the formula wizard for column data content
·     Use the formula wizard for dynamic row header content
·     Syncing TM1Val formulas with Universal Report slicers
·     Reason to modify the Row header named range

UR with TM1VAL in rows and column Header

Key Takeaways:
·     Multi Cube integration is made easy with TM1Val and the wizard.
·     Maintain synchronization with Universal Report selections
·     Learn how to modify named ranges in Universal Reports to add flexibility.

Video : Toggle Range, Hide /show Rows and Columns Action Buttons

Duration: 2:11 minutes

What You Will Learn:

·      How to use the Toggle Range action button in PAfE and Websheets

·      When and why to use this feature in your reports

·      Step-by-step demonstration of activating the Toggle Range button

·      How the feature dynamically switches between data views

·      Real-world scenarios where Toggle Range improves report usability

Show / Hide Sections Action Button update

Key Takeaways:

·      Efficient navigation between different data ranges

·      Improved report interactivity and user experience

·      Time-saving techniques for working with multiple data perspectives

What's Coming Next

This is just the beginning! We have an exciting roadmap of features and enhancements planned for Planning Analytics for Excel. Stay tuned to this blog for:

·      More feature videos and tutorials

·      Tips and tricks from our development team

·      User success stories and case studies

·      Answers to your questions and challenges

We Want to Hear From You

Your feedback drives our development priorities. We encourage you to:

·      Comment Below - Share your thoughts on these new features

·      Ask Questions - If something is not clear, let us know

·      Request Topics - Tell us what you would like to see in future videos

·      Share Your Success - Let us know how these features are helping your organization

____________________________________________________________

Thank you for being part of the Planning Analytics for Excel community. We are committed to continuously improving your planning experience, and we look forward to sharing more innovations with you in the coming months.

Happy Planning!

The Planning Analytics for Excel Team

Xavier Osorio | Jamie Currie | Ted Phillips

____________________________________________________________

Video: Formula Wizard with TM1Val

Duration: 4:22 minutes

What You Will Learn:

·      How to quickly generate a TM1Val formula using the Formula Wizard

·      Step-by-step demonstration

·      Practical application examples

·      Tips for optimal use

PAfE formula Wizard - TM1VAL

Key Takeaways:

·      Easier to create a TM1Val formula

·      Faster to create a TM1Val formula

·      Decreased errors when creating a TM1Val Formula

·      Flexibility when connecting to existing reports.

____________________________________________________________

Video : Universal Report Properties Panel

Duration: 1:59 minutes

What You Will Learn:

·      What is the Properties Window of a Universal Report

·      How to access it

·      Practical application examples

·      Tips for optimal use

Universal Reports - Properties Panel video

Key Takeaways:

·      Keep your Universal Reports up to date

·      Easier access to report parameters

____________________________________________________________

Welcome to our first feature spotlight! We are excited to share some of the powerful new capabilities we have recently delivered to Planning Analytics for Excel. These enhancements are designed to streamline your report generation, improve productivity, and unlock new possibilities for analysis and collaboration.

What's New: Video Highlights

To help you quickly understand and start using these new features, we have created a series of short video demonstrations. Each video highlights key functionality and provides practical examples of how to apply these capabilities in your day-to-day planning activities.

Featured Videos

Below you will find our latest video tutorials showcasing recent deliveries. Each video focuses on a specific feature or capability, demonstrating both the functionality and practical use cases.

PAfE Formula Wizard - TM1SET

Duration: 2:19 minutes

What You Will Learn:

·      What is the Formula Wizard

·      Where can I find it

·      Step-by-step demonstration

·      Practical application examples

·      Tips for optimal use

PAfE formula wizard - TM1SET

Key Takeaways:

·      Ease of use to create a TM1set Formula

·      Save Time

·      Increase Accuracy

___________________________________________________________