PAW Time Series Line Chart with Separate Year and Month Dimensions

Post Reply
bkkbasher
Posts: 24
Joined: Mon Aug 26, 2013 8:39 am
OLAP Product: PAx & PAW
Version: PA 2.0.8
Excel Version: Excel 2019

PAW Time Series Line Chart with Separate Year and Month Dimensions

Post by bkkbasher » Wed Aug 19, 2020 9:33 am

Hi,

Struggling to get a single time series line chart in Workspace with our cubes having separate Year and Month dimensions. Just end up with multiple lines for each year or each month. Is this not possible with two dimensions?! Can't find anything related online and no matter how i orientate the underlying table i just cannot get it to fall out.

Thanks!

User avatar
macsir
Community Contributor
Posts: 720
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365
Contact:

Re: PAW Time Series Line Chart with Separate Year and Month Dimensions

Post by macsir » Wed Aug 19, 2020 8:28 pm

Hi, I don't think you do it simply in PAW.
1. Possible to create another cube with just one time dimension and use it in PAW?
2. Export data into PowerBI via tm1py and present from there?
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/

bkkbasher
Posts: 24
Joined: Mon Aug 26, 2013 8:39 am
OLAP Product: PAx & PAW
Version: PA 2.0.8
Excel Version: Excel 2019

Re: PAW Time Series Line Chart with Separate Year and Month Dimensions

Post by bkkbasher » Fri Aug 21, 2020 7:58 am

Thanks for reply.

1. Yeah, a second cube is looking like the only option at the moment. Seems a lot of extra trouble for something reasonably straight forward though!
2. PAW was supposed to be our new visualisation too. Not sure i want to bring PowerBI into this. Also, purpose of the sheet is for analysts to manipulate a forecast and so will be writeback on it and then see the impact in the chart.

Still quite a few yawning gaps in PAW's functionality.

declanr
MVP
Posts: 1671
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: PAW Time Series Line Chart with Separate Year and Month Dimensions

Post by declanr » Fri Aug 21, 2020 9:06 am

Since the introduction of Alternative Hierarchies I believe the best solution is to have a single continuous time dimension and then use alternative hierarchies to split it into Year and Month. That way you can utilise the same cubes in different ways; meaning you can get the benefit of each option as and when you want it.
Declan Rodger

bkkbasher
Posts: 24
Joined: Mon Aug 26, 2013 8:39 am
OLAP Product: PAx & PAW
Version: PA 2.0.8
Excel Version: Excel 2019

Re: PAW Time Series Line Chart with Separate Year and Month Dimensions

Post by bkkbasher » Mon Aug 24, 2020 2:29 am

:shock:
The prospect of having to rebuild all the cubes with year and month dimensions in them.

However, to really start taking advantage of these hierarchies, a major rebuild seems inevitable one way or another.

bkkbasher
Posts: 24
Joined: Mon Aug 26, 2013 8:39 am
OLAP Product: PAx & PAW
Version: PA 2.0.8
Excel Version: Excel 2019

Re: PAW Time Series Line Chart with Separate Year and Month Dimensions

Post by bkkbasher » Tue Sep 15, 2020 3:28 am

Quick update on this. I created an RFE with IBM for this (create time series chart with two dimensions) and it has been tagged by them as Planned! Good news.

Post Reply