Search found 349 matches

by PlanningDev
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...
by PlanningDev
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 ...
by PlanningDev
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...
by PlanningDev
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...
by PlanningDev
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...
by PlanningDev
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...
by PlanningDev
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...
by PlanningDev
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...
by PlanningDev
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...
by PlanningDev
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...
by PlanningDev
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...
by PlanningDev
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...
by PlanningDev
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...
by PlanningDev
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...
by PlanningDev
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
by PlanningDev
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 ...
by PlanningDev
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...
by PlanningDev
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...
by PlanningDev
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?
by PlanningDev
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...