Search found 346 matches
- 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)!
- 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...
- 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...
- 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
Thank you for taking the time to update this case.
Maren
- 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...
- 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
- 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
- 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...
- 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
I don't know how much they pay you but it isn't enough! Great work.
Maren
- 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
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
- 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...
- 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
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
- 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
Not from me but I am eagerly awaiting the answer!
Maren
- 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...
- 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
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
- 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
thanks for the confirmation of the feature!
Maren
- 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
Just out of interest,
What does Dimix return?
What does ElementName return?
What does ElementIndex return?
Maren
- 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
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
- 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
- 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...