Join us for a live webinar to understand the reporting options available in IBM Planning Analytics for Microsoft Excel, IBM Planning Analytics Workspace and web sheets. We'll explain when to use each client, and provide tips and tricks on how to create professional looking reports that meet your business needs quickly and easily.

Building your Planning and Analytics Reports

Watch the On Demand Recording here 

Please share any of your questions below! 
Thanks, 

------------------------------
NICKOLUS PLOWDEN
Check out the Cognos Analytics Webinar Series: https://bit.ly/2M7sciX
------------------------------
#PlanningAnalyticswithWatson

Hello everyone, 

You can watch the full recording and demo here. Please share your questions below and the slides are available here. 


Thanks, 


------------------------------
PAUL GLENNON
------------------------------

Original Message:
Sent: Mon August 10, 2020 01:54 PM
From: NICKOLUS PLOWDEN
Subject: Building your Planning and Analytics Reports

Join us for a live webinar to understand the reporting options available in IBM Planning Analytics for Microsoft Excel, IBM Planning Analytics Workspace and web sheets. We'll explain when to use each client, and provide tips and tricks on how to create professional looking reports that meet your business needs quickly and easily.

Building your Planning and Analytics Reports

Watch the On Demand Recording here 

Please share any of your questions below! 
Thanks, 

------------------------------
NICKOLUS PLOWDEN
Check out the Cognos Analytics Webinar Series: https://bit.ly/2M7sciX
------------------------------
#PlanningAnalyticswithWatson

Hi Paul,

Thank you for the presentation. It clarified a couple of items for me. How did you remove the second quick report (around 22 minutes into the presentation)?

The IBM documentation indicates you need to:

1. In the Task Pane, Workbook tab, expand Quick Reports.
2. Locate the Quick Report you want to delete.
3. Right-click the Quick Report you want to delete and select Convert to snapshot.
4. Click Yes.
5. Delete the rows and columns.

I do not see you right-clicking the quick report and following the steps above.

If I follow the steps above, it does not delete the server formatting in the report. But in the recording, it does not look like you followed these steps and the formatting is removed.

Regards, Jackie

------------------------------
Jackie Twigge
------------------------------

Original Message:
Sent: Wed August 12, 2020 08:07 PM
From: PAUL GLENNON
Subject: Building your Planning and Analytics Reports

Hello everyone, 

You can watch the full recording and demo here. Please share your questions below and the slides are available here. 

Thanks, 


------------------------------
PAUL GLENNON

Original Message:
Sent: Mon August 10, 2020 01:54 PM
From: NICKOLUS PLOWDEN
Subject: Building your Planning and Analytics Reports

Join us for a live webinar to understand the reporting options available in IBM Planning Analytics for Microsoft Excel, IBM Planning Analytics Workspace and web sheets. We'll explain when to use each client, and provide tips and tricks on how to create professional looking reports that meet your business needs quickly and easily.

Building your Planning and Analytics Reports

Watch the On Demand Recording here 

Please share any of your questions below! 
Thanks, 

------------------------------
NICKOLUS PLOWDEN
Check out the Cognos Analytics Webinar Series: https://bit.ly/2M7sciX
------------------------------
#PlanningAnalyticswithWatson

Hi Jackie,

Those instructions are correct. It might have not been obvious in the recording. Converting to snapshot and deleting the columns will get rid of any trace of the Quick Report. It's possible those steps were edited out for time, but that's indeed how it's done.

Paul

------------------------------
PAUL GLENNON
------------------------------

Original Message:
Sent: Thu August 13, 2020 10:52 AM
From: Jackie Twigge
Subject: Building your Planning and Analytics Reports

Hi Paul,

Thank you for the presentation. It clarified a couple of items for me. How did you remove the second quick report (around 22 minutes into the presentation)?

The IBM documentation indicates you need to:

1. In the Task Pane, Workbook tab, expand Quick Reports.
2. Locate the Quick Report you want to delete.
3. Right-click the Quick Report you want to delete and select Convert to snapshot.
4. Click Yes.
5. Delete the rows and columns.

I do not see you right-clicking the quick report and following the steps above.

If I follow the steps above, it does not delete the server formatting in the report. But in the recording, it does not look like you followed these steps and the formatting is removed.

Regards, Jackie

