Search found 1095 matches
- Thu Dec 14, 2017 6:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Change in Element Name of a frequently used Dimension
- Replies: 14
- Views: 8501
Re: Change in Element Name of a frequently used Dimension
... I do not even know how to use a hex editor to find the references to the dimension element i want. I surely get that it is a painful job but i would certainly like to get an idea of that. Can Pspad be used for this purpose? You need a proper hex editor, not a text editor, I use Free Hex Editor ...
- Thu Dec 14, 2017 2:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Change in Element Name of a frequently used Dimension
- Replies: 14
- Views: 8501
Re: Change in Element Name of a frequently used Dimension
... These aren't text files so you'll need a hex editor in order to find the references to the dimension element you want. I've never tried this before and I highly doubt it will work but give it a try. Just make sure you do it on backup copies of everything... I have often used the Hex Editor meth...
- Mon Dec 11, 2017 7:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI process is not getting executed from a Worksheet Application. Please help kind folks!
- Replies: 10
- Views: 6910
Re: TI process is not getting executed from a Worksheet Application. Please help kind folks!
"worksheet scoped named ranges" relate to named ranges that are valid only on the sheet you define them. For example, If you have a workbook with multiple sheets and each of them had a Business Date cell for example, you could reference that cell using the cell reference e.g. $B$6 or alter...
- Fri Dec 08, 2017 7:36 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI process is not getting executed from a Worksheet Application. Please help kind folks!
- Replies: 10
- Views: 6910
Re: TI process is not getting executed from a Worksheet Application. Please help kind folks!
I would recommend using worksheet scoped named ranges for the process and parameters references. This way, column and rows changes do not affect the Action button. I have also found that between office versions, the Action Button properties seem to change/break, especially the server reference - dou...
- Wed Dec 06, 2017 10:31 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX to Filter on Numeric Attribute
- Replies: 8
- Views: 14469
Re: MDX to Filter on Numeric Attribute
Thanks Steve, agree on the strings and the usage of another cube as you can secure better as well as use picklists to populate the text "attribute".Steve Rowe wrote: ↑Wed Dec 06, 2017 10:24 am ...Personally I rarely use them since they behave like strings and I can't write rules versus them...
- Wed Dec 06, 2017 9:56 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX to Filter on Numeric Attribute
- Replies: 8
- Views: 14469
Re: MDX to Filter on Numeric Attribute
Thanks for the response and info Lotsa - will be using option 3 for the foreseeable future as many clients are still on 10.2.2 FP4.
- Wed Dec 06, 2017 6:15 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX to Filter on Numeric Attribute
- Replies: 8
- Views: 14469
Re: MDX to Filter on Numeric Attribute
Hi TM123, it does indeed give me the results-too long looking at a problem from one angle. Thanks for the assistance!
FYI - my initial MDX seems to work fine on PAX 2.0.1 - something must have been fixed.
Still curious though about the answers to some of the other questions posed in my initial post.
FYI - my initial MDX seems to work fine on PAX 2.0.1 - something must have been fixed.
Still curious though about the answers to some of the other questions posed in my initial post.
- Tue Dec 05, 2017 6:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX to Filter on Numeric Attribute
- Replies: 8
- Views: 14469
MDX to Filter on Numeric Attribute
I am trying to find a better way to filter on a Numeric Attribute (contains 0/1) where the name of the Attribute also happens to be the name of one of the Members. Using the standard syntax to filter on an attribute returns the context error as the MDX is ambiguous. Using the following code does not...
- Fri Dec 01, 2017 5:18 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: unwinding certain elements issue
- Replies: 10
- Views: 7133
Re: unwinding certain elements issue
Will refer you to the search function as this has been covered many times over the years - your basic problem is that you are creating fragments by unwinding from the top down-you need to work backwards through the dimension/hierarchy in most cases. Edit: Could you not use MDX to create a subset wit...
- Tue Nov 28, 2017 6:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active Form formatting calculated rules
- Replies: 3
- Views: 2989
Re: Active Form formatting calculated rules
I have previously added attributes to the dimension used in column B and read these in to column A to drive the formatting-depends on your needs but may work. You could obviously create composite values and format accordingly.
- Sat Nov 25, 2017 5:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Help needed: rollup recursively from element to root level?
- Replies: 2
- Views: 2256
Re: MDX Help needed: rollup recursively from element to root level?
Try something like this:
If the elements exists in multiple hierarchies, only the first is returned.
Code: Select all
HIERARCHIZE({Ascendants([<dim>].[<element>])})
- Tue Nov 14, 2017 4:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: after Cube optimization -> TI won't run
- Replies: 7
- Views: 4707
Re: after Cube optimization -> TI won't run
Should you be suppressing zeroes - you don't appear to be [ViewExtractSkipCalcsSet (sCube, sqView, 0); ]-this could be using too much memory - anything in your tm1server.log or tm1processerrors?
- Tue Nov 14, 2017 3:45 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Installation of TM1 Perspectives: Excel crash
- Replies: 3
- Views: 3431
Re: Installation of TM1 Perspectives: Excel crash
Hi Wim,
Just updated to same release, no issues on my side-I do however load Perspectives via a macro as I switch between 10.2.2 and PAL.
Not sure if that would make any difference in behaviour i.e. Add-in vs Open after launching Excel.
Just updated to same release, no issues on my side-I do however load Perspectives via a macro as I switch between 10.2.2 and PAL.
Not sure if that would make any difference in behaviour i.e. Add-in vs Open after launching Excel.
- Mon Nov 13, 2017 3:07 pm
- Forum: Useful code, tips and tricks
- Topic: Inspecting views
- Replies: 5
- Views: 17562
Re: Inspecting views
Thanks Wim-still trying to find time to digest the previous processes shared-will add to my backlog!
- Wed Nov 01, 2017 6:39 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Unusual Problems with Text Files in TI Processes
- Replies: 3
- Views: 2466
Re: Unusual Problems with Text Files in TI Processes
When you say that a CSV file loads with no problems, but the TXT does not, I get confused, unless you are generating two different files from the ERP.
The file extension should have no impact. What are the field separators in both the CSV and TXT files, for clarification?
The file extension should have no impact. What are the field separators in both the CSV and TXT files, for clarification?
- Tue Oct 31, 2017 4:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Unwinding specific elements in GLobal Customer diension
- Replies: 1
- Views: 1411
Re: Unwinding specific elements in GLobal Customer diension
Why not use a subset as the basis for your unwinding with only the elements you want to unwind otherwise use ELISANC to check if an element is part of the rollups to skip?
- Sat Oct 28, 2017 2:39 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Undo after save in Excel 2016 with TM1 add in
- Replies: 15
- Views: 9554
Re: Undo after save in Excel 2016 with TM1 add in
Can also concur with the above-just updated to Build 1709 (8528.2147) and the pre-halloween gremlins have gone, for now!
- Fri Oct 27, 2017 11:39 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 upgrade to Planning Analytics
- Replies: 3
- Views: 2419
Re: TM1 upgrade to Planning Analytics
If you do install PAW, you would need to buy licenses on a 1 to 1 ratio for existing users.
Once upgraded, you cannot downgrade: http://www.ibm.com/support/docview.wss? ... SS9RXT-_-E
Once upgraded, you cannot downgrade: http://www.ibm.com/support/docview.wss? ... SS9RXT-_-E
- Tue Oct 24, 2017 11:29 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ExecuteCommand Copy file
- Replies: 10
- Views: 5475
Re: ExecuteCommand Copy file
As soon as I save the file, seems to lose the char(150) and substitutes with a regular hyphen-cannot really do much more. Hopefully they will rename and you can move forward. I have had similar filenames in the past for Unix environments but managed to work with them by simply surrounding names in d...
- Tue Oct 24, 2017 10:31 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ExecuteCommand Copy file
- Replies: 10
- Views: 5475
Re: ExecuteCommand Copy file
Having a problem creating a file with the char(150) in the name-tried Excel VBA, File explorer etc. and it keeps replacing with a normal dash.
Could you upload a sample file, without the data of course.
Could you upload a sample file, without the data of course.