Search found 102 matches
- Thu Mar 15, 2018 12:33 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: View Size issue
- Replies: 11
- Views: 9607
Re: View Size issue
ISSUE RESOLVED!!! SOLUTION: I just changed the method of creation of the Subset from standard way SUBSETELEMENTINSERT() to SUBSETCREATEBYMDX() and it is now working. The Looks like there is a bug in version 10.2.2 FP6 (or may be other version too). It appears that in the background it includes all ...
- Wed Mar 14, 2018 6:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: View Size issue
- Replies: 11
- Views: 9607
Re: View Size issue
To be clear, are you getting your error when the view is processing in the METADATA/DATA tabs or are you getting the error when you try to open it in cube viewer? Btw, ViewSuppressZeroesSet is the same as using both ViewColumnSuppressZeroesSet + ViewRowSuppressZeroesSet. :) The error appears on the...
- Wed Mar 14, 2018 2:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: View Size issue
- Replies: 11
- Views: 9607
Re: View Size issue
One thing to remember is that the ViewExtract... functions do not have the same effect as the ViewRowSuppressZeroesSet, ViewColumnSuppressZeroesSet and ViewSuppressZeroesSet. The first are for views used as data sources and I do not think they have any effect on a datasourceview you then try to ope...
- Wed Mar 14, 2018 2:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: View Size issue
- Replies: 11
- Views: 9607
Re: View Size issue
You don't say what version you're on - I've just had this on a PAX report that normally runs OK on 10.2.2 and threw this error in the log in 11.030. FWIW, I increased the maximumviewsize and it went away - you can increase this dynamically, so it should be easy to test higher maximumviewsize settin...
- Wed Mar 14, 2018 2:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: View Size issue
- Replies: 11
- Views: 9607
Re: View Size issue
Hi Wim, most of the other dimensions are fairly small (less than 1000). One dimension has about 8000. But the dimension from which I am picking up the consolidated element is large (~100K)Wim Gielis wrote: ↑Wed Mar 14, 2018 7:23 am Are the other selections in the dimensions also large and containing 1000s of elements?
- Wed Mar 14, 2018 1:10 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: View Size issue
- Replies: 11
- Views: 9607
View Size issue
Hello everyone, I need some help/direction for the below issue. Your guidance will be appreciated in this matter. I am constructing a View in the Prolog of a TI. The view consists of LEAF elements from all of the dimensions but one dimension subset contains only one element which is a Consolidated n...
- Fri Feb 09, 2018 5:04 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: String Feeder
- Replies: 6
- Views: 5794
- Thu Feb 08, 2018 10:43 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: String Feeder
- Replies: 6
- Views: 5794
String Feeder
I am writing a very basic String Rule and Feeder and for some reason my head is not getting around this. The rule is working fine but the feeder is not behaving properly and suppressing zeros is not working. The simplified version of the my Rules/feeders as follows: SKIPCHECK; FEEDSTRINGS; ['Measure...
- Wed Jan 23, 2013 9:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI Process Execution Time out
- Replies: 4
- Views: 4174
Re: TI Process Execution Time out
Not sure if this approach is what you are after but... 1. Capture the start time when the TI launches. 2. Define the maximum run time of the TI. 3. Periodically test the elapsed run time of the TI in the TI and process break / quit if the run time in 2 has been exceeded. Yes, this is something whic...
- Wed Jan 23, 2013 9:44 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cube Zero Out while TM1 server is not running
- Replies: 4
- Views: 3025
Re: Cube Zero Out while TM1 server is not running
To start your actual server without data in a cube just replace the cube file with the "empty template". I understand we can not run an TI function if the server is not running. I thought someone might be aware of a 3rd-party tool or some work around to empty the cubes. Unfortunatly, I do...
- Wed Jan 23, 2013 8:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI Process Execution Time out
- Replies: 4
- Views: 4174
TI Process Execution Time out
Hi,
I know a TI Process can be manually killed using TM1Top. But I am looking for a functionality/workaround by which we can kill (cancel execution) a TI process if it has not finished execution after a certain period of time.
Any ideas/suggestions will be highly appreciated.
I know a TI Process can be manually killed using TM1Top. But I am looking for a functionality/workaround by which we can kill (cancel execution) a TI process if it has not finished execution after a certain period of time.
Any ideas/suggestions will be highly appreciated.
- Wed Jan 23, 2013 8:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cube Zero Out while TM1 server is not running
- Replies: 4
- Views: 3025
Cube Zero Out while TM1 server is not running
Hi, I know we can clear/zeroout the data in the cube while the TM1 server is running. But I am looking for a functionality/workaround by which I can clear the data within the cubes while the server is not running. This will be handy if the server does not have enough physical resources and we would ...
- Wed Oct 19, 2011 6:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Sort a TI created subset
- Replies: 13
- Views: 29906
Re: Sort a TI created subset
I need to sort the Subset elements within a TI Process. As advised by rmackenzie we can only use the MDX for the existing Subsets, therefore I think using MDX is not a option for me. How can we use the Position parameter in the SubsetElementInsert()? or is there any other way to do this? Please help!
- Thu Oct 06, 2011 7:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Equivalent of TM1User() function in Rules
- Replies: 23
- Views: 19501
Re: Equivalent of TM1User() function in Rules
I just figured out that we can use TM1User() function both in TI Process and Rules.
The Tm1 manual is bit misleading - says that it is only for worksheets.
The Tm1 manual is bit misleading - says that it is only for worksheets.
- Thu Oct 06, 2011 7:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Equivalent of TM1User() function in Rules
- Replies: 23
- Views: 19501
Equivalent of TM1User() function in Rules
I want to create a TM1 rule which is based on the current Username. e.g
I know we can get the username in Worksheets using TM1User() function, but is there any equivalient function for Rules?
If not then, please let me know if you know a woraround to this.
Thanks!
I know we can get the username in Worksheets using TM1User() function, but is there any equivalient function for Rules?
If not then, please let me know if you know a woraround to this.
Thanks!
- Tue Sep 06, 2011 6:40 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1Web - Hyperlink or Action Button to open a Cube View
- Replies: 18
- Views: 20437
Re: TM1Web - Hyperlink or Action Button to open a Cube View
Is there any help availabe for the TM1Web API? I want to understand the Syntax. The only example which I could find in the manual is: http://boston/TM1WebMain.aspx?action=OpenObject&type=Cubeviewer&value=plan_BudgetPlan$$Budget%20Input%20Detailed$$PUBLIC&title_plan_business_unit=Canada&a...
- Fri Sep 02, 2011 4:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1Web - Hyperlink or Action Button to open a Cube View
- Replies: 18
- Views: 20437
Re: TM1Web - Hyperlink or Action Button to open a Cube View
You could very easily use the TM1 Web URL API to hyperlink to a named public view, what's wrong with that? If I can hyperlink to the view using TM1 Web URL API then it would be great. Can I put that hyperlink on the Websheet or in Action Button? I have not worked with TM1 Web URL API before. Please...
- Fri Sep 02, 2011 1:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1Web - Hyperlink or Action Button to open a Cube View
- Replies: 18
- Views: 20437
Re: TM1Web - Hyperlink or Action Button to open a Cube View
My end-user want to navigate to the Cube Views so that slice and dice the data.
So even if the drill-through works as sugges it wont help in this case.
Any ideas/workarounds?
So even if the drill-through works as sugges it wont help in this case.
Any ideas/workarounds?
- Thu Sep 01, 2011 8:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1Web - Hyperlink or Action Button to open a Cube View
- Replies: 18
- Views: 20437
TM1Web - Hyperlink or Action Button to open a Cube View
I am designing a dashboard for the end-user which will have Actions Buttons to open the realted Websheets. But I also want to provide links on the Dashboard to users by which they can open Cube Views (which are saved within the Applications folder) rather then opening the Views from the Navigation P...
- Fri Aug 19, 2011 3:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Action Button Size issue in TM1Web
- Replies: 2
- Views: 3031
Action Button Size issue in TM1Web
TM1 9.5.2, Excel 2007. Hi, I am having issue with the size of Action Button. Some of the Action buttons are appearing bigger in TM1Web. See the attached image for details: TM1Web_ActiveButton_Size.JPG At least half of the buttons are not appearing correctly. I have also tried to set them with a fixe...