------------------------------
Jackie Twigge

Original Message:
Sent: Wed August 12, 2020 08:07 PM
From: PAUL GLENNON
Subject: Building your Planning and Analytics Reports

Hello everyone, 

You can watch the full recording and demo here. Please share your questions below and the slides are available here. 

Thanks, 


------------------------------
PAUL GLENNON

Original Message:
Sent: Mon August 10, 2020 01:54 PM
From: NICKOLUS PLOWDEN
Subject: Building your Planning and Analytics Reports

Join us for a live webinar to understand the reporting options available in IBM Planning Analytics for Microsoft Excel, IBM Planning Analytics Workspace and web sheets. We'll explain when to use each client, and provide tips and tricks on how to create professional looking reports that meet your business needs quickly and easily.

Building your Planning and Analytics Reports

Watch the On Demand Recording here 

Please share any of your questions below! 
Thanks, 

------------------------------
NICKOLUS PLOWDEN
Check out the Cognos Analytics Webinar Series: https://bit.ly/2M7sciX
------------------------------
#PlanningAnalyticswithWatson

Hi Paul,

Perfect, thank you for the confirmation Paul.

Regards, Jackie

------------------------------
Jackie Twigge
------------------------------

Original Message:
Sent: Thu August 13, 2020 12:44 PM
From: PAUL GLENNON
Subject: Building your Planning and Analytics Reports

Hi Jackie,

Those instructions are correct. It might have not been obvious in the recording. Converting to snapshot and deleting the columns will get rid of any trace of the Quick Report. It's possible those steps were edited out for time, but that's indeed how it's done.

Paul

------------------------------
PAUL GLENNON

Original Message:
Sent: Thu August 13, 2020 10:52 AM
From: Jackie Twigge
Subject: Building your Planning and Analytics Reports

Hi Paul,

Thank you for the presentation. It clarified a couple of items for me. How did you remove the second quick report (around 22 minutes into the presentation)?

The IBM documentation indicates you need to:

1. In the Task Pane, Workbook tab, expand Quick Reports.
2. Locate the Quick Report you want to delete.
3. Right-click the Quick Report you want to delete and select Convert to snapshot.
4. Click Yes.
5. Delete the rows and columns.

I do not see you right-clicking the quick report and following the steps above.

If I follow the steps above, it does not delete the server formatting in the report. But in the recording, it does not look like you followed these steps and the formatting is removed.

Regards, Jackie

------------------------------
Jackie Twigge

Original Message:
Sent: Wed August 12, 2020 08:07 PM
From: PAUL GLENNON
Subject: Building your Planning and Analytics Reports

Hello everyone, 

You can watch the full recording and demo here. Please share your questions below and the slides are available here. 

Thanks, 


------------------------------
PAUL GLENNON

Original Message:
Sent: Mon August 10, 2020 01:54 PM
From: NICKOLUS PLOWDEN
Subject: Building your Planning and Analytics Reports

Join us for a live webinar to understand the reporting options available in IBM Planning Analytics for Microsoft Excel, IBM Planning Analytics Workspace and web sheets. We'll explain when to use each client, and provide tips and tricks on how to create professional looking reports that meet your business needs quickly and easily.

Building your Planning and Analytics Reports

Watch the On Demand Recording here 

Please share any of your questions below! 
Thanks, 

------------------------------
NICKOLUS PLOWDEN
Check out the Cognos Analytics Webinar Series: https://bit.ly/2M7sciX
------------------------------
#PlanningAnalyticswithWatson

Hi, Paul
Thanks for the presentation. It is helpful but I have a quick question.
In your demos, I noticed that almost every TM1 formula has an "@" sign in the front. But I can't show it in my PAfE. How did you do that? And what is the difference of whether or not showing this "@" sign in the reports?

------------------------------
mvp morgan
------------------------------

Original Message:
Sent: Wed August 12, 2020 08:07 PM
From: PAUL GLENNON
Subject: Building your Planning and Analytics Reports

Hello everyone, 

You can watch the full recording and demo here. Please share your questions below and the slides are available here. 

Thanks, 


------------------------------
PAUL GLENNON

Original Message:
Sent: Mon August 10, 2020 01:54 PM
From: NICKOLUS PLOWDEN
Subject: Building your Planning and Analytics Reports

