Search found 782 matches

by paulsimon
Sat Feb 20, 2021 9:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create MDX View To Suppress Rule-Defined Cells
Replies: 2
Views: 123

Re: Create MDX View To Suppress Rule-Defined Cells

Hi Adam

If you submit your MDX using the Rest API, then in the ODATA query you can retrieve something that tells you whether the cell is rule calculated. However, I do not know a way of doing it in MDX alone.

Regards

Paul Simon
by paulsimon
Wed Feb 10, 2021 11:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess Again
Replies: 14
Views: 710

Re: RunProcess Again

Hi Pavo Thanks for confirming that your issue with locking in temporary subsets is only related to temporary subsets that are MDX based. We don't use of those. Typically our MDX subsets are for things like get all base elements or full hierarchy. These are created as permanent subsets as part of our...
by paulsimon
Wed Feb 10, 2021 8:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess Again
Replies: 14
Views: 710

Re: RunProcess Again

Hi Pavo Interesting that you have still got locks when using temporary views and subsets. Surely creating a permanent subset is more likely to cause lock contention since that is a meta data event? If I understand you correctly, you are relying on the lock being relatively short by creating the subs...
by paulsimon
Tue Feb 09, 2021 9:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess Again
Replies: 14
Views: 710

Re: RunProcess Again

Hi

Where possible use temporary subsets and views. This had a dramatic effect on our lock contention, not to mentioned clutter.
by paulsimon
Tue Feb 09, 2021 9:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Prevent Consolidation Sums for an Element
Replies: 5
Views: 384

Re: Prevent Consolidation Sums for an Element

Hi Charlotte It really depends on your purposes but my gut feel is that you should avoid using a string measure. If you want one measure to roll up and the other not to roll up then you can do this Have one dimension with a consolidation A B C Have a measures dimension crossed with this with two mea...
by paulsimon
Mon Feb 08, 2021 10:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess Again
Replies: 14
Views: 710

Re: RunProcess Again

Hi Maren If you are going to use RunProcess to set off 300 lots of Process A in parallel, then you aren't going to get that degree of parallel processing unless your box has 300 processors. Therefore I would not bother about the fact that an instance of Process A will not complete until Process B fi...
by paulsimon
Thu Feb 04, 2021 7:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Prevent Consolidation Sums for an Element
Replies: 5
Views: 384

Re: Prevent Consolidation Sums for an Element

Hi Charlotte I am not sure what you are asking. If you want an element at the bottom of the hierarchy and you don't want values in this to sum up, then using a zero weight as Declan suggests is the way to go. However, if when you say the lowest level dimension, you actually mean the measures dimensi...
by paulsimon
Tue Feb 02, 2021 11:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube to Cube Consolidation
Replies: 6
Views: 491

Re: Cube to Cube Consolidation

Vasek In your Data tab put a TextOutput( 'temp.txt', A_VNO_G_Rada ) ; Run the process and then look at the output in temp.txt and you will see what data it is getting Your screen shot only showed the source dimension in the title area. Is it possible that as Lotsaram says that you only have source d...
by paulsimon
Mon Feb 01, 2021 9:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA Cloud Optimization
Replies: 8
Views: 388

Re: PA Cloud Optimization

Hi Jim It doesn't sound like there is anything unusual in the model. The one thing you could try is perhaps temporarily knocking out the effect of any rules on the ElementAttributes and the Picklist cube by using an [] = STET. That would at least allow you to eliminate that as a possible cause. I gu...
by paulsimon
Mon Feb 01, 2021 8:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA Cloud Optimization
Replies: 8
Views: 388

Re: PA Cloud Optimization

Hi Jim Hope all is well with you. We are running PA 2.0.5 so even older and we have dimensions with 13000 elements and we are not getting a problem in TM1 Web. Is there anything special about this dimension? Some things that you might want to check : Does the dimension have chained consolidations su...
by paulsimon
Sat Jan 30, 2021 12:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube to Cube Consolidation
Replies: 6
Views: 491

Re: Cube to Cube Consolidation

Hi

Either add a consolidation on top of your Cas dimension and implement my original suggestion
Or
Change your CellPutN to CellIncrementN, as you will be getting multiple rows from your data source and you need to add them all together in the target cube

Regards

Paul Simon
by paulsimon
Fri Jan 29, 2021 7:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube to Cube Consolidation
Replies: 6
Views: 491

Re: Cube to Cube Consolidation

Hi There are a few things that could be improved. I note that the Source and Target cubes only have one dimension in common, as well as the Source having an extra dimension. You are reading from a cube that has one more dimension than the target but you are not specifying the source element in the A...
by paulsimon
Thu Jan 21, 2021 11:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need to create an MDX or filter results from a cube view using TM1 Rest
Replies: 3
Views: 362

Re: Need to create an MDX or filter results from a cube view using TM1 Rest

Hi In this case you don't use a Native View. You use an MDX query which is superficially like a SQL statement but not quite the same An example on the sdata sample database is SELECT {[actvsbud].[Actual],[actvsbud].[Budget]} on columns , NON EMPTY CROSSJOIN( { DRILLDOWNMEMBER( {TM1FILTERBYPATTERN( {...
by paulsimon
Tue Jan 19, 2021 10:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need to create an MDX or filter results from a cube view using TM1 Rest
Replies: 3
Views: 362

Re: Need to create an MDX or filter results from a cube view using TM1 Rest

Hi It might be possible to do this using the Rest API alone by somehow filtering the results returned by the Native View. However, it might take you a while some help from Hubert to do that one. Alternatives are a) Execute an MDX Query - more complex MDX queries can use sub queries a bit like in SQL...
by paulsimon
Thu Jan 14, 2021 8:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: HierarchySortOrder problem
Replies: 3
Views: 334

Re: HierarchySortOrder problem

Hi Micheline I am not sure if Scott has some back ground info on your model. However, if you do have just two different consolidations within a classic dimension then you are not going to be able to achieve what you want as the sort order you set with DimensionSortOrder is going to apply to all elem...
by paulsimon
Thu Dec 10, 2020 9:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User Upload csv files through PAW interface
Replies: 4
Views: 411

Re: User Upload csv files through PAW interface

Hi We allow users to upload data via CSV. We use a small VB.Net programme to do this. They get to this via a hyperlink from TM1 Web using the EXCEL HyperLink function which passes in the name of the Cost Centre etc to be loaded. The VB.Net is quite dumb. All it does is upload the file and to rename ...
by paulsimon
Mon Dec 07, 2020 8:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: non-admins edit permission to 1 dimension via PAW ?
Replies: 7
Views: 418

Re: non-admins edit permission to 1 dimension via PAW ?

Hi tsw Presumably, you are aware that if the user accidentally deletes an element, that they lose the data from the cubes, not just the element? Even if the element is a consolidation, deleting it will take it out of subsets, that can then affect views and in turn processes. It can also invalidate r...
by paulsimon
Sat Dec 05, 2020 5:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: non-admins edit permission to 1 dimension via PAW ?
Replies: 7
Views: 418

Re: non-admins edit permission to 1 dimension via PAW ?

Hi We provide the ability for users to update dimensions, but not directly. In my view it is easy enough for an experienced developer to make a mistake using the Dimension Editor, let alone an end-user. In our situation we have many contributors with their own local chart of accounts. They need to b...
by paulsimon
Wed Nov 25, 2020 11:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Refresh subnm mdx subset in pax
Replies: 7
Views: 506

Re: Refresh subnm mdx subset in pax

Hi Sorry I missed the SUBNM in the post. Can you confirm it is a name not an index? You would probably still need it to be an index for it to show the revised element selection. In the process that adds the element do you have a RefreshMDXHierarchy( vDim ) in the Epilog? Another possibility might be...
by paulsimon
Wed Nov 25, 2020 8:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Refresh subnm mdx subset in pax
Replies: 7
Views: 506

Re: Refresh subnm mdx subset in pax

Hi You didn't show the SUBNM Does it by any chance identify the element in something in double quotes rather than an index number? If the value for the element is given in quotes, then it will always show that value whether it is in the subset or not. It you give an index it will show the element at...