Search found 210 matches

by BigG
Thu Aug 21, 2014 5:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders not re-firing on restart
Replies: 13
Views: 11044

Feeders not re-firing on restart

Hi, I have feeders from a data entry 4 dimension cube (with string picklists from dims) targeting a 7 dimension cube that has used rules to 'pivot' the picklist string items from source cube. I feed from strings, and use feedstrings; in 1st line of rules of cube with feeders (sourcecube). Everything...
by BigG
Thu Oct 03, 2013 9:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Worksheet Directory for multiple TM1 Servers
Replies: 4
Views: 3725

Re: Worksheet Directory for multiple TM1 Servers

Thanks for the suggestions, I think work through the options.
by BigG
Thu Oct 03, 2013 6:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Worksheet Directory for multiple TM1 Servers
Replies: 4
Views: 3725

Worksheet Directory for multiple TM1 Servers

Hi all, I am aiming to create a dimension worksheet directory for a TM1 server, but if I have multiple TM1 servers will I have to use a shared single location because.. TM1® saves the dimension worksheet files to the first directory listed in the Local Server Data Directory field in the Options dial...
by BigG
Sun Sep 15, 2013 9:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Source MDX from Tm1 Cube text with variable, then create sub
Replies: 4
Views: 3641

Re: Source MDX from Tm1 Cube text with variable, then create

brilliant rmackenzie

Thanks ET too, I think rmackenzie has resolved the issue.

'{ TM1FILTERBYLEVEL( {TM1SUBSETALL( [' | vDimName | '] ) }, 0 ) }'

should be

{ TM1FILTERBYLEVEL( {TM1SUBSETALL( [%DIM_NAME%] ) }, 0 ) }

and then use TI code to strip and replace information
by BigG
Fri Sep 13, 2013 5:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Source MDX from Tm1 Cube text with variable, then create sub
Replies: 4
Views: 3641

Source MDX from Tm1 Cube text with variable, then create sub

Hi there, This is a curly. I am testing a concept by where I enter my MDX string into a cube and then extract the MDX string into a TI with CellGetS, then SubsetCreatebyMDX Due to MDX being long strings I also break my MDX into parts using concatenated variables eg. vMDX = '{ TM1FILTERBYLEVEL( {TM1S...
by BigG
Thu Feb 21, 2013 12:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form crashing. Is there a better way?
Replies: 2
Views: 1813

Re: Active Form crashing. Is there a better way?

have you tried using MDX in the RPTROW? Instead of referncing hidden sheets?
by BigG
Thu Feb 21, 2013 12:21 am
Forum: General
Topic: SaaS BI In the Cloud
Replies: 2
Views: 6528

Re: SaaS BI In the Cloud

Great news that the big players are starting to offer cloud capability for BI and CPM. I think IBM havent followed suite because legacy products do not easily transfer to cloud SAAS capabilities. They need to redesign/ build from the ground up for it to be a true SAAS model, otherwise its just cloud...
by BigG
Thu Feb 21, 2013 12:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export to Excel
Replies: 4
Views: 4940

Re: Export to Excel

looks a bit different but does it realte to http://www-01.ibm.com/support/docview.w ... wg21595430
by BigG
Thu Feb 21, 2013 12:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Slow to open views a few hours after restart of services
Replies: 18
Views: 9352

Re: Slow to open views a few hours after restart of services

The root cause could be described further as the bug in the TM1 code caused the new version of the cube in memory to distrust the version in cache and therefore ignore it. When the cube was started in the morning it updated the cube and all its dependencies thereby causing a delay. The action that c...
by BigG
Wed Oct 31, 2012 10:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Slow to open views a few hours after restart of services
Replies: 18
Views: 9352

Re: Slow to open views a few hours after restart of services

