Community
Search Options
Search Options
Log in
Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Business Analytics
Topic areas
Cognos Analytics
Cognos Controller
Global Business Analytics
Planning Analytics
User groups
Events
TechXchange Day
IBM TechXchange Conference
Upcoming Business Analytics Events
IBM TechXchange Webinars
All IBM TechXchange Community Events
Participate
Community Manager's Welcome
Gamification Program
Post to Forum
Share a Resource
Share Your Expertise
Blogging on the Community
Connect with Business Analytics Users
All IBM TechXchange Community Users
Resources
IBM TechXchange Group
Data and AI Learning
IBM Champions
IBM Cloud Support
IBM Documentation
IBM Support
IBM Support 101
IBM Technology Zone
IBM Training
TechXchange Day
Marketplace
Marketplace
Business Analytics
Connect, learn and share with over 10000 users across the IBM Business Analytics.
Ask a question
Join us for IBM TechXchange Day: AI and Automation
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Planning Analytics
View Only
Group Home
Discussion
6K
Library
210
Blogs
344
Events
0
Members
2.6K
Share
Enabling TM1 worksheet functions in #Planning Analytics for Microsoft Excel
By
CHARLIE LE
posted
Tue June 20, 2017 02:23 PM
0
Like
TM1 worksheet functions are an excellent way to enhance your analysis in IBM® Planning Analytics for Microsoft Excel. TM1 worksheet functions can be used to send and retrieve a numeric or string value to and from a TM1 cube. For example, you can use worksheet functions to retrieve a value, the level of an element within a dimension, and the number of hierarchy levels in a dimension. You can also send values to a TM1 cube or to a specific element attribute. See
Worksheet functions overview
for a list of TM1 worksheet functions.
To use worksheet functions, you need to enable worksheet functions in Planning Analytics for Microsoft Excel.
This video shows you how to enable TM1 worksheet functions in Planning Analytics for Microsoft Excel.
Open the full tutorial in YouTube
and follow along in the
documentation
.
Watch the video
#Planning Analytics for Microsoft Excel
#GettingStarted
#PlanningAnalyticswithWatson
#PlanningAnalyticsForMicrosoftExcel
#Tips
#tm1
#Video
1 comment
13 views
Permalink
Comments
Nilfa Haszna
Sat March 12, 2022 02:09 AM
New capability are the workbooks to manual extraordinary styles of customers thru their unique evaluation with the opportunity to create a story and craft memories with the facts. and without difficulty create evaluation in some metrics which will be interpreted as dashboard or information graphics.
takbiran
IBM Community Home
Browse
Discussions
Resources
Groups
Events
IBM TechXchange Conference 2023
IBM Community Webinars
All IBM Community Events
Participate
Gamification Program
Community Manager's Welcome
Post to Forum
Share a Resource
Blogging on the Community
All IBM Community Users
Resources
Community Front Porch
IBM Champions
IBM Cloud Support
IBM Documentation
IBM Support
IBM Technology Zone
IBM Training
Marketplace
Marketplace
Business Analytics
Topic areas
Cognos Analytics
Cognos Controller
Global Business Analytics
Planning Analytics
User groups
Events
TechXchange Day
IBM TechXchange Conference
Upcoming Business Analytics Events
IBM TechXchange Webinars
All IBM TechXchange Community Events
Participate
Community Manager's Welcome
Gamification Program
Post to Forum
Share a Resource
Share Your Expertise
Blogging on the Community
Connect with Business Analytics Users
All IBM TechXchange Community Users
Resources
IBM TechXchange Group
Data and AI Learning
IBM Champions
IBM Cloud Support
IBM Documentation
IBM Support
IBM Support 101
IBM Technology Zone
IBM Training
TechXchange Day
Marketplace
Marketplace
Powered by Higher Logic