Search found 210 matches
- 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...
- 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.
- 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...
- 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
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
- 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...
- 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?
- 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...
- 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
- 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...
- 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...
- 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.
- 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!!!
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!!!
- 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. ...
- 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:
To resolve try ['String'] = S:
- 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.
- 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...
- 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 ...
- 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...
- 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...
- 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?