Search found 106 matches

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

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

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

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

Re: Consolidator Rule - Issue With Sandbox

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

Maren
by MarenC
Mon Jul 20, 2020 10:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders without Skipcheck
Replies: 7
Views: 3849

Re: Feeders without Skipcheck

Hi,

sorry to raise a very old post from the dead but I have 2 questions:

1) Is it still the case that feeding to another cube without skipcheck will result in no feeding?
2) Is there any scenario where having skipcheck off but feeders on makes any sense?

Maren
by MarenC
Fri Jul 17, 2020 2:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Assessing instance/Cube Efficiency
Replies: 7
Views: 272

Re: Assessing instance/Cube Efficiency

I am glad you agree Wim!
by MarenC
Fri Jul 17, 2020 1:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Assessing instance/Cube Efficiency
Replies: 7
Views: 272

Re: Assessing instance/Cube Efficiency

Hi Tomok, there are no consolidations in the view. In my process to count the number of populated cells by Cost Area I have the following code: Prolog: x=1; CubeClearData( 'zCountCube' ); Data: If ( CellIsUpdateable ('P&L', V1, V2, Version, V4, Dept, Cost Area, Measure, ) = 0); CellIncrementN(x, 'zC...
by MarenC
Fri Jul 17, 2020 8:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Assessing instance/Cube Efficiency
Replies: 7
Views: 272

Re: Assessing instance/Cube Efficiency

Thanks for the replies. Zero suppression was on, I created the data source in the TI itself and made sure the skip blanks was ticked. I did notice the elements were being double counted in some dimensions so hierarchy sorted some of those. The process is still a bit sticky but I did manage to get so...
by MarenC
Thu Jul 16, 2020 11:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Assessing instance/Cube Efficiency
Replies: 7
Views: 272

Assessing instance/Cube Efficiency

Hi, I am trying to get an handle on a tm1 instance with lots of rules. I basically want to ask the question, is the instance optimised (I don't think it is)? So I am running tests before getting into the specifics of the rules. One test I want to understand is: How many cells are populated by each m...
by MarenC
Tue Jul 14, 2020 12:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ElementParent rule in Hierarchies
Replies: 5
Views: 204

Re: ElementParent rule in Hierarchies

I was reading that you don't need the dimension qualifier in a DB.

I also read that you shouldn't use the pipe.

'By Bucket1': ElementParent('Products','By Bucket1',!Products,1)

Is this incorrect?

Maren
by MarenC
Mon Jul 13, 2020 12:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calculate minutes
Replies: 10
Views: 286

Re: Calculate minutes

Hi Orlando,

but how do you get the other serial number?

Maren
by MarenC
Mon Jul 13, 2020 11:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calculate minutes
Replies: 10
Views: 286

Re: Calculate minutes

Interesting, how do you get the serial date to the decimal place in the rule?

Do you have a lookup table for this?

Maren
by MarenC
Thu Jul 09, 2020 11:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule Efficiency
Replies: 4
Views: 181

Re: Rule Efficiency

thankyou Wim. (and what errors :D )

Just a follow up, how would you feed this statement. I was thinking I had 2 options, either take out the N: and make the rule apply to C and N level
or

Have 3 feed lines one for each period, so one current period, 2 next period

Maren
by MarenC
Thu Jul 09, 2020 9:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule Efficiency
Replies: 4
Views: 181

Rule Efficiency

Hi, Which of the following rules is the more efficient or in the following case is there no real material difference? : ['Forecast', 'Annual Revenue'] = N: (DB('Revenue', !Version, !Period, !Dept , 'Total Revenue') + DB('Revenue', !Version, ATTRS('Period', !Period, 'Period n-1'), !Dept, 'Total Reven...
by MarenC
Thu Jul 09, 2020 9:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }StatsByRule
Replies: 4
Views: 1172

Re: }StatsByRule

thanks. I have tested this a little and Total Count doesn't make much sense because I created a rule on a cube and then created a view. And Total Count kept changing, so it would be 41, then 42 and then 78 and I didn't, as far as I know, fundamentally change the number of cells the rule would apply ...
by MarenC
Wed Jul 08, 2020 12:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }StatsByRule
Replies: 4
Views: 1172

Re: }StatsByRule

Hi, I have been looking into the StatsbyRule facility and have a couple of questions: Does Total Run Count effectively mean the number of cells that the rule applies to? There are a number of guidelines in the following guide: https://code.cubewise.com/blog/7-tips-to-writing-faster-ibm-tm1-and-plann...
by MarenC
Wed Jul 01, 2020 10:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: re-order dimension result
Replies: 8
Views: 2973

Re: re-order dimension result

Hi,

I have been checking our dimension orders and notice that I can gain -20, -50 on some cubes.

But some of the cubes are quite small, so 100mb and another is 1gb.

So my question is, when does dimension reordering become worth it based on the size of the cube?

Maren
by MarenC
Thu Jun 25, 2020 1:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchy Functions
Replies: 3
Views: 360

Re: Hierarchy Functions

thanks ascheevel.

So if hierarchy creation is enabled then it is probably better to use the hierarchy functions even for the default/base hierarchy, I guess my question was if hierarchy creation is enabled does this make the dimension functions moribund?

Maren
by MarenC
Wed Jun 24, 2020 10:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchy Functions
Replies: 3
Views: 360

Hierarchy Functions

Hi,

If hierarchy creation is enabled should I always use Hierarchy functions instead of dimension functions?

So HierarchyElementInsert instead of DimensionElementInsert, HierarchyElementComponentAdd instead of DimensionElementComponentAdd etc?

Maren