Search found 20 matches

by MarenC
Fri Aug 16, 2019 2:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule or Process?
Replies: 5
Views: 94

Re: Rule or Process?

Hi,

The data will be loaded by TI but can be modified by the end user.

The reason I was reluctant to add in another dimension was because if the user wanted to modify the values this new dimension for bandings would add an extra level of granularity for them to deal with.

Maren
by MarenC
Fri Aug 16, 2019 1:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule or Process?
Replies: 5
Views: 94

Re: Rule or Process?

Hi PavoGa,

that did cross my mind but that would require the data getting populated via a data load, so it would be a process not a rule? Because if I added in Bandings as a dimension it would mean I would need to add a particular sale to a particular banding, wouldn't it?

Maren
by MarenC
Fri Aug 16, 2019 10:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule or Process?
Replies: 5
Views: 94

Rule or Process?

Hi, I have a cube with four dimensions, lets call them Dim1 Dim2 Dim3 Dim4 - Measure dimension In dim 4 there is a measure called DaysTaken I want to be able to create bandings for DaysTaken, so the following bandings: Band1 = DaysTaken between 1 and 4 Band2 = DaysTaken between 5 and 15 Band3 = Days...
by MarenC
Wed Aug 14, 2019 12:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy cub files
Replies: 4
Views: 370

Re: Copy cub files

Excellent, thanks for the advice.
by MarenC
Tue Aug 13, 2019 3:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy cub files
Replies: 4
Views: 370

Copy cub files

Hi,

is there any issue with copying .cub files to another folder while the tm1 instance is still running. Or should the instance be stopped first?

Maren
by MarenC
Wed Aug 07, 2019 11:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Stats by Cube
Replies: 5
Views: 1526

Re: Stats by Cube

Hi,

I have checked our model and the grand total for Memory Used for Input Data / Number of Populated Numeric Cells = 112.4

Does this indicate an issue and if so what might that issue be related to?

Just trying to understand what this data is telling me

regards, Maren
by MarenC
Mon Aug 05, 2019 4:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX to return elements that exists in another dimension, but as an alias
Replies: 14
Views: 318

Re: MDX to return elements that exists in another dimension, but as an alias

Thanks for the advice, especially the tip on the generate function, which seems more than a tip and more something fundamental!

But thanks anyway.

Maren
by MarenC
Fri Aug 02, 2019 3:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX to return elements that exists in another dimension, but as an alias
Replies: 14
Views: 318

Re: MDX to return elements that exists in another dimension, but as an alias

Hi, I had read your mdx code as it needed to be put in dim2, I didn't realise that mdx could be put in dim1 (I assumed because the first part of the code referenced dim2 it had to be put in dim2). I guess I have some way to go to reach your mdx knowledge! But as I said, I did try a variation of your...
by MarenC
Fri Aug 02, 2019 1:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX to return elements that exists in another dimension, but as an alias
Replies: 14
Views: 318

Re: MDX to return elements that exists in another dimension, but as an alias

Thanks for the replies. I am only needing this for debugging, so didn't want to go down the TI or new attribute route. I can just snapshot to excel and do lookups but thought MDX might be useful too. PavoGa - in your mdx the attribute is in the same dimension as where the mdx is, but in my case the ...
by MarenC
Fri Aug 02, 2019 10:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX to return elements that exists in another dimension, but as an alias
Replies: 14
Views: 318

MDX to return elements that exists in another dimension, but as an alias

Hi, I was wondering if it's possible using mdx to return elements in one dimension that exists as an alias in another dimension? I know I can use other techniques for this but wanted to know if it could be done with MDX. So for example Dimension A has elements El1 and El2 and Dimension B has element...
by MarenC
Wed Jul 31, 2019 8:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Timeout
Replies: 4
Views: 1281

Re: Timeout

Hi,

can anyone confirm if the httpRuntime executionTimeout is relevant to Planning Analytics and if not what governs this now?
by MarenC
Thu Jul 04, 2019 10:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Flag value in consolidatedavg function
Replies: 8
Views: 1216

Re: Flag value in consolidatedavg function

Hi Wim,

That is what I did, if you look at my first screen print in the comment above I first had the rule just as you had it, i.e. without undefvals.

The second and third images then show what happens when I use undefvals

regards, Maren
by MarenC
Wed Jul 03, 2019 5:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Flag value in consolidatedavg function
Replies: 8
Views: 1216

Re: Flag value in consolidatedavg function

Hi Wim,

thanks for taking the time to respond to this,

Here are my screen prints:

First with the rule as you have it:
TestAVG.PNG
TestAVG.PNG (34.58 KiB) Viewed 180 times
Then with undefvals in the rule:
TestAVG_Undefvals.PNG
TestAVG_Undefvals.PNG (35.41 KiB) Viewed 180 times
Then with Undefvals commented out:
TestAVG_CommUndef.PNG
TestAVG_CommUndef.PNG (35.99 KiB) Viewed 180 times
regards, Maren
by MarenC
Wed Jul 03, 2019 1:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: difference between prolog, metadata, data, epilog
Replies: 13
Views: 9355

Re: difference between prolog, metadata, data, epilog

Hi,

ok thanks for the advice, something must have got lost in translation somewhere along the line!

Incidentally I didn't bring up the guides, Orlando did!

regards, Maren
by MarenC
Wed Jul 03, 2019 11:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: difference between prolog, metadata, data, epilog
Replies: 13
Views: 9355

Re: difference between prolog, metadata, data, epilog

Hi Orlando,

How do you know that I haven't read the documentation? Maybe I missed the bit about when you needed to split up processes!

But I take it you don't know and hopefully someone else can provide something useful!
by MarenC
Wed Jul 03, 2019 9:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: difference between prolog, metadata, data, epilog
Replies: 13
Views: 9355

Re: difference between prolog, metadata, data, epilog

Hi, I was told that in some situations processes needed to be split up because certain things created in one process would not be recognised until that process had fully run and therefore a second process would be required to fully complete the tasks. For example dimension builds. Is there any defin...
by MarenC
Sat Jun 29, 2019 12:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Flag value in consolidatedavg function
Replies: 8
Views: 1216

Re: Flag value in consolidatedavg function

Hi, Looked for help on this and this topic seemed the most relevant. In Planning Analytics 2.06, I created a simple cube with 2 dimensions and used the following code in a rule (the only rule in the cube): ['ELAvg']=N: ConsolidatedAvg( 1, 'Cube', 'AreaA', 'ConsolElement'); Under ConsolElement I have...
by MarenC
Thu Jun 27, 2019 3:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Operators in TI : SQL IN equivalent
Replies: 7
Views: 228

Re: Operators in TI : SQL IN equivalent

Hi,

am I being a bit slow here, but isn't the point to reverse the parameter? I.e. it should be SCAN(sCode, 'ABC') > 0.

Scan('ABC', sCode) does not make much sense to me?

regards, Maren
by MarenC
Thu Jun 27, 2019 9:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Go to another worksheet Match title elements
Replies: 2
Views: 188

Re: Go to another worksheet Match title elements

Many thanks for the reply and yes I did mean Action Button!
by MarenC
Wed Jun 26, 2019 1:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Go to another worksheet Match title elements
Replies: 2
Views: 188

Go to another worksheet Match title elements

Hi experts, I am puzzled by an active form I am looking at. There is a process on the active form which goes to another worksheet, the target worksheet is in the same workbook as the source worksheet. The process uses Match Title Elements and when I look at the Advanced options I can see that it say...