Using Planning Analytics cubes in Cognos Analytics

 View Only

Using Planning Analytics cubes in Cognos Analytics 

Tue September 27, 2022 04:30 AM

This document is designed to provide guidance on how to set up Planning Analytics (PA) cubes in Cognos Analytics (CA) so that they can be used as a data source for reports and dashboards.

Topics include:
- Architectural overview
- Pros and cons of reporting in CA vs PA
- Overview of the steps
- Editing the PA Model
- Creating a data source connection in CA
- Navigating PA cubes in CA
- Best practice tips on CA reporting over PA


#PlanningAnalyticswithWatson

Statistics

0 Favorited
56 Views
1 Files
0 Shares
20 Downloads
​
Attachment(s)
pdf file
Using Planning Analytics cubes in Cognos Analytics.pdf   658 KB   1 version
Uploaded - Tue September 27, 2022
 
Download

Comments

Zdenek Hanzal
Mon October 03, 2022 08:13 AM

Hi, great Summary and material!

on the best practice tips, we would be interested in knowing how the stargate views work in CA cross sessions/users.
If someone initiate the stargate view, can someone else reuse it asking for the same perimeter or its per user, is security applied at the end?

Also we have one tip around breaking MUNs and caption validation in prompt pages. We sue this parameter to show correctly prompt when MUN have changed. It has a small (acceptable) overhead but bringing some comfort to users. 
RSVP.PARAMETERS.CLEANSE=true

Plus these parameters we found useful for our PA&CA integrated solution:

paUseRootMembers

paUseFillerMember

TM1RESTClientSocketTimeout

v5.enableFilterSetOptimization

Regards
Zdenek