TM1 Forum

What does the @ symbol do as placed in format parameter for TEXT function?. It's part of the syntax for custom number formats - in this case, it converts a number to a string. It's a bit like sticking an ' in front a number. For your problem, it is just saying compare text with text, not numbers wi...

This might work: That way its apples and apples. Note there's no need to quote the TRUE and FALSE outcomes otherwise you will be casting strings back to booleans.

There was nothing wrong with the upside down A for the All subset, or the Zorro mask for aliases

... ['Element X'] = IF( ['Element A'] <> 0, ['Element B'], 0 ); ... Is it necessary for 'Element X' to evaluate to 0 if the condition is FALSE? Had you considered using STET instead? I realise that the rule presented is probably not a real-life example but the consultant's substitute code arrives a...

Just from a read of it, it's not totally intuitive, but it reads that the 'SL Periods' dimension has an attribute 'Ref' which should contain a value that matches another element in the 'SL Periods' dimension'. It's common for time dimensions to have attributes that refer to elements within the dimen...

1. We found that overtime, the longer the services ran, the less competent they were. We found that the services became slower, less efficent and we noticed that restarting them helped these issues go away. There is also no harm in restarting them nightly, we restart them during the early hours of ...

Historically - no doubt. However, TM1 is being used more and more as an Enterprise tool and part of larger suites of applications TM1 was quite widely used for resource planning prior to the paradigm shift to 'enterprise', and this was always a concern back then (salary/ bonus confidentiality etc),...

Hey QML, it's a good clarification, no doubt. But, it's unusual for a user to get READ access on a TI that's updating security, don't you think?

On a slight tangent, did you ever work on a model where someone was actually assigned into the SecurityAdmin group?

The only difference with our issue is that we have PersistantFeeders on. We run a nightly restart on all of our services but each Sunday we delete all of our .FEEDER files. This raises some questions: 1. Why do you run a nightly restart on the services? 2. Why do you delete the .feeder files on a S...

Earlier in the thread you stated that the cube used as a data source is DU_SERVICES_REPORT. But you're also posting code that is writing to SSM_EXPENSES_REPORTING...

Make sure that the variables map to DU_SERVICES_REPORT and not to SSM_EXPENSES_REPORTING!

Trevor, it's a useful suggestion, but perhaps you missed a subtlety in the OPs question - he was questioning if a users cube security permissions were taken into account by a TI process - the answer being that TI's always run with admin privilege. Running the TI via TM1RunTI.exe doesn't change this....

It smells like there's something else wrong with your process beyond just some difficulty your having with the coding. What is "002587 - Turn _Dep" - is it an element in one of the dimensions in the cube used as a data source? If so, it seems that there's a mismatch between your data sourc...

Firstly,I do have subset of numeric elements and assigned to source view: Prolog: #Defining Source Cube,View and Dimension#   SCub='DU_SERVICES_REPORT';  SDim='sa_period';  SVw='Source View'; #Making sure Source View exists for the Process##  IF(VIEWEXISTS(SCub,SVw)=0);       VIEWCREATE(SCub,SVw); ...

After the migration if we have to test the functionality of existing TM1 applications, please advice on what all the areas to test. Are there any potential risks in particular area? Can you provide a list of things you have already written up to test? More people will make suggestions if they can s...

You need an attribute on the Month dimension that gives the prior month (e.g. Jan is the prior month to Feb) and also a consolidation for all the months which I called 'Total' in the example below. The code might look like this: SKIPCHECK; ['Calc Price', 'Jan'] = N: ['Cost Price', 'Jan']; ['Calc Pri...

Yes it does have few string elements defined in them OK, so that's why this error occurs: Error: Meta Data procedure line (0): Cannot convert field number 8, value "SLT" to a real number If you only want to process the numbers in the cube, then you have to build a subset of just the measu...

Right - so does the sa_period dimension have any string measures?

See here

What is the data source of the process? Is it a view of the DU_SERVICES_REPORT cube?

Create a subset called something like 'N level elements of Consol' and apply an MDX expression to it: Then in the worksheet, you can refer to the elements in the subset using the SUBNM formula.

You simply clarify the dimension name using this syntax: