Search found 349 matches
- Fri Nov 12, 2021 4:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI View Execution vs MDX View
- Replies: 13
- Views: 31549
Re: TI View Execution vs MDX View
I am currently working on breaking each export down into 12 chunks (1 per month) and executing in parallel using 24 processes. My initial findings are that its still slower even through this route than using the TI to export the data to file. 33 Versions x 12 Months = 396 Total slices to export (396...
- Wed Nov 10, 2021 4:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI View Execution vs MDX View
- Replies: 13
- Views: 31549
Re: TI View Execution vs MDX View
In my case im trying to use TM1py to execute the mdx which doesn't leave me with an option for ViewExtractSkipZeroesSet (At least not with the ExecutePowerBI function. I may try and play around with some of the other TM1py execute functions to see if anything helps. The best case would be to find a ...
- Tue Nov 09, 2021 8:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI View Execution vs MDX View
- Replies: 13
- Views: 31549
Re: TI View Execution vs MDX View
No that was just a typo. I have been able to use the NonEmpty() function instead of NON EMPTY keyword on the rows. While this has helped and it now completes, there is still a noticeable performance drop as more dimensions are added to the NonEmpty() function. My guess is that it still relates to th...
- Mon Nov 08, 2021 3:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI View Execution vs MDX View
- Replies: 13
- Views: 31549
Re: TI View Execution vs MDX View
MDX is fairly simple. Its roughly something like this. SELECT {[Dim1].[Dim1].[Version1],[Dim1].[Dim1].[Version2]} *{[Dim2].[Dim2].[Local Currency],[Dim2].[Dim2].[USD]} ON 0, NON EMPTY {DESCENDANTS([Dim3].[Dim4].[Total Dim3] , 99 , LEAVES)} *{DESCENDANTS([Dim4].[Dim4].[Total Dim4] , 99 , LEAVES)} *{D...
- Sun Nov 07, 2021 4:50 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI View Execution vs MDX View
- Replies: 13
- Views: 31549
Re: TI View Execution vs MDX View
I figured it was doing something different than executing MDX due to the difference in behavior. I guess the question is, how would I get a similar view of data out through the rest api if all I get is MDX/View capability? Wondering if anyone else has run into a similar issue? When I execute the MDX...
- Sat Nov 06, 2021 11:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI View Execution vs MDX View
- Replies: 13
- Views: 31549
TI View Execution vs MDX View
I have been working a bit with TM1py and have been using MDX to retrieve cube data. I have run into an issue where my MDX seems to timeout when executing, both in a Cube Viewer and and in TM1py. This is somewhat understandable as I have put all the dimensions on the rows except one. There appears to...
- Wed Jul 01, 2020 11:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Experience with PAW and its future prospects
- Replies: 13
- Views: 6536
Re: Experience with PAW and its future prospects
In my opinion PAW is better than what existed prior to it. What your end goal is definetly drives whether or not it will work for you. If you want to stay inside the box and use the functionality it has then I do think it provides a better user experience overall. I like many have forced myself to u...
- Wed Jul 01, 2020 11:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW Synchronise Action Button parameters with Sheet Selections
- Replies: 8
- Views: 4992
Re: PAW Synchronise Action Button parameters with Sheet Selections
You can upload a worksheet that has nothing but an action button on it with hidden subnm's. Just synchronize the sheet and minimize the size of the sheet widget to only the width of the button. The sheet subnm's will be the same as your PAW selectors which in my opinion or much better than the TM1We...
- Tue May 12, 2020 11:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX - weight of a member
- Replies: 5
- Views: 5015
Re: MDX - weight of a member
Not to drag up an old post but did anyone figure out the syntax of how to use this? I was looking for a way to filter for all elements that have a weight not equal to 1. I realize weighting is based up on the elements relationship to a parent but there isn't any documentation on the syntax and it wo...
- Tue Dec 03, 2019 9:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1.Lock Contention happens on some dimension objects due to read operations in concurrent TI processes
- Replies: 8
- Views: 5409
Re: TM1.Lock Contention happens on some dimension objects due to read operations in concurrent TI processes
Couldn't quite tell from the post but do you turn logging on/off in your TI's? If so it turns out that CubeGetLogChanges/CubeSetLogChanges is locking. You would need to use CellPutS to the }CubeProperties cube for Logging instead. It is definetly causing locking for us especially when Chores start t...
- Tue Dec 03, 2019 9:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Devops in PA/TM1
- Replies: 9
- Views: 6574
Re: Devops in PA/TM1
Searching log files - Notepad++ and FileSeek (FileSeek is amazing as you can search the transaction logs and filter for keywords, by modified dates, etc. Dev Lifecycle - JIRA and for a lite version of code compare you can use BitBucket/Fisheye although I wouldn't reccommend using for direct deployme...
- Wed Nov 13, 2019 7:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX - dynamic subset to filter by two other dimensions
- Replies: 12
- Views: 12850
Re: MDX - dynamic subset to filter by two other dimensions
Hi PlanningDev, Maybe you can explain where in the MDX Mode=PT AND level=LevelA is referenced because it is confusing me! :? Im guessing but I believe its the two filters. Programme Type = Global Level and then Mode = Global Mode. Mode = PT is just his example of the Mode attribute of dimension Cou...
- Wed Nov 13, 2019 4:39 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX - dynamic subset to filter by two other dimensions
- Replies: 12
- Views: 12850
Re: MDX - dynamic subset to filter by two other dimensions
Edit: I realise I've got this wrong. Mark's syntax above is working fine, just not giving me what I want. If I select Mode=PT and Level=LevelA, it returns all courses with mode=PT (regardless of level) plus all courses with level=LevelA (regardless of mode). Whereas I want it to return just those c...
- Tue Nov 05, 2019 7:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX - dynamic subset to filter by two other dimensions
- Replies: 12
- Views: 12850
Re: MDX - dynamic subset to filter by two other dimensions
Im not 100% certain, but I tested a few examples and I believe the issue is that IIF wants to return either a numeric value or a string value. It appears that it is supposed to be able to return a set however in this case you are evaluating a string and so it seems to want a string value to be retur...
- Tue Jul 23, 2019 10:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Pass a blank value in Action Button
- Replies: 1
- Views: 1420
Re: Pass a blank value in Action Button
Edited, using a reference to an existing blank cell does not work
- Tue Jul 23, 2019 10:07 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Piclists in Perspectives
- Replies: 13
- Views: 6389
Re: Piclists in Perspectives
On the sheet where the dropdown is not working, can you try hard coding the Server:CubeName portion of the DBRW? Depending on what's in R12 I have seen issues where the original view for the Active Form is not inclusive of the whats in the DBRW that you may have added manually. Im not sure if thats ...
- Tue Jul 23, 2019 9:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Pass a blank value in Action Button
- Replies: 1
- Views: 1420
Pass a blank value in Action Button
Does anyone know how to pass a blank value through an action button to a worksheet cell? Conceptually, Im trying to make it so that when you click the action button it clears out the data in a cell. If I don't put anything in the value under the advanced options it doesn't do anything. So far the on...
- Tue Jul 02, 2019 5:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 REST API Postman Requests
- Replies: 4
- Views: 4035
Re: TM1 REST API Postman Requests
Get dimensions that have a name matching the specified text http://server:port/api/v1/Dimensions?$filter=contains(Name, 'search text here') Remove element from parent http://server:port/api/v1/Dimensions('DimName')/Hierarchies('HierarchyName')/Edges(ParentName='ParentElementName', ComponentName='Chi...
- Mon Jul 01, 2019 9:46 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 REST API Postman Requests
- Replies: 4
- Views: 4035
Re: TM1 REST API Postman Requests
Are you trying to get data from a cube or trying to write data to a cube? Or just looking for working examples of a few types of operations?
- Thu May 30, 2019 5:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI summary display
- Replies: 14
- Views: 7033
Re: TI summary display
Depending on what your TI is doing you could fire your TI process off using TM1RunTi.exe which would release the user session back allowing the person to continue working. In your TI that is processing you could add similar logic to the below. On your summary screen someone would just have to refres...