Yes ok, long story short. It is unusual but not as unique as I initially thought. Whether it is something in the model that exposed the flaw it is still a flaw and required a code fix to resolve. The cube rules are nothing special, there is a lot of aggregation is occurring from another more detaile...
by BigG
Tue Oct 30, 2012 11:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Slow to open views a few hours after restart of services
Replies: 18
Views: 9352

Re: Slow to open views a few hours after restart of services

Hi, just an update, was none of the above, instead it is a TM1 product code fix coming through on a hot fix for 9.5.2. An error in the cache mechanism of TM1.
by BigG
Mon Oct 15, 2012 10:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: executecommand doesnt run a batch
Replies: 4
Views: 3691

Re: executecommand doesnt run a batch

thanks for the replies, answers to questions:

It seems we are onto something with
viewtopic.php?p=33913#p34024. as it is also calling xml excel create vbs
creating C:\Windows\SysWOW64\config\systemprofile\Desktop folder

and it works!!!
by BigG
Fri Oct 12, 2012 4:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: executecommand doesnt run a batch
Replies: 4
Views: 3691

executecommand doesnt run a batch

Hi there, searched around but couldnt find any thing specific. My TI runs an execute command for a batch, the batch file runs correctly if I manually run it. But TI does not run the process the batch calls a vb script eg. C:\windows\system32\Cscript.exe E:\TM1_... ###.vbs If I put a file create eg. ...
by BigG
Sun Oct 07, 2012 10:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best option for not calculating other versions in cubes
Replies: 24
Views: 14108

Re: Best option for not calculating other versions in cube

In 9.5.2 I found something similar with S: rules, they didnt work if any [<empty>] rule statements were prior to the rule, seem to stop string calculated values from being recognised by subsequent rule.

To resolve try ['String'] = S:
by BigG
Tue Sep 18, 2012 10:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Contirbutor Questions (10.1)
Replies: 3
Views: 2592

Re: Contirbutor Questions (10.1)

We have a similar problem with 9.5.2 cube viewer and just have to tell the users to not enter totals...Breakback is a great feature on a cube by cube (or even line by line) basis, but IBM has not introduced any method to turn off and on yet. Hopefully something for the future.
by BigG
Wed Sep 12, 2012 2:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Slow to open views a few hours after restart of services
Replies: 18
Views: 9352

Re: Slow to open views a few hours after restart of services

apologies for the apathy on my part. If I go to virtual memry in performance options of system properties I see page filing is "Automatically managed" by the server. With current settings Min 16MB, recomended 18430 and currently allocated 12287 MB on C Drive . Should we be customising? - i...
by BigG
Wed Sep 12, 2012 2:24 am
Forum: Bugs
Topic: 952 - Memory Leak?
Replies: 13
Views: 88509

Re: 952 - Memory Leak?

Symptoms: - Slow but continuous increase in tm1s.exe memory footprint (18%->24% over three days with minimal data activity). - Swap jumps to full as TM1 somehow gets entangled despite available physical ram (at least when I look at ram after the event) - TM1 will run (in swapped fashion) until the ...
by BigG
Tue Sep 11, 2012 11:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Slow to open views a few hours after restart of services
Replies: 18
Views: 9352

Re: Slow to open views a few hours after restart of services

Hi thanks for the reply, since we are in development we have a small number of users testing and they sit within earshot... so I can confirm they do not use sandbox function Tm1top has been observed and you can see the processing of a view (all cell point calculations), but all they are doing is ope...
by BigG
Tue Sep 11, 2012 2:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Slow to open views a few hours after restart of services
Replies: 18
Views: 9352

Re: Slow to open views a few hours after restart of services

I thought yesterday the problem was resolved , but it has raised its head again. With performance monitor turned on I could not see any real impact / increase of memory use. it was more in task manager the CPU usage was very high, to a point it was difficult to actually log on to the server. the use...
by BigG
Mon Sep 10, 2012 12:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Admin server is not starting
Replies: 5
Views: 3994

Re: Admin server is not starting

Do the other Tm1 services start individually?