Search found 1460 matches
- Wed Feb 13, 2019 3:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBO Connection to MSAS Failing
- Replies: 2
- Views: 46
Re: ODBO Connection to MSAS Failing
Small update. It would appear that you have to have the same versioned SQL client on the TM1 DB as the SQL DB in order for ODBO to work. My belief is that the movement from Office 2007 to 2016 has probably moved the ODBO drivers past the compatibility with the SQL version. I'm trying to arrange for ...
- Tue Feb 12, 2019 9:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBO Connection to MSAS Failing
- Replies: 2
- Views: 46
ODBO Connection to MSAS Failing
Wondering if anyone might have any insights on what the resolution to my problem maybe. We have some TIs that reach out to MSAS that have been working for many moons without issue They recently all started failing both at runtime and on edit. When the TI opens it fails fast, with the message "Cannot...
- Tue Feb 12, 2019 5:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Location of the file accessible from the Cognos TM1 server
- Replies: 3
- Views: 137
Re: Location of the file accessible from the Cognos TM1 server
Hi Daniel, In the TI process there are two paths to set the first is the path from the point of view of the server, the other is from the point of view of the client, i.e. where you opened the TI editor screen. So at runtime the first of these paths is used, if the TM1 server on the Ubuntu box can't...
- Fri Feb 08, 2019 2:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Server/Service Restart on Crash - Planning Analytics, PAx and PAW 2.0
- Replies: 1
- Views: 37
Re: Server/Service Restart on Crash - Planning Analytics, PAx and PAW 2.0
FYI for your crash https://www.tm1forum.com/viewtopic.php?f=3&t=14493 For your question. You can request them to set the service to restart automatically on failure, that is probably the easiest thing to do. If you have another TM1 service running you can probably get some DOS together for TM1 to ex...
- Thu Feb 07, 2019 5:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Server crash on saving dimension (status Suspended)
- Replies: 10
- Views: 163
Re: TM1 Server crash on saving dimension (status Suspended)
In response to our defect we've been told that there was a defect relating to "re-ordering elements" in the dim editor (rather than formally setting the sort order) causing the server to fail. This was fixed in 205 IF 3 and 206 We tested our use case and have confirmed the issue is resolved. Since n...
- Thu Feb 07, 2019 4:50 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Server crash on saving dimension (status Suspended)
- Replies: 10
- Views: 163
Re: TM1 Server crash on saving dimension (status Suspended)
Hi PavoGa,
What's your version number please? Did you get this acknowledged by IBM?
Cheers,
What's your version number please? Did you get this acknowledged by IBM?
Cheers,
- Thu Feb 07, 2019 12:56 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Server crash on saving dimension (status Suspended)
- Replies: 10
- Views: 163
Re: TM1 Server crash on saving dimension (status Suspended)
Hi Ken, We have seen this a few times as well. The only repeatable instance we have had is when two people were in the perspectives dimension editor at the same time and had both performed edits (obviously not best practice but it does happen). We have raised this with IBM. (TS001876885) We have ins...
- Thu Feb 07, 2019 9:25 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX expression for NextMember in case of variable source member
- Replies: 4
- Views: 107
Re: MDX expression for NextMember in case of variable source member
Interesting work Wim but... To the OP you should take care building critical functionality that depends on the ordering of the dimension as it is very hard to have direct control over it. This would be much simpler if you just had an attribute that held the next week. Sorry Wim, just realised the yo...
- Wed Feb 06, 2019 3:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Write a calculated value to all elements in a dimension
- Replies: 2
- Views: 78
Re: Write a calculated value to all elements in a dimension
Fundamentally yes if using TI, you may want to look at spreading. Not much to go on here Manu but you should look at your design / requirements IMO. Writing the same value "to all values in the time dimension" would seem to be an odd thing to need to do, can't this be an attribute of the element in ...
- Mon Feb 04, 2019 6:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Planning Analytics Administration agent
- Replies: 3
- Views: 100
Re: Planning Analytics Administration agent
Pretty sure that Planning Analytics Administration (PAA) is the new "ops console" part of PAW where you can monitor the behaviour of your hardware and TM1 databases.
https://www.ibm.com/support/knowledgece ... rvers.html
https://www.ibm.com/support/knowledgece ... rvers.html
- Fri Feb 01, 2019 8:29 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active forms
- Replies: 2
- Views: 69
Re: Active forms
Action buttons can sometimes been a little temperamental, best bet is jut to set it up again (via right click, properties).
For example they can't cope with changes to sheet names if you have referenced cells on the worksheet.
For example they can't cope with changes to sheet names if you have referenced cells on the worksheet.
- Thu Jan 31, 2019 10:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX for getting Parent and Children
- Replies: 17
- Views: 202
Re: MDX for getting Parent and Children
I think I vaguely remember a tech note from an age ago to the effect that DRILLDOWNMEMBER should not be used and the TM1 specific variant should be or perhaps it was the "solution" to a defect that was raised...
- Thu Jan 31, 2019 9:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW: cannot enter into a consolidation
- Replies: 11
- Views: 173
Re: PAW: cannot enter into a consolidation
Can you remember the creation sequence that led to this? In theory every N level should end up in the leaves hierarchy, if this is not reliable then this is a bit of an issue..
- Wed Jan 30, 2019 5:19 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW: cannot enter into a consolidation
- Replies: 11
- Views: 173
Re: PAW: cannot enter into a consolidation
What happens if you use the right click spreading options do you get any kind of error message? These should be the same bits of functionality accessed I different ways.
- Wed Jan 30, 2019 5:16 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW TI Editor
- Replies: 6
- Views: 254
Re: PAW TI Editor
It may be "muscle memory," but Notepad++ seems to be much faster and offers some features I like over the PAW editors. If you take the time to say what these features are you never know who might be watching and find that these features make it into the product (eventually). I have found the produc...
- Wed Jan 23, 2019 6:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Data Loss Due To MTFeeders
- Replies: 5
- Views: 156
Re: Data Loss Due To MTFeeders
The link has no date or version reference so its hard to be sure if this tech note is still current?
There was an old defect in this space which has already been fixed, are we sure this is new / regression?
There was an old defect in this space which has already been fixed, are we sure this is new / regression?
- Fri Jan 18, 2019 11:52 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic subset to select all leaf-level elements, except one
- Replies: 4
- Views: 93
Re: Dynamic subset to select all leaf-level elements, except one
Except is the function you are looking for
- Fri Jan 11, 2019 9:32 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAx not fully recalculating
- Replies: 8
- Views: 357
Re: PAx not fully recalculating
Hi Loki, Might be worth posting detailed version numbers
- Wed Jan 09, 2019 11:59 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Missing object access after copy from Prod to Dev
- Replies: 8
- Views: 343
Re: Missing object access after copy from Prod to Dev
Sounds to me like the cfg is pointing to an empty folder so it has created the initial starting objects.
Best guess is that your network engineer has not correctly copied the files to the correct location.
Best guess is that your network engineer has not correctly copied the files to the correct location.
- Tue Jan 08, 2019 10:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAx not fully recalculating
- Replies: 8
- Views: 357
Re: PAx not fully recalculating
If you are talking about DBRWs / custom report then you need to check the force recalc on f9 option in the PAx options to get f9 working. If you don't (I think) normal excel calcs take over and only cells that have a dependency that has changed will be refreshed.