TM1 Forum

Hi,

Within TM1 applications is it only Admin that can reset the state of all nodes to available ?

I have a couple of users who would like to be able to action this themselves.

Thanks in advance.

Thanks qml,

Versions are the same and admin host has been checked on all users these are also fine.

Hi, Up until Friday all was fine, Monday morning how ever my users are getting the following message when trying to access TM1 via Perspectives and Architect on one instance only. User does not have permission to browse the selected server. Although receiving this message it does actually connect th...

Hi, We use RDS for user access to TM1 Architect and perspectives (and other applications) TM1 has be configured to use CAM which work fine with a Thick client installed. Unfortunately via the Web apps we are constantly being asked to enter credentials. Our IT department have been round the house try...

I am in need of some urgent help PLEASE ! Earlier today something started to eat up the Memory on my server, I rebooted and all was fine for a short period and then again something start to run. I have never seen anything like this before. I have attached some screen prints in the hope that someone ...

Hi all, I have a issue that i am unable to resolve. I have a measure called value which is available for users to input data into. When I restarted the service a pick list is added to this element althought it is empty. There are no rules attached to the }elementattribute cube. As this happens only ...

As with all my postings a search was performed but found one post that had problem due to a column being inserted in the Active form. I found nothing to explain why it works in Excel but not in the web using Formulas that are not nested. My active form is split in two, the first 4 columns DBRW's loo...

Yes both the formulas are different and looking at their appropriate cubes and Dims.

As I say the formulas work perfectly in Excel just not working in Web (For one of the cubes)

Hope I have understood your Question ?

Lee

Hi,

I have published an active form that drags numbers from 2 different cubes.

This works fine in Excel but when accessing via the Web the values for one cube will not show but are fine for the other ??????

Any ideas why ?

Thanks

Lee

I am very open to suggestion on changing the Cube itself if you guys think there is a better way.

Thanks for your replies,

I have attached the cube and the rule I have put in place.

Obviously I need to put in some feeders now,

Will I need a feeder for each individual measures ?

Hi All, Is there a TM1 rule equivalent for Countif ? I have a cube that hold data for audits, so my string values are 'Pass', 'Fail' or in some cases 'N/A' I can obviously snapshot this to excel and write formulas but wondering if its possible to write a rule that will allow me to count the Pass, Fa...

Steve,

I did not know that.

Problem solved as it always is when posted on this forum.

Many thanks

Lee

Hi, I have set up an String element in a Calendar Dimension called Description. I would like users to type in ant text they need to but for some reason it will only accept Numbers. There are rules calculating different currencies, but I have made my Description element STET but still no good. Has an...

I am currently in the USA on business and Yesterday our TM1 server went down. I have managed to get it up and running again but I now have the following problems. I wonder if anyone can give me some guidence as I am under a very tight deadline. 1. Dynamic Tm1 spreadsheets are showing #value so canno...

Thank you all for your replies,

jstrygner you have hit the nail on the head.

Very embarrassed but I spent so much time looking at the Left bracket missing message I failed to spot that I was missing an s off Feeders.

This now saves and works.

Apologies but thanks a lot for the help.

The whole script.

SKIPCHECK;

['MABS US', 'Base Currency'] = N: [ 'USD' ]
+ [ 'MXN' ] \ db( 'ExchangeRates', 'MXN', !Version, !Period );


Feeder;


['USD']=>['Base Currency'];

['MXN']=>['Base Currency'];

Hi Christopher,

Thanks for the reply, This is the top of the rules and then I have a feeder underneath, very simple cube.

Im winding down for the weekend and being a bit thick when you say put the [] on the RHS of db formulas where exactly do you mean ?

Hi All, Being a global Company we load data into cube in various different currencies. I then like to use exchage rates to view totals in a base currency, in this case I want to convert Mexican Pesos to US dollar and add to the existing US Dollar total. Done this 100 times in other cubes but will no...

Alan, Thank you so much that has done the trick.

And you are quite right I have been talking about a TI process this whole time but failed to notice I used the word rule in my title

I blame the heat I am not used to it coming from the midlands.

thanks to all for your help.