Search found 102 matches

by ExApplix
Thu Mar 15, 2018 12:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View Size issue
Replies: 11
Views: 2294

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 ...
by ExApplix
Wed Mar 14, 2018 6:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View Size issue
Replies: 11
Views: 2294

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...
by ExApplix
Wed Mar 14, 2018 2:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View Size issue
Replies: 11
Views: 2294

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...
by ExApplix
Wed Mar 14, 2018 2:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View Size issue
Replies: 11
Views: 2294

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...
by ExApplix
Wed Mar 14, 2018 2:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View Size issue
Replies: 11
Views: 2294

Re: View Size issue

Wim Gielis wrote:
Wed Mar 14, 2018 7:23 am
Are the other selections in the dimensions also large and containing 1000s of elements?
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)
by ExApplix
Wed Mar 14, 2018 1:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View Size issue
Replies: 11
Views: 2294

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...
by ExApplix
Fri Feb 09, 2018 5:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String Feeder
Replies: 6
Views: 1592

Re: String Feeder

macsir wrote:
Fri Feb 09, 2018 2:52 am
Are you saying that I should remove the SKIPCHECK , STRINGFEEDERS and FEEDERS from the rule?

By removing SKIPCHECK will it not effect the performance as TM1 will not skip the empty cells anymore?
by ExApplix
Thu Feb 08, 2018 10:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String Feeder
Replies: 6
Views: 1592

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...
by ExApplix
Wed Jan 23, 2013 9:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process Execution Time out
Replies: 4
Views: 1677

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...
by ExApplix
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: 956

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 not have ...
by ExApplix
Wed Jan 23, 2013 8:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process Execution Time out
Replies: 4
Views: 1677

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.
by ExApplix
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: 956

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 ...
by ExApplix
Wed Oct 19, 2011 6:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sort a TI created subset
Replies: 13
Views: 7137

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!
by ExApplix
Thu Oct 06, 2011 7:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Equivalent of TM1User() function in Rules
Replies: 17
Views: 7897

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.
by ExApplix
Thu Oct 06, 2011 7:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Equivalent of TM1User() function in Rules
Replies: 17
Views: 7897

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!
by ExApplix
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: 14
Views: 10242

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&UseIndex=no B...
by ExApplix
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: 14
Views: 10242

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...
by ExApplix
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: 14
Views: 10242

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?
by ExApplix
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: 14
Views: 10242

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...
by ExApplix
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: 1196

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...