Search found 341 matches

by MarenC
Fri Mar 15, 2024 2:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 45
Views: 4807

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: 228

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: 45
Views: 4807

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: 220

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: 45
Views: 4807

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: 45
Views: 4807

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: 45
Views: 4807

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: 45
Views: 4807

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: 165

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: 472

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: 726

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: 472

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: 726

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: 726

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: 45
Views: 4807

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...
by MarenC
Fri Feb 09, 2024 7:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IF Statement Evaluation in Rules
Replies: 4
Views: 790

Re: IF Statement Evaluation in Rules

Hi,

In some languages I believe the double operator, e.g. && or %%, means only evaluate where necessary, whereas a single means evaluate all results.

As for TM1, I suspect ykud is correct.

Maren
by MarenC
Thu Feb 01, 2024 12:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders Not firing when using flag value
Replies: 0
Views: 435

Feeders Not firing when using flag value

Hi All, Just wondered if I had missed something fundamental with feeders or whether I am seeing some kind of bug. I have created a reconciliation cube which gets its data from 2 other cubes, Actuals Cube and Forecast Cube. I am using a flag to feed the cells in the reconciliation cube, this flag get...
by MarenC
Wed Jan 31, 2024 5:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Can you use ConsolidatedCountUnique with criteria
Replies: 2
Views: 343

Re: Can you use ConsolidatedCountUnique with criteria

Hi, I thought I could use ConsolidateCountUNique and add something to only count the 1s but right now it is doing what it is supposed to and counting all 4. I assume you meant to say not doing what it is supposed to do? Anyhows I seem to get this to work, it would therefore help if you showed us the...
by MarenC
Tue Jan 09, 2024 1:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 45
Views: 4807

Re: Ultimate Long TM1 quiz

While this one was pretty straightforward, I do hope we will be getting the answers to these questions at some point! :D
by MarenC
Fri Jan 05, 2024 5:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW MDX Query
Replies: 3
Views: 1491

Re: PAW MDX Query

Hi,

Don't you need an ALL before the recursive, so:

, ALL, RECURSIVE)

Maren