TM1 Forum

Hi Steve,

The objects were deleted directly from Architect.

Hi all, I am in the process of moving from 10.1.1 to PA 2.0 (from one server to another). Copying the entire model's folder over. Strangely, deleted objects (application folders, chores and even cubes) are reappearing once set up on the new server. I can just re-delete these but is there anyway to n...

100% correct!

PASS was needed as a separate installation. Downloaded from IBM Passport.

Thank you for your response.

Hi all, I've done an installation of PA 2.0.9.5 - Architect, Perspectives are both working on a brand new server computer. However, I get a "HTTP Error 404.0 - Not Found" error when trying to access TM1 Web. In IBM Cognos TM1 Applications Configuration; I get "The client URI could not...

Thank you Alan, much appreciated.

Hello all,

Currently using Cognos 10.1.1 and ready to install PA 2.0.9.5.

Is it possible to simply upgrade to PA or does one have to remove version 10 and do a fresh install? (Obviously the former would make my life so much easier).

Thanks in advance!

Hi all, Problem averted. There was a single cell in the tab that Perspectives did not like when converting to a snapshot. I had placed the following (below) in a cell (with no '=' sign) for reference when building my report. TM1RptFilter(ReportView,Tuple,FilterFunction,FilterValue,SortOrder) Removin...

Good day all, Our users are printing reports via Perspectives. All reports print fine, except for one report and more specifically one tab. If this tab is removed, the report will print perfectly. The users are printing as a snapshot to Excel. When trying to print the offending tab, the progress bar...

Hi all,

Hiding behind everything was a popup asking to update Excel links.

Choosing "update" or "don't update" began the print job.

Solution: Remove all unnecessary links in the wookbook.

Hi All,

When I try print my reports via Perspectives, the progress bar displays and just hangs for eternity.

Has anyone else encountered this problem before?

Thanks all.

The view below where it hangs:

Hi all, I'm getting an error when I run my VBA code in Excel: "Runtime error 3706: Provider cannot be found. It may not be properly installed". Set cn = CreateObject("adodb.connection") strConnection = "Provider=TM1OLAP;Location=computername;Data Source=servername;" cn....

Thanks for the reply. I did remember to log back in

I have restarted Excel, restarted my computer. Let me try this "m_Clear" function.

Hi all, I created an active form. If I shut down and restart the server from which I created the active form, the form no longer works. I tried F9, Alt-F9, Shift-F9, Rebuild, change all DBRW to DBR, and tried saving the excel document in different formats. All the formula still remain on the active ...

Thanks all, works fantastically.

Expand() is what I was looking for. Let me try it out.

Thanks!

They are variable names. There's s lot of them. I can copy/paste the code for all of them in the metadata tab, but that just seems unnecessary.

Hi Catherine,

I'm referencing Department_1, Department_2, etc. directly as variables.

Enclosing them in inverted commas populates the dimension with the text within. I'm after the variables values. So I cannot use the inverted commas.

Thanks.

Hi all, I have a large number of elements I want to add to a dimension in TI, i.e. DimensionElementInsert('Department','',Department_1,'S'); DimensionElementInsert('Department','',Department_2,'S'); DimensionElementInsert('Department','',Department_3,'S'); DimensionElementInsert('Department','',Depa...

Thanks very much.

Application.Run "TWEVENTER1" works fantastically.

Hi to all, I have created a slice, the usual set-up followed in Excel. To change the specific dimension, you double-click on the element (with the SUBNM formula), and the dimension window pops up. Is it possible in VBA to make the dimension window open without a double-click, but with a single click...