Search found 122 matches

by MarenC
Mon Oct 05, 2020 1:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX for elements that exist in both subsets
Replies: 4
Views: 147

Re: MDX for elements that exist in both subsets

Hi Tomok,

you had one too many parenthesis in that but otherwise worked perfectly, thanks!

Maren
by MarenC
Mon Oct 05, 2020 12:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX for elements that exist in both subsets
Replies: 4
Views: 147

MDX for elements that exist in both subsets

Hi, I have 2 mdx based subsets, one to find a variance between the current and next period and another which asks if an employee has an end date. I now want to combine the 2 to see where the variance is possibly due to an end date. I can combine the mdx statements into one with an and condition, whi...
by MarenC
Fri Oct 02, 2020 2:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unexpected behavior of consolidations
Replies: 8
Views: 222

Re: Unexpected behavior of consolidations

Even more unusually only one element appears to have ABS applied to it!

Maren
by MarenC
Fri Oct 02, 2020 12:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unexpected behavior of consolidations
Replies: 8
Views: 222

Re: Unexpected behavior of consolidations

Hi David,

How would you use weightings to solve this issue? I assume you mean 1 and -1 but what about the abs?

Maren
by MarenC
Thu Oct 01, 2020 3:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.07 - }ClientProperties cube
Replies: 12
Views: 668

Re: PA 2.07 - }ClientProperties cube

Hi,

Does this affect licencing in any way? I.e. if they are disabled are they counted?

Maren
by MarenC
Tue Sep 15, 2020 4:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Understanding Persistent Feeders
Replies: 1
Views: 114

Understanding Persistent Feeders

Hi, I have a few questions re persistent feeders, If the data changes in the cube do the persistent feeders get reprocessed, for example where there are conditional feeders? If the rule is changed and then saved will the persistent feeders get saved (refired)? I ask this because a rule change was ma...
by MarenC
Tue Aug 18, 2020 9:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security Assignments
Replies: 1
Views: 146

Security Assignments

Hi, I couldn't quite see a definitive answer online for this, After testing here is my understanding of security assignments: At Cell Level Security you can only apply None, Read and Write but not Locked and Reserve. Locked and Reserve can only be applied at element or cube level security. Is the ab...
by MarenC
Fri Aug 14, 2020 11:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Caret (^) in MDX
Replies: 3
Views: 310

Re: Caret (^) in MDX

Thanks for the reply. Looking at the dimension, the element is no longer a child of the parent. So the dimension hierarchy has changed but the PAW mdx doesn't reflect this. So when you say Unless the MUN is saved in the PAW definition As opposed to what? Or another way of putting it, how do you avoi...
by MarenC
Fri Aug 14, 2020 7:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Caret (^) in MDX
Replies: 3
Views: 310

Caret (^) in MDX

Hi,

In PAW I have noticed the MDX includes a Caret. This seems to represent parent and child.

The issue is that this then throws up all sorts of member not found errors in the logs.

Has anyone noticed this before? I presume we just have to live with it?

Maren
by MarenC
Wed Aug 12, 2020 7:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess within RunProcess and Data commit
Replies: 6
Views: 455

Re: RunProcess within RunProcess and Data commit

Hi, I didn't use any magic formula to determine how long the sleep should be set for. I simply decided to set it as low as possible and in my case the low value made it work. Obviously lower is better because the idea of runprocess is to speed things up and adding in sleep slows things down, so I wa...
by MarenC
Tue Aug 11, 2020 7:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess within RunProcess and Data commit
Replies: 6
Views: 455

Re: RunProcess within RunProcess and Data commit

I experienced something similar and used the Sleep function between each runprocess, which seemed to then populate all the data.
by MarenC
Mon Aug 10, 2020 3:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy your PAW book design to another TM1 server
Replies: 9
Views: 701

Re: Copy your PAW book design to another TM1 server

Hi, You create the snapshot, go to lifecycle management Manage Snapshots, Click Import, select the exported zip, Select Migrate, Migrate Again It should say Select Target Environment (there should be a default) Enter a Folder name Select Migrate again If the server name doesn't exist it should fail,...
by MarenC
Mon Aug 10, 2020 9:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy your PAW book design to another TM1 server
Replies: 9
Views: 701

Re: Copy your PAW book design to another TM1 server

Hi,

Isn't there also the option that when you Migrate and it errors (because the target server doesn't exist) it allows you to Select a TM1 database and you can then select the one you want?

Maren
by MarenC
Wed Aug 05, 2020 9:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel SumIF in TM1
Replies: 9
Views: 483

Re: Excel SumIF in TM1

Hi Highkeys, well that depends on how the dimensions are structured I would think. If he just needs the elements from dimension A and the rest can be hard coded values, so consolidations from the other dimensions and a measure, I wouldn't see any need for a loop as such. If the if part is sumif is f...
by MarenC
Wed Aug 05, 2020 8:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel SumIF in TM1
Replies: 9
Views: 483

Re: Excel SumIF in TM1

Hi,

he might be able to do cellget if the dimension structures allow for it? I thought that was the point of TM1.

Maren
by MarenC
Thu Jul 30, 2020 12:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: NewDateFormatter Use
Replies: 3
Views: 246

Re: NewDateFormatter Use

Hi Wim, I didn't know I did need to check those patterns so thanks for that. I see the issue now, the small m was presuming minute. If I change it as follows it appears to work: cDate = '31/07/2020'; vDateFormater = NewDateFormatter(''); vDateCompareSerial = ParseDate(vDate, 'dd/MM/yyyy'); vDateComp...
by MarenC
Thu Jul 30, 2020 10:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: NewDateFormatter Use
Replies: 3
Views: 246

NewDateFormatter Use

Hi, I want to get the serial date of the following date: 31/07/2020. Normally I would subst this and use DayNo. But I thought I would try the following: cDate = '31/07/2020'; vDateFormater = NewDateFormatter(''); vDateCompareSerial = ParseDate(vDate, 'dd/mm/yyyy'); vDateCompare = FormatDate( vDateCo...
by MarenC
Tue Jul 28, 2020 9:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change of MDX security in 2.0.9 - Discussion
Replies: 18
Views: 2603

Re: Change of MDX security in 2.0.9 - Discussion

Hi Moby,

cant seem to see anything in those links about the changes to the mdx!

Maren
by MarenC
Mon Jul 27, 2020 2:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidator Rule - Issue With Sandbox
Replies: 1
Views: 192

Re: Consolidator Rule - Issue With Sandbox

Not sure but what if you prefix the elements with the dimension and hierarchy names?

Maren