Join us for a live webinar to understand the reporting options available in IBM Planning Analytics for Microsoft Excel, IBM Planning Analytics Workspace and web sheets. We'll explain when to use each client, and provide tips and tricks on how to create professional looking reports that meet your business needs quickly and easily.

Building your Planning and Analytics Reports

Watch the On Demand Recording here 

Please share any of your questions below! 
Thanks, 

------------------------------
NICKOLUS PLOWDEN
Check out the Cognos Analytics Webinar Series: https://bit.ly/2M7sciX
------------------------------
#PlanningAnalyticswithWatson

Hi Morgan,

That's an implicit intersection operator introduced to support dynamic arrays in Excel for Microsoft 365 which is an indicator where a dynamic array may occur.

In simple terms, this operator restricts the automatic spilling of the formula to a range, returning only one item where you're applying the formula or even a named range returning an array of values, thus giving more power to the user to control the default behaviour of excel formulas. You may read more on that in the below link:

https://support.microsoft.com/en-us/office/implicit-intersection-operator-ce3be07b-0101-4450-a24e-c1c999be2b34

I really like the new functionality of dynamic arrays and really hope it also gets supported in TM1 Web sooner than later.

------------------------------
Amin Mohammed
------------------------------

Original Message:
Sent: Mon August 17, 2020 06:04 PM
From: mvp morgan
Subject: Building your Planning and Analytics Reports

Hi, Paul
Thanks for the presentation. It is helpful but I have a quick question.
In your demos, I noticed that almost every TM1 formula has an "@" sign in the front. But I can't show it in my PAfE. How did you do that? And what is the difference of whether or not showing this "@" sign in the reports?

------------------------------
mvp morgan

Original Message:
Sent: Wed August 12, 2020 08:07 PM
From: PAUL GLENNON
Subject: Building your Planning and Analytics Reports

Hello everyone, 

You can watch the full recording and demo here. Please share your questions below and the slides are available here. 

Thanks, 


------------------------------
PAUL GLENNON

Original Message:
Sent: Mon August 10, 2020 01:54 PM
From: NICKOLUS PLOWDEN
Subject: Building your Planning and Analytics Reports

Join us for a live webinar to understand the reporting options available in IBM Planning Analytics for Microsoft Excel, IBM Planning Analytics Workspace and web sheets. We'll explain when to use each client, and provide tips and tricks on how to create professional looking reports that meet your business needs quickly and easily.

Building your Planning and Analytics Reports

Watch the On Demand Recording here 

Please share any of your questions below! 
Thanks, 

------------------------------
NICKOLUS PLOWDEN
Check out the Cognos Analytics Webinar Series: https://bit.ly/2M7sciX
------------------------------
#PlanningAnalyticswithWatson

We have a client where an Office 365 based user is also getting @ signs in front of PAX based TM1 formulae. It appears that it's breaking the worksheets as well. ​

------------------------------
John Vaughan
------------------------------

Original Message:
Sent: Tue August 18, 2020 12:40 AM
From: Amin Mohammed
Subject: Building your Planning and Analytics Reports

Hi Morgan,

That's an implicit intersection operator introduced to support dynamic arrays in Excel for Microsoft 365 which is an indicator where a dynamic array may occur.

In simple terms, this operator restricts the automatic spilling of the formula to a range, returning only one item where you're applying the formula or even a named range returning an array of values, thus giving more power to the user to control the default behaviour of excel formulas. You may read more on that in the below link:

https://support.microsoft.com/en-us/office/implicit-intersection-operator-ce3be07b-0101-4450-a24e-c1c999be2b34

I really like the new functionality of dynamic arrays and really hope it also gets supported in TM1 Web sooner than later.

------------------------------
Amin Mohammed

Original Message:
Sent: Mon August 17, 2020 06:04 PM
From: mvp morgan
Subject: Building your Planning and Analytics Reports

Hi, Paul
Thanks for the presentation. It is helpful but I have a quick question.
In your demos, I noticed that almost every TM1 formula has an "@" sign in the front. But I can't show it in my PAfE. How did you do that? And what is the difference of whether or not showing this "@" sign in the reports?

------------------------------
mvp morgan

Original Message:
Sent: Wed August 12, 2020 08:07 PM
From: PAUL GLENNON
Subject: Building your Planning and Analytics Reports

Hello everyone, 

You can watch the full recording and demo here. Please share your questions below and the slides are available here. 

Thanks, 


------------------------------
PAUL GLENNON

Original Message:
Sent: Mon August 10, 2020 01:54 PM
From: NICKOLUS PLOWDEN
Subject: Building your Planning and Analytics Reports

Join us for a live webinar to understand the reporting options available in IBM Planning Analytics for Microsoft Excel, IBM Planning Analytics Workspace and web sheets. We'll explain when to use each client, and provide tips and tricks on how to create professional looking reports that meet your business needs quickly and easily.

Building your Planning and Analytics Reports

Watch the On Demand Recording here 

Please share any of your questions below! 
Thanks, 

------------------------------
NICKOLUS PLOWDEN
Check out the Cognos Analytics Webinar Series: https://bit.ly/2M7sciX
------------------------------
#PlanningAnalyticswithWatson

Thanks, guys. Now I am clear.

------------------------------
mvp morgan
------------------------------

Original Message:
Sent: Tue August 18, 2020 12:40 AM
From: Amin Mohammed
Subject: Building your Planning and Analytics Reports

Hi Morgan,

That's an implicit intersection operator introduced to support dynamic arrays in Excel for Microsoft 365 which is an indicator where a dynamic array may occur.

In simple terms, this operator restricts the automatic spilling of the formula to a range, returning only one item where you're applying the formula or even a named range returning an array of values, thus giving more power to the user to control the default behaviour of excel formulas. You may read more on that in the below link:

https://support.microsoft.com/en-us/office/implicit-intersection-operator-ce3be07b-0101-4450-a24e-c1c999be2b34

I really like the new functionality of dynamic arrays and really hope it also gets supported in TM1 Web sooner than later.

------------------------------
Amin Mohammed

Original Message:
Sent: Mon August 17, 2020 06:04 PM
From: mvp morgan
Subject: Building your Planning and Analytics Reports

Hi, Paul
Thanks for the presentation. It is helpful but I have a quick question.
In your demos, I noticed that almost every TM1 formula has an "@" sign in the front. But I can't show it in my PAfE. How did you do that? And what is the difference of whether or not showing this "@" sign in the reports?

------------------------------
mvp morgan

Original Message:
Sent: Wed August 12, 2020 08:07 PM
From: PAUL GLENNON
Subject: Building your Planning and Analytics Reports

Hello everyone, 

You can watch the full recording and demo here. Please share your questions below and the slides are available here. 

Thanks, 


------------------------------
PAUL GLENNON

Original Message:
Sent: Mon August 10, 2020 01:54 PM
From: NICKOLUS PLOWDEN
Subject: Building your Planning and Analytics Reports

Join us for a live webinar to understand the reporting options available in IBM Planning Analytics for Microsoft Excel, IBM Planning Analytics Workspace and web sheets. We'll explain when to use each client, and provide tips and tricks on how to create professional looking reports that meet your business needs quickly and easily.

Building your Planning and Analytics Reports

Watch the On Demand Recording here 

Please share any of your questions below! 
Thanks, 

------------------------------
NICKOLUS PLOWDEN
Check out the Cognos Analytics Webinar Series: https://bit.ly/2M7sciX
------------------------------
#PlanningAnalyticswithWatson

Excel shouldn't have placed that operator in PAfE formulas to begin with as none of the these returns any ranges..

------------------------------
Amin Mohammed
------------------------------

Original Message:
Sent: Mon August 17, 2020 06:04 PM
From: mvp morgan
Subject: Building your Planning and Analytics Reports

Hi, Paul
Thanks for the presentation. It is helpful but I have a quick question.
In your demos, I noticed that almost every TM1 formula has an "@" sign in the front. But I can't show it in my PAfE. How did you do that? And what is the difference of whether or not showing this "@" sign in the reports?

------------------------------
mvp morgan

Original Message:
Sent: Wed August 12, 2020 08:07 PM
From: PAUL GLENNON
Subject: Building your Planning and Analytics Reports

Hello everyone, 

You can watch the full recording and demo here. Please share your questions below and the slides are available here. 

Thanks, 


------------------------------
PAUL GLENNON

Original Message:
Sent: Mon August 10, 2020 01:54 PM
From: NICKOLUS PLOWDEN
Subject: Building your Planning and Analytics Reports

Join us for a live webinar to understand the reporting options available in IBM Planning Analytics for Microsoft Excel, IBM Planning Analytics Workspace and web sheets. We'll explain when to use each client, and provide tips and tricks on how to create professional looking reports that meet your business needs quickly and easily.

Building your Planning and Analytics Reports

Watch the On Demand Recording here 

Please share any of your questions below! 
Thanks, 

------------------------------
NICKOLUS PLOWDEN
Check out the Cognos Analytics Webinar Series: https://bit.ly/2M7sciX
------------------------------
#PlanningAnalyticswithWatson

The "@" sign refer to Dynamic Arrays. You may not be seeing them based on the Office version.
There should be no impact on TM1 functions and do not think that the TM1 functions will use the "spill" capabilities either.

See dynamic arrays for more information.

------------------------------
George Tonkin
------------------------------

Original Message:
Sent: Mon August 17, 2020 06:04 PM
From: mvp morgan
Subject: Building your Planning and Analytics Reports

Hi, Paul
Thanks for the presentation. It is helpful but I have a quick question.
In your demos, I noticed that almost every TM1 formula has an "@" sign in the front. But I can't show it in my PAfE. How did you do that? And what is the difference of whether or not showing this "@" sign in the reports?

------------------------------
mvp morgan

Original Message:
Sent: Wed August 12, 2020 08:07 PM
From: PAUL GLENNON
Subject: Building your Planning and Analytics Reports

Hello everyone, 

You can watch the full recording and demo here. Please share your questions below and the slides are available here. 

Thanks, 


------------------------------
PAUL GLENNON

Original Message:
Sent: Mon August 10, 2020 01:54 PM
From: NICKOLUS PLOWDEN
Subject: Building your Planning and Analytics Reports

Join us for a live webinar to understand the reporting options available in IBM Planning Analytics for Microsoft Excel, IBM Planning Analytics Workspace and web sheets. We'll explain when to use each client, and provide tips and tricks on how to create professional looking reports that meet your business needs quickly and easily.

Building your Planning and Analytics Reports

Watch the On Demand Recording here 

Please share any of your questions below! 
Thanks, 

------------------------------
NICKOLUS PLOWDEN
Check out the Cognos Analytics Webinar Series: https://bit.ly/2M7sciX
------------------------------
#PlanningAnalyticswithWatson

Hey Morgan,
The "=@" sign is added automatically by Excel if you're using a newer version that supports dynamic formulas.

https://superuser.com/questions/1525270/why-have-at-symbols-suddenly-appeared-in-my-excel-formulae

Kirk

------------------------------
Kirk Stolworthy
------------------------------

Original Message:
Sent: Mon August 17, 2020 06:04 PM
From: mvp morgan
Subject: Building your Planning and Analytics Reports

Hi, Paul
Thanks for the presentation. It is helpful but I have a quick question.
In your demos, I noticed that almost every TM1 formula has an "@" sign in the front. But I can't show it in my PAfE. How did you do that? And what is the difference of whether or not showing this "@" sign in the reports?

------------------------------
mvp morgan

Original Message:
Sent: Wed August 12, 2020 08:07 PM
From: PAUL GLENNON
Subject: Building your Planning and Analytics Reports

Hello everyone, 

You can watch the full recording and demo here. Please share your questions below and the slides are available here. 

Thanks, 


------------------------------
PAUL GLENNON

Original Message:
Sent: Mon August 10, 2020 01:54 PM
From: NICKOLUS PLOWDEN
Subject: Building your Planning and Analytics Reports

Join us for a live webinar to understand the reporting options available in IBM Planning Analytics for Microsoft Excel, IBM Planning Analytics Workspace and web sheets. We'll explain when to use each client, and provide tips and tricks on how to create professional looking reports that meet your business needs quickly and easily.

Building your Planning and Analytics Reports

Watch the On Demand Recording here 

Please share any of your questions below! 
Thanks, 

------------------------------
NICKOLUS PLOWDEN
Check out the Cognos Analytics Webinar Series: https://bit.ly/2M7sciX
------------------------------
#PlanningAnalyticswithWatson