View Construct Issue PMR 86469,756,000
- jim wood
- Site Admin
- Posts: 3953
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
View Construct Issue PMR 86469,756,000
Guys,
Do you know if there is any difference (apart from unicode) between view construct in 9.1 and 9.5.2? How does it handle the out of page view selections?
Thanks in advance,
Jim.
Do you know if there is any difference (apart from unicode) between view construct in 9.1 and 9.5.2? How does it handle the out of page view selections?
Thanks in advance,
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Posts: 54
- Joined: Tue Jun 15, 2010 1:43 pm
- OLAP Product: Cognos TM1
- Version: 9.0 - 10.2
- Excel Version: 2010
Re: View Construct
Jim,
I am unaware of this on a technical level, but we've seen problems using this function in 9.5.2. Using this function caused a crash of our service.
Of course, I tried using this on our largest, most rule-driven cube... I don't know what happened under the hood here, but I am interested to hear the responses to this.
I am unaware of this on a technical level, but we've seen problems using this function in 9.5.2. Using this function caused a crash of our service.
Of course, I tried using this on our largest, most rule-driven cube... I don't know what happened under the hood here, but I am interested to hear the responses to this.
- jim wood
- Site Admin
- Posts: 3953
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: View Construct
I have a bit if a weird one were I have a cube of around 400MB and another of around 14GB. When using view construct for both cubes in both cases memory increases by 2GB???? Previously when they ran it it didn't behave this way. Memory went up but not to the extent.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Posts: 54
- Joined: Tue Jun 15, 2010 1:43 pm
- OLAP Product: Cognos TM1
- Version: 9.0 - 10.2
- Excel Version: 2010
Re: View Construct
I saw similar issue where we had an operating RAM at 50Gb (as a service). This ended up eclipsing 195Gb, causing a service crash.
-
- MVP
- Posts: 3667
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: View Construct
Jim what exactly do you mean? ViewConstruct caches values in from the view in memory, nothing more. I don't think unicode is relevant (other than additional memory use in general), and what is "out of page view selection"?jim wood wrote:Guys,
Do you know if there is any difference (apart from unicode) between view construct in 9.1 and 9.5.2? How does it handle the out of page view selections?
Thanks in advance,
Jim.
-
- Posts: 98
- Joined: Sat Feb 11, 2012 11:13 am
- OLAP Product: TM1 9x, BPC, Hyperion, HANA
- Version: TM1 10
- Excel Version: Excel 2003 - 2010
Re: View Construct
Highly Speculative but worth a shot !!
I am not sure but have a look at this document http://www-01.ibm.com/support/docview.w ... wg21460595
"Internal testing comparing like tests comparing TM1 9.5.1 to TM1 9.5.2 with PI have shown the TM1 9.5.2 Server to allocate between 10 – 30% more RAM than the TM1 9.5.1 server. Some of this increased memory use is due to the internal structures created by PI, however the additional throughput of transactions – and their impact on View Cache – is also a contributing factor. IBM recommends planning for 30% more memory usage with TM1 9.5.2 than with prior versions of TM1."
It would be nice to know whether if PI is enabled in all the instances which are having this issue.
I am not sure but have a look at this document http://www-01.ibm.com/support/docview.w ... wg21460595
"Internal testing comparing like tests comparing TM1 9.5.1 to TM1 9.5.2 with PI have shown the TM1 9.5.2 Server to allocate between 10 – 30% more RAM than the TM1 9.5.1 server. Some of this increased memory use is due to the internal structures created by PI, however the additional throughput of transactions – and their impact on View Cache – is also a contributing factor. IBM recommends planning for 30% more memory usage with TM1 9.5.2 than with prior versions of TM1."
It would be nice to know whether if PI is enabled in all the instances which are having this issue.
- jim wood
- Site Admin
- Posts: 3953
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: View Construct
I know what it does so thanks for that. I also know what the impact of unicode is (which is why I put apart) so thanks also for that. When I say out of page view selections I mean the ones at the top that are not physically within the view page area were you have to have one element selected? Does that help? I can upload a screen dump if you like??lotsaram wrote:Jim what exactly do you mean? ViewConstruct caches values in from the view in memory, nothing more. I don't think unicode is relevant (other than additional memory use in general), and what is "out of page view selection"?jim wood wrote:Guys,
Do you know if there is any difference (apart from unicode) between view construct in 9.1 and 9.5.2? How does it handle the out of page view selections?
Thanks in advance,
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- jim wood
- Site Admin
- Posts: 3953
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: View Construct
It doesn't have PI enabled as it is a BI model and there isn't a great deal of writing going on. I good punt though and thanks.nick_leeson wrote:Highly Speculative but worth a shot !!
I am not sure but have a look at this document http://www-01.ibm.com/support/docview.w ... wg21460595
"Internal testing comparing like tests comparing TM1 9.5.1 to TM1 9.5.2 with PI have shown the TM1 9.5.2 Server to allocate between 10 – 30% more RAM than the TM1 9.5.1 server. Some of this increased memory use is due to the internal structures created by PI, however the additional throughput of transactions – and their impact on View Cache – is also a contributing factor. IBM recommends planning for 30% more memory usage with TM1 9.5.2 than with prior versions of TM1."
It would be nice to know whether if PI is enabled in all the instances which are having this issue.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- MVP
- Posts: 3667
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: View Construct
Only the title elements selected by index are included in the cached stargate view. It doesn't matter if a subset is assigned with other elements in it, if you want to cache for more than one filter element in one or more of the filter dimensions then you would have to cycle through by index and do more ViewConstructs.jim wood wrote:.... When I say out of page view selections I mean the ones at the top that are not physically within the view page area were you have to have one element selected? Does that help? I can upload a screen dump if you like??
If you are talking about the feature in TM1 Web and BI where you can have a filter/title dimension that isn't visible to the user then I am pretty certain that it would be treated the same as any other title element. I don't see how this could be any different since the view construct isn't something that happens on the UI level, it is just a background job to pre-calculate an array of values that belong to the view.
- jim wood
- Site Admin
- Posts: 3953
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: View Construct
That pretty much covers it cheers. That's always what I understood to be the case but I was unsure whether it had changed down the version. Thanks.lotsaram wrote:Only the title elements selected by index are included in the cached stargate view. It doesn't matter if a subset is assigned with other elements in it, if you want to cache for more than one filter element in one or more of the filter dimensions then you would have to cycle through by index and do more ViewConstructs.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- jim wood
- Site Admin
- Posts: 3953
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: View Construct Issue PMR 86469,756,000
I have moved this to the bugs section as IBM have been able to replicate the issue,
Jim.
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- MVP
- Posts: 227
- Joined: Fri Mar 11, 2011 2:18 pm
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: 2003 2007
Re: View Construct Issue PMR 86469,756,000
What version of the TM1 9.5.2 software are you running ?
Are you already running TM1 9.5.2 FP1 HF5 or newer ?
TM1 9.5.2 FP1 HF5 includes two patches addressing defects of the TI fct ViewConstruct logged as APAR PM49801 and PM54252:
(1)
https://www-304.ibm.com/support/entdocv ... wg1PM49801
PM49801: TM1 VIEWCONSTRUCT IS NOT WORKING - OUTOFMEMORY EXCEPTION <<< MEMORY_TEMP_POOL_EXCEEDED >>>
Error description
After unloading a cube, any attempt to reconstruct the view fails.
(2)
https://www-304.ibm.com/support/entdocv ... wg1PM54252
PM54252: EXCESSIVE START UP TIME...UNKNOWN
Error description
Following the Initial Calc Chore - comprised of 'CubeProcessFeeders' and 'ViewConstructs' - the duration of the chore has jumped from 30 mins to 1 hr to over 1 day.
Are you already running TM1 9.5.2 FP1 HF5 or newer ?
TM1 9.5.2 FP1 HF5 includes two patches addressing defects of the TI fct ViewConstruct logged as APAR PM49801 and PM54252:
(1)
https://www-304.ibm.com/support/entdocv ... wg1PM49801
PM49801: TM1 VIEWCONSTRUCT IS NOT WORKING - OUTOFMEMORY EXCEPTION <<< MEMORY_TEMP_POOL_EXCEEDED >>>
Error description
After unloading a cube, any attempt to reconstruct the view fails.
(2)
https://www-304.ibm.com/support/entdocv ... wg1PM54252
PM54252: EXCESSIVE START UP TIME...UNKNOWN
Error description
Following the Initial Calc Chore - comprised of 'CubeProcessFeeders' and 'ViewConstructs' - the duration of the chore has jumped from 30 mins to 1 hr to over 1 day.
- jim wood
- Site Admin
- Posts: 3953
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: View Construct Issue PMR 86469,756,000
Many thanks Moby. They are running the latest 9.5.2 hot fix pick install. They have not installed any hot fixes beyond the pack. As for the fixes / errors thanks for making me (and the community) aware of them but the issue we have doesn't directly correspond to either but it is close. You never know either fix may address the issue indirectly but just to clarify....
1) We are not unloading the cube before running view construct.
2) We are not running any other TI command other than view construct, so process feeders isn't applied.
I will however recommend to the customer that they apply the latest hot fix just in case,
Jim.
1) We are not unloading the cube before running view construct.
2) We are not running any other TI command other than view construct, so process feeders isn't applied.
I will however recommend to the customer that they apply the latest hot fix just in case,
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- jim wood
- Site Admin
- Posts: 3953
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: View Construct Issue PMR 86469,756,000
Just a quick note to let you know that the development team have indentified this as an issue with the software. Neither of the fixes raised by Moby helped. A fix for this is due in the next FP which is slated for release in April. If however they manage to fix the issue before hand a hot fix will be released. Either way I will add the details to this post,
Jim.
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- jim wood
- Site Admin
- Posts: 3953
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: View Construct Issue PMR 86469,756,000
Guys,
According to IBM this issue has been fixed with 9.5.2 FP2. For a reason that is beyond me that didn't add this PMR to the fix list,
Jim.
According to IBM this issue has been fixed with 9.5.2 FP2. For a reason that is beyond me that didn't add this PMR to the fix list,
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7