TM1 Forum

I have had this problem before as well. The most effective way to solve this for me was to turn on my automatic calculation in Excel prior to creating the active form. Also leave the calculation on automatic while modifying the report. I know it might take a bit longer but it has solved all my probl...

Thank you Niel,

The problem however is not with Excel Reports but rather with Cube Views. Any idea on how to change those?

Hello Everyone, I would like to know if anyone knows about a TI Prolog command that I can use to test if my ODBC Connection works before I start running the Process. The problem is that I clear out all my data in the Prolog section and then when the process continues it sometimes happen that the pro...

Hi All, Cognos Express 9.0 Mozilla Firefox 3.6.9 Is there any way you can align the values, to the left or right, in the cells when using a view in Web. We have a problem that if you have a string measure with a long typed value in, it alway aligns to the right of the cell. Is there a way to change ...

Hi All, Cognos Express 9.0 Mozilla Firefox 3.6.9 Excel 2007 When trying to slice or create a snapshot from Tm1Web nothing happens. The browser keeps saying "waiting for "hostname", where hostname is the name of my Tm1 Server. It still worked yesterday but from today no one can slice o...

Hi All,

Excel 2007
Cognos Express 9.0

I am trying to use Web as a user interface with Express but keep getting this error message when I try to open up the web portal. Has anyone got any ideas on why this error might occur and what can be done to rectify it?

Thank you!

Chris,

Try and insert a action button which Rebuilds the entire sheet.

Otherwise use a Excel button and link a macro to it in which the F9 button has been pressed.

Hi Everyone, Excel 2007 Tm1 9.4.1 FP3 At one client of mine they are using Cognos Express 9.0 FP001. I however when connecting to their server use Tm1 9.4.1 FP3 because as you all know, it would not make sense to have Express on my PC, having to work at lots of different clients. I have had lots of ...

Hi All! Cognos Express 9.0 with HF001 Using Perspectives 9.4.1 FP003 to access the CXMD Server Excel 2007 I am not able to create new groups in the CXMD Server. When I select Add New Group the screen in the attachment opens up and I can't add new groups or Clients for that matter. Does anyone have a...

The way to refresh an active forum is by using Alt-F9. No way around it, or you use the command in the TM1 toolbar.

Don't worry people! I found my mistake, silly me! Had 2 skipcheck commands in there! That's what you get from copying rules from one cube to another!

Hello People, Excel 2007 Tm1 9.4.1 FP3 Very strange thing is happening. I have one cube in a model for which none of it's rules work. The cube is entirely build up out of rules but none of them work. I have created the rule : []=1000; to test if the rules work, and still nothing happens! I can even ...

Thanks Andy!

What do mean by HF?

Hi All. Cognos Express 9.0 Excel 2007 When trying to log into Cognos Express I get the following error message. Has anyone any idea of what causes this error and how to fix it? I suspect the error gets caused by the fact that the IBM Cognos Express Service does not start, but how do I fix that? Than...

Thanks Michel.

Can't really use ELISANC because I first need to determine what the highest level parent is before I can test if the element is a child of it.

Allan, I have to differ with you there. This is the explanation form the reference guide. "ELPARN returns the number of parents of an element in a specified dimension. " "ELPARN('Model','Wagon 4WD') In the Model dimension, the element Wagon 4WD is a child of both Total Wagons and Tota...

Hey guys! Excel 2007 Tm1 9.4.1 FP003. I am trying to use the function ELPARN in a rule to determine the number of parents an element has. Well strangely enough it returns 1 for all elements except the highest level elements which it returns 0(which is correct). Has anyone seen this before? I have wo...

Allan,

You da man!!!!!!!!!!!!!!

This actually works! I owe you beer and lots of it!

Thanks alot!

Guys,

I have reinstalled Perspectives close to a hundred times now after i reinstalled my Excel!

Still no luck!

Hallo Guys and Gals I recently re-installed Excel 2007 and 2003 and is using Cognos TM1 9.4.1 FP002. When I open Perspectives in either one of the 2 Excel versions I get the following error message. "Object library invalid or contains references to object definitions that could not be found.&qu...