IBM Business Analytics

Hi everyone,

I vaguely remember in one of the updates/AMA that it was mentioned that the 'print report' of similar function to burst reports for PAfE was in the pipeline.

Moving to 2.1, this and the disappearance of the application folder with the ability to reference views in business process order, remains a concern for the hardened Excel super user. 

Any ideas are welcome.

TIA

Hi Francois. In my opinion the best way die burst reports is using Cognos Analytics. (Excel, PDF, HTML Format). 

Jens

Hi everyone,

I vaguely remember in one of the updates/AMA that it was mentioned that the 'print report' of similar function to burst reports for PAfE was in the pipeline.

Moving to 2.1, this and the disappearance of the application folder with the ability to reference views in business process order, remains a concern for the hardened Excel super user. 

Any ideas are welcome.

TIA

Hi Jens,

Thank you.

 In this particular case, the function is currently available within Perspectives, but with the upgrade to PA2.1, it will no longer be. Adding new software and skills to maintain the same result is not feasible for the client at this stage.

For those with the same need, an idea has been logged quite a while ago, please go and vote: https://ibm-data-and-ai.ideas.ibm.com/ideas/PAOP-I-61 

Francois

Hi Francois. In my opinion the best way die burst reports is using Cognos Analytics. (Excel, PDF, HTML Format). 

Jens

Hi everyone,

I vaguely remember in one of the updates/AMA that it was mentioned that the 'print report' of similar function to burst reports for PAfE was in the pipeline.

Moving to 2.1, this and the disappearance of the application folder with the ability to reference views in business process order, remains a concern for the hardened Excel super user. 

Any ideas are welcome.

TIA

I have a different opinion on this. Adding Cognos Analytics makes things far more complex and difficult for excel users. Not to mention Cognos Analytics and Planning Analytics still don't work well together (no matter what the marketing material says). We decided to go with ReportWORQ to solve this problem, it offers significantly more functionality than perspectives did. https://reportworq.com/

Hi Jens,

Thank you.

 In this particular case, the function is currently available within Perspectives, but with the upgrade to PA2.1, it will no longer be. Adding new software and skills to maintain the same result is not feasible for the client at this stage.

For those with the same need, an idea has been logged quite a while ago, please go and vote: https://ibm-data-and-ai.ideas.ibm.com/ideas/PAOP-I-61 

Francois

Hi Francois. In my opinion the best way die burst reports is using Cognos Analytics. (Excel, PDF, HTML Format). 

Jens

Hi everyone,

I vaguely remember in one of the updates/AMA that it was mentioned that the 'print report' of similar function to burst reports for PAfE was in the pipeline.

Moving to 2.1, this and the disappearance of the application folder with the ability to reference views in business process order, remains a concern for the hardened Excel super user. 

Any ideas are welcome.

TIA

I came across this problem myself recently when a prospective customer asked if we could design an Excel report for one cost centre, and then generate the same report in separate workbooks, one workbook per cost centre. I presumed that this would be standard functionality in PAfE and was surprised to find out that it was not. This also came up as a question on yesterday's AMA session. Attached is a solution that I developed using VBA - I've tested it in a demo environment and it seems to work pretty well, though I haven't tried it out for real yet. Anyway, I'm attaching a Word document describing how the solution operates; the VBA code is at the bottom of the document. Hopefully it might be useful to someone else.

I have a different opinion on this. Adding Cognos Analytics makes things far more complex and difficult for excel users. Not to mention Cognos Analytics and Planning Analytics still don't work well together (no matter what the marketing material says). We decided to go with ReportWORQ to solve this problem, it offers significantly more functionality than perspectives did. https://reportworq.com/

Hi Jens,

Thank you.

 In this particular case, the function is currently available within Perspectives, but with the upgrade to PA2.1, it will no longer be. Adding new software and skills to maintain the same result is not feasible for the client at this stage.

For those with the same need, an idea has been logged quite a while ago, please go and vote: https://ibm-data-and-ai.ideas.ibm.com/ideas/PAOP-I-61 

Francois

Hi Francois. In my opinion the best way die burst reports is using Cognos Analytics. (Excel, PDF, HTML Format). 

Jens

Hi everyone,

I vaguely remember in one of the updates/AMA that it was mentioned that the 'print report' of similar function to burst reports for PAfE was in the pipeline.

Moving to 2.1, this and the disappearance of the application folder with the ability to reference views in business process order, remains a concern for the hardened Excel super user. 

Any ideas are welcome.

TIA

Hi Mark,

Thanks for the file, I'll take a look and let you know.

Many of the hardened perspective users struggle to adopt the move to PAfE. For them, these types of capabilities are critical to their process. I'll keep on asking IBM to include it in PAfE, and hopefully, like Stuart said, it can be made available later.

I came across this problem myself recently when a prospective customer asked if we could design an Excel report for one cost centre, and then generate the same report in separate workbooks, one workbook per cost centre. I presumed that this would be standard functionality in PAfE and was surprised to find out that it was not. This also came up as a question on yesterday's AMA session. Attached is a solution that I developed using VBA - I've tested it in a demo environment and it seems to work pretty well, though I haven't tried it out for real yet. Anyway, I'm attaching a Word document describing how the solution operates; the VBA code is at the bottom of the document. Hopefully it might be useful to someone else.

I have a different opinion on this. Adding Cognos Analytics makes things far more complex and difficult for excel users. Not to mention Cognos Analytics and Planning Analytics still don't work well together (no matter what the marketing material says). We decided to go with ReportWORQ to solve this problem, it offers significantly more functionality than perspectives did. https://reportworq.com/

Hi Jens,

Thank you.

 In this particular case, the function is currently available within Perspectives, but with the upgrade to PA2.1, it will no longer be. Adding new software and skills to maintain the same result is not feasible for the client at this stage.

For those with the same need, an idea has been logged quite a while ago, please go and vote: https://ibm-data-and-ai.ideas.ibm.com/ideas/PAOP-I-61 

Francois

Hi Francois. In my opinion the best way die burst reports is using Cognos Analytics. (Excel, PDF, HTML Format). 

Jens

Hi everyone,

I vaguely remember in one of the updates/AMA that it was mentioned that the 'print report' of similar function to burst reports for PAfE was in the pipeline.

Moving to 2.1, this and the disappearance of the application folder with the ability to reference views in business process order, remains a concern for the hardened Excel super user. 

Any ideas are welcome.

TIA