TM1 Forum

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...

Excellent, thanks for the advice.

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

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

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

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...

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 ...

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...

Hi,

can anyone confirm if the httpRuntime executionTimeout is relevant to Planning Analytics and if not what governs this now?

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

Hi Wim,

thanks for taking the time to respond to this,

Here are my screen prints:

First with the rule as you have it:
Then with undefvals in the rule:
Then with Undefvals commented out:
regards, Maren

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

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!

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...

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...

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

Many thanks for the reply and yes I did mean Action Button!

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...