Search found 6 matches

by VV_VV
Tue Apr 19, 2022 10:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RPTELISCONSOLIDATED function does not work
Replies: 1
Views: 808

TM1RPTELISCONSOLIDATED function does not work

I just ran into an issue when TM1RPTELISCONSOLIDATED does not work in PAX dynamic report. It does not recognize the level of the referenced element and sets all elements to either Leaf or 0 based on the first element in the subset. I tried deleting all rows except of the first one and rebuilding the...
by VV_VV
Thu Apr 14, 2022 7:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to select a given number of elements from the dimension?
Replies: 2
Views: 1613

How to select a given number of elements from the dimension?

Hello, I have a line item dimension with the elements from 1 to 100. I'd like to give a user an ability to select the first 5, 10, ext. elements on the websheet. The dimension is used in the allocation cube, so one value can be allocated to three line items or five, or fifteen. The number should be ...
by VV_VV
Thu Feb 24, 2022 6:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calculation within the same dimension
Replies: 6
Views: 2237

Re: Calculation within the same dimension

Maren, It's incredibly easy when you have one hierarchy and one element that should be calculated like this. Now imagine the hierarchy with multiple consolidations, and your allocations can go to the elements under different parents, and your target element also changes based on the selection in the...
by VV_VV
Wed Feb 23, 2022 5:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calculation within the same dimension
Replies: 6
Views: 2237

Calculation within the same dimension

Hello, Here is an issue. I have a department dimension that is used for data allocation. The dimension looks like this: Total Departments Department 1 Department 2 Department 3 Department 4 I need to be able to calculate the percentage in Department 1 as 100% minus all other departments. I can easil...
by VV_VV
Wed Feb 24, 2021 11:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Weird process names
Replies: 5
Views: 2750

Re: Weird process names

I saw them on the server everywhere: Architect, PAW, Data folder. It turned out they were generated when an admin user manually created a dimension in PAW. I would expect them to be deleted later, but it did not happen.
by VV_VV
Wed Feb 24, 2021 4:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Weird process names
Replies: 5
Views: 2750

Weird process names

Hello,

I started seeing process names that look like this: {9080a8e1-dbec-4f2b-8482-2702fsd5v37c}. They only have a file connection reference, nothing else. What are they, and where did they come from?

Thanks!