Search found 346 matches

by MarenC
Wed Mar 27, 2024 12:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5122

Re: Ultimate Long TM1 quiz

Assuming Consolidation TypeIn Spreading is not set to Deny then what ardi says (assuming the user wasn't an Admin)!
by MarenC
Tue Mar 26, 2024 5:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rule to Propagate Values Between Dimensions
Replies: 6
Views: 419

Re: TM1 Rule to Propagate Values Between Dimensions

Hi, I think we need more information, one bit of information that would be useful is what do you mean exactly by "But both this rule is not working."? Also, if you provide a single example of a product that isn't working, i.e. provide its 'at_CPG' attribute value and also the 'att_PPBU' at...
by MarenC
Tue Mar 26, 2024 9:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rule to Propagate Values Between Dimensions
Replies: 6
Views: 419

Re: TM1 Rule to Propagate Values Between Dimensions

Hi, On first reading this doesn't make sense to me, I think you say you want to update the product attributes based on the CPG attributes but you appear to be putting the rule in the CPG attribute cube, not the product attribute cube? I would have expected to see something like this: ['at_PBBU'] = S...
by MarenC
Mon Mar 25, 2024 3:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics workspace is down
Replies: 8
Views: 1034

Re: Planning Analytics workspace is down

Hi Paxuser,

Thank you for taking the time to update this case.

Maren
by MarenC
Thu Mar 21, 2024 2:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Referencing a lookup cube or Attribute in a TI Process
Replies: 5
Views: 631

Re: Referencing a lookup cube or Attribute in a TI Process

Hi, vCCElements='!006 Main - Cost Centre'; What is this meant to be? Because when you use this: IF(ATTRS(vCC,vCCElements,vAttribute)@='Other'); You are asking is the attribute for an element called !006 Main - Cost Centre equal to other. I suspect you really want to ask what the attribute for the el...
by MarenC
Fri Mar 15, 2024 2:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5122

Re: Ultimate Long TM1 quiz

Code: Select all

they may have set the ProportionSpreadToZeroCells cfg setting to False
Am I the only one who has made this the law!
by MarenC
Tue Mar 12, 2024 2:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAfE Issue on Win 11
Replies: 7
Views: 275

Re: PAfE Issue on Win 11

Hi, Didn't the way PAX was installed completely change after PAW version 65, and don't IBM recommend that PAX should not be out of sync with PAW, something like within 3 versions? Doesn't explain the reason why it works on windows 10 I know but I would be interested to see what IBM respond with. Maren
by MarenC
Mon Mar 04, 2024 11:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5122

Re: Ultimate Long TM1 quiz

Hi, Slice exports the data in the view to excel and allows for write back to the view/cube (via DBRW formulas). Note that the values will be the current values and not the values at the time of the slice. Snapshot exports the data in the view to excel as static values. Need excel for snapshots. Need...
by MarenC
Tue Feb 27, 2024 4:26 pm
Forum: Useful code, tips and tricks
Topic: An Introduction to MDX views
Replies: 2
Views: 240

Re: An Introduction to MDX views

Hi George,

I don't know how much they pay you but it isn't enough! Great work.

Maren
by MarenC
Tue Feb 27, 2024 4:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5122

Re: Ultimate Long TM1 quiz

Hi George,

I was definitely not aware of that feature, many thanks! You obviously keep your hear well to the ground to dig up all this stuff.

I doubt that is what the Quiz Master had in mind though as way of a solution...

Maren
by MarenC
Tue Feb 27, 2024 7:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5122

Re: Ultimate Long TM1 quiz

Hi, Who said anything about poor admins wading through the data :D There are a few ways to automate using TI etc but I was thinking to myself that I would never rely on aliases if I were designing this and would have a code id, and then I noticed in your last screenshot that there is a code id of so...
by MarenC
Fri Feb 23, 2024 4:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5122

Re: Ultimate Long TM1 quiz

Hi,

It is Friday so bear with me but I would have said either change the Job Type in the Employee cube to be the updated alias or use one of the aliases to store the old job type value.

Maren
by MarenC
Thu Feb 22, 2024 8:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5122

Re: Ultimate Long TM1 quiz

Hi,

Not from me but I am eagerly awaiting the answer!

Maren
by MarenC
Wed Feb 21, 2024 4:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ELPAR in Rule
Replies: 2
Views: 172

ELPAR in Rule

Hi, I am creating some security rule which says if the parent is 'WRITE' then make the child 'WRITE' too. I am using the following: []=S: IF( ELLEV('Cost Centre', !Cost Centre) = 0 & DB('}ElementSecurity_Cost Centre', ELPAR('Cost Centre', !Cost Centre,1),!}Groups) @= 'WRITE', 'WRITE', 'NONE'); T...
by MarenC
Wed Feb 21, 2024 8:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Element Order in Dimension, PAW vs PAfE
Replies: 7
Views: 479

Re: Element Order in Dimension, PAW vs PAfE

Hi,

I must admit I thought the ElementName/Index worked in PAX but you can ascii with a TI, was just wondering if it was hierarchy related.

Maren
by MarenC
Tue Feb 20, 2024 5:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Subset TI Data Source Alias
Replies: 4
Views: 734

Re: Dimension Subset TI Data Source Alias

Hi Lotsaram,

thanks for the confirmation of the feature!

Maren
by MarenC
Tue Feb 20, 2024 5:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Element Order in Dimension, PAW vs PAfE
Replies: 7
Views: 479

Re: Element Order in Dimension, PAW vs PAfE

Hi,

Just out of interest,

What does Dimix return?
What does ElementName return?
What does ElementIndex return?

Maren
by MarenC
Wed Feb 14, 2024 2:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Subset TI Data Source Alias
Replies: 4
Views: 734

Re: Dimension Subset TI Data Source Alias

Hi Wim,

thanks for the confirmation,

Yes I had come to the conclusion that using the element attributes cube as the source or looping over the elements to get the alias were the alternatives.

Maren
by MarenC
Wed Feb 14, 2024 12:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Subset TI Data Source Alias
Replies: 4
Views: 734

Dimension Subset TI Data Source Alias

Hi, When I use a Dimension Subset as a data source in a TI process the preview does not show the alias name even though the subset has the alias set. And when reading the data it doesn't show the alias either. Is it a limitation that aliases do not show when the data source is Dimension Subset? Maren
by MarenC
Mon Feb 12, 2024 10:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5122

Re: Ultimate Long TM1 quiz

Hi, I am assuming the Employee analysis dimension order is the same as the Employee Cube order. ['Current Salary']=N: If( DB( 'Employee', !Organization, !EmployeeList, !Year, !Version, 'Job Type' ) @= ATTRS( 'JobType', !JobType, 'Alias' ), DB('Employee', !Organization, !EmployeeList, !Year, !Version...