TM1 Forum

For those without TM1 Tools, if you select the formula, click into the fx bar in Excel, doubleclick on the argument, and press F9, it will change the cell reference into the contained value. Hi Christopher, The values are corrent inthe inputsheet and the value in the cube is not matching in the inp...

Thanks Guys it worked when I add the server name .. now I have a problem ... one line with the DBSS is correct in the cube and rest are all in correct when it writes in the cube ... excel 2003 .. I tried it from tm1 9.4.1 and 9.5.1 .. all have the same outcome that most of the numbers are incorrect...

Thanks Guys it worked when I add the server name .. now I have a problem ... one line with the DBSS is correct in the cube and rest are all in correct when it writes in the cube ... excel 2003 .. I tried it from tm1 9.4.1 and 9.5.1 .. all have the same outcome that most of the numbers are incorrect ...

a simple excel websheet is successul ... can't seem to see why the other ones are not be able to export ...

Hi BigG,

PDFcamp is running and browser is supported. I am able to export to excel and PDF via the cube in TM1 Web, however, I can't to export when access the websheets. In 9.4.1 has no problem only on 9.5.1 or 9.5.2.

Thanking you

Edward

BigG

Change the account that uses TM1 Excel Services to have admin rights and it worked ...

IBM wasn't able to fix the issue.

thanks

Managed to fix the issue. Changed the account in the services to have admin rights, however, I have new issue now with I am trying to export to excel or pdf. 2011-05-12 09:10:40,944 [6] ERROR Applix.TM1.Web.WebControls.Websheet.TM1WebFormula - An unexpected error occurred while evaluating TM1WebForm...

Hi Armand

The account used in the services (TM1 Excel Service) requires to have admin rights

Regards,

Ed

ignore the last post found the issue ...

BigDSter wrote:Right ignore that, managed to research a bit further and it was the adminhost port settings that needed to be unblocked. Working okay now ta

Hi David,

How did you managed to fix this as we are currently having issues.

Thanking you

Edward

help please =DBSS(B63,$D$50,pVersion,pYear,$D$56,pDivision,pBusinessUnit,pCostCategory,$A63,BK$61) result =DBSS("ukb0m","Global Overheads Budget Data","Budget V1","FY12","Annual","UK Business Parks","Developments","Travel and...

Hi, has anyone seen this error in VM Can someone please help me. I am currently installed tm1 9.5.1 on VM with win 2008 r2 64 bit. I managed to log on to the TM1 web and I was able to view the cubes. Once I click one of the websheets, I get an error Cannont conenct to TM1 ExcelSercives: No connectio...

Hi Ed, this error may appear if Excel reports were edited in two different versions (2003/2007). Restart service, create a new report in one version, publish it. Report should run fine. If you then run one of the corrupted ones then .. Puff! again for all available reports. Ciao, Marcus HI Marcus, ...

What it puzzles me is in our Production, we don't have any problem. Only on our VM machines that seems to have that problem. Production has 9.4.1 and also one of our test VM with the same specs also has an error Ironically 9.4 does not support Windows Server 2008 R2, but the 9.5.1 does. If you are ...

As you are using Windows Server 2008 R2, and as you get the error message "Cannot connect to TM1 ExcelService", what are the settings of the Windows Firewall for the TCP Port 4785 used by the Windows Service TM1ExcelService.exe ? For a detailed step-by-step description on how to configure...

BigG wrote:Hi, excel service may not like the local system account, set up a domain account and use this to start services?

Hi BigG,

excel service has a domain account already..

Thanking you

Ed

Hi Ed, this error may appear if Excel reports were edited in two different versions (2003/2007). Restart service, create a new report in one version, publish it. Report should run fine. If you then run one of the corrupted ones then .. Puff! again for all available reports. Ciao, Marcus HI Marcus, ...

Hi, Can someone please help me. I am currently installed tm1 9.5.1 on VM with win 2008 r2 64 bit. I managed to log on to the TM1 web and I was able to view the cubes. Once I click one of the websheets, I get an error Cannont conenct to TM1 ExcelSercives: No connection could be made because the targe...