Dears,

We've upgrade TM1 to PAL 2.0.7 and I'm not sure if we've done something wrong with installation/configuration of PAW, but currently the viewer functionality in PAfE connecting to PA cubes is not working properly. This is apparently a limitation of PAfE, I would include PAW as we get the same error, where you can't expand any node and select any dimension members in a cube with more than 25 dimensions (our has 35 dims). 

The error we get when expanding a node is: "Unable to Drill" and when when selecting a dimension members the screen comes blank hanging in that state trying to load the dimension members. 

Has anyone run into the same issue?

Thanks and kindest regards,
Angelo

------------------------------
Angelo B.
------------------------------

#PlanningAnalyticswithWatson

Angelo, 

It could be a bug, but the only way to confirm this is log a call with IBM support.
Couple of points I would like.
1. It is very rare to have more than 16+ dimensions in a cube. This makes it hard to navigate for the user. Have you considered using hierarchies.
I have seen many cases where after careful consideration, such cubes have been condensed to few dimensions. An example where dimensions can be reduced would be x3 dimensions for location, region, country which could easily reduced to 1 dimension where location -> region -> country.
This would also have many other benefits, e.g. speed of calculation, ease of writing rules & reports, better memory management etc.

2. version 2.0.7 is over 1 year old (April 2019). Current release is 2.0.9.1. There have been many fixes since.

3. You do not state which version of PAFE & PAW you are using. This could also be the cause. Again there have been many fixes in the last year.



------------------------------
Raj Kerai
------------------------------

Original Message:
Sent: Tue July 14, 2020 03:27 AM
From: Angelo B.
Subject: PAfE/PAW - Cube dimensions limit

Dears,

We've upgrade TM1 to PAL 2.0.7 and I'm not sure if we've done something wrong with installation/configuration of PAW, but currently the viewer functionality in PAfE connecting to PA cubes is not working properly. This is apparently a limitation of PAfE, I would include PAW as we get the same error, where you can't expand any node and select any dimension members in a cube with more than 25 dimensions (our has 35 dims). 

The error we get when expanding a node is: "Unable to Drill" and when when selecting a dimension members the screen comes blank hanging in that state trying to load the dimension members. 

Has anyone run into the same issue?

Thanks and kindest regards,
Angelo

------------------------------
Angelo B.
------------------------------

#PlanningAnalyticswithWatson

You may want to look at the design of your cube

TM1 Documents

1. Business Rules - http://www.bedrocktm1.org/
2. TI Processes - ftp://public.dhe.ibm.com/software/dw/dm/cognos/financial_management/analytics/turbo_integrator_data_processing_tips_and_techniques.pdf
3. Feeders - https://www.ibm.com/developerworks/data/library/cognos/financial_management/analytics/page620.html or https://www.youtube.com/watch?v=h4BGp4CR7Kc
4. Cube and Element Security - https://www.ibm.com/developerworks/library/ba-pp-security-fpm-page697/index.html
5. TM1 Websheets - https://www.ibm.com/developerworks/library/ba-pp-financial_management-analytics-page694/index.html
6. Dynamic and Static Subsets - http://www.canrocksolutions.com/2011/10/21/tm1-dynamic-subsets/
7. Ten Ways to improve your TM1 application - https://code.cubewise.com/blog/10-tips-to-improve-your-tm1-application
8. Public vs Private View - http://www-01.ibm.com/support/docview.wss?uid=swg21370462
9. Dynamic Reports (Formerly Active Forms) -
10. http://www-01.ibm.com/support/docview.wss?uid=swg21961665&aid=1TM1 Planning Analytics - https://www.youtube.com/channel/UCGYcFhVXoA29v8kSbspLudA

------------------------------
paul YOUNG
------------------------------

Original Message:
Sent: Wed July 15, 2020 03:44 AM
From: Raj Kerai
Subject: PAfE/PAW - Cube dimensions limit

Angelo, 

It could be a bug, but the only way to confirm this is log a call with IBM support.
Couple of points I would like.
1. It is very rare to have more than 16+ dimensions in a cube. This makes it hard to navigate for the user. Have you considered using hierarchies.
I have seen many cases where after careful consideration, such cubes have been condensed to few dimensions. An example where dimensions can be reduced would be x3 dimensions for location, region, country which could easily reduced to 1 dimension where location -> region -> country.
This would also have many other benefits, e.g. speed of calculation, ease of writing rules & reports, better memory management etc.

2. version 2.0.7 is over 1 year old (April 2019). Current release is 2.0.9.1. There have been many fixes since.

3. You do not state which version of PAFE & PAW you are using. This could also be the cause. Again there have been many fixes in the last year.



------------------------------
Raj Kerai

Original Message:
Sent: Tue July 14, 2020 03:27 AM
From: Angelo B.
Subject: PAfE/PAW - Cube dimensions limit

Dears,

We've upgrade TM1 to PAL 2.0.7 and I'm not sure if we've done something wrong with installation/configuration of PAW, but currently the viewer functionality in PAfE connecting to PA cubes is not working properly. This is apparently a limitation of PAfE, I would include PAW as we get the same error, where you can't expand any node and select any dimension members in a cube with more than 25 dimensions (our has 35 dims). 

The error we get when expanding a node is: "Unable to Drill" and when when selecting a dimension members the screen comes blank hanging in that state trying to load the dimension members. 

Has anyone run into the same issue?

Thanks and kindest regards,
Angelo

------------------------------
Angelo B.
------------------------------

#PlanningAnalyticswithWatson

Hi Raj,

Thank you for your message. 

I know it is unlikely to have such a cube, it's an existing model... as of now there isn't any plan to redesign it. I do agree that usage of hierarchies would help quite a lot.

I'll still follow the case with the support and maybe at some point update PA to the latest stable version.

PAfE version:11.0.54
PAW version:2.0.41

Thanks,
A.

------------------------------
Angelo B.
------------------------------

Original Message:
Sent: Wed July 15, 2020 03:44 AM
From: Raj Kerai
Subject: PAfE/PAW - Cube dimensions limit

Angelo, 

It could be a bug, but the only way to confirm this is log a call with IBM support.
Couple of points I would like.
1. It is very rare to have more than 16+ dimensions in a cube. This makes it hard to navigate for the user. Have you considered using hierarchies.
I have seen many cases where after careful consideration, such cubes have been condensed to few dimensions. An example where dimensions can be reduced would be x3 dimensions for location, region, country which could easily reduced to 1 dimension where location -> region -> country.
This would also have many other benefits, e.g. speed of calculation, ease of writing rules & reports, better memory management etc.

2. version 2.0.7 is over 1 year old (April 2019). Current release is 2.0.9.1. There have been many fixes since.

3. You do not state which version of PAFE & PAW you are using. This could also be the cause. Again there have been many fixes in the last year.



------------------------------
Raj Kerai

Original Message:
Sent: Tue July 14, 2020 03:27 AM
From: Angelo B.
Subject: PAfE/PAW - Cube dimensions limit

Dears,

We've upgrade TM1 to PAL 2.0.7 and I'm not sure if we've done something wrong with installation/configuration of PAW, but currently the viewer functionality in PAfE connecting to PA cubes is not working properly. This is apparently a limitation of PAfE, I would include PAW as we get the same error, where you can't expand any node and select any dimension members in a cube with more than 25 dimensions (our has 35 dims). 

The error we get when expanding a node is: "Unable to Drill" and when when selecting a dimension members the screen comes blank hanging in that state trying to load the dimension members. 

Has anyone run into the same issue?

Thanks and kindest regards,
Angelo

------------------------------
Angelo B.
------------------------------

#PlanningAnalyticswithWatson