TM1 Forum

Even I am facing same problem while accessing websheet.
when I access websheet through Perspective,it is working perfectly fine.
But if I try to view same websheet using Tm1web, one part of sheet shows 0 value.

The websheet has cube View with no date formats.

Hey Alan Thanks a lot for your valuable response.

But I dont want Macro to run on opening the Excel page.
Instead i want my macro to run at the click of Action Button.

Your further guidance will be appreciated.

Hey I am So Sorry.
I framed wrong Question.
Yeah I knew ExecuteCommand().
But how to call Macro from bat file?

I have found something like this:
C:\temp\test.txt /m="C:\temp\macro.mac"
But its not workin..
Any other alternative?

Even I was thinking of running a bat file. But I dont want Macro to run at load time since I want the macro to record the time when I click on Action Button(Action Button runs TI.) So I am thinking of Calling bat file from my TI. And that bat file will call macro. But then how to call bat file from ...

Hi All,
Is there any way to Call Macro from TI?

{Admin Note: Split from the topic "MACRO to Create a TI" since this thread has nothing to do with that topic.}

Hi All I have a Scenario: In Tm1 Perspectives I have 2 Action Buttons. When I click on Action Button,TIs run. When I click the Button, I want the Start Timestamp to be recorded in the next cell. I wrote Macros for recording Timestamp. But when I run MAcro for 2nd Action Button,all the Macros get ref...

I looked at using the ExecuteProcess function as I could pass in parameters, however it does not allow you to pass back a value, instead it only returns an error code. Anyone have any other ideas on how I could create a function or process that will accept parameters and return values? Otherwise I ...

Hi ALL

What does "Enable Cube Logging" checkbox in Maps of TI do?
What happens if we check it or uncheck it?
ANd where are the Cube Logs saved?

In short can anyone please explain about Cube Logging?

Hey thanks a tonnn RObin..

Hey thanks lotsaram for your reply. The portal is Sharepoint. Hmmm even I wondered why we were not using TM1 Web directly. But still this is the challenge for me...:P... And hey I found some ways to do the said task using APIs.But still exploring APIs part as this concept is entirely new for me. And...

Hi A less technical option that I have implemented which doesn't need any Java Script is to use the Excel HYPERLINK function. When the user goes into TM1 Web, you can configure their start up to be a Web Sheet (Its a setting in Web.Config) Hey paul, I dont want Web Sheet as my startup page. as I do...

Hey Paul... How about using TM1 API for the same? And I read almost all posts by you. But coudlnt find relevant information. Were you talking about http://www.tm1forum.com/viewtopic.php?f=3&t=6076&p=24898&hilit=range+#p24898 post? If no, can you please give the link or atleast some snaps...

Hi all,
i have gone through the Developer's Guide document.
In this doc, in 8th Chapter page no. 171 , it is written that we can call back TM1 Objects from Navigation Tree using Java Script.
Kindly refer the that doc and if any 1 has any idea as to how to do that,please revert back asap.
Thanks:)

hehheheh... yeah my mistake!!!:P Actually I am so much messed up with work...dnt even know what I am searchin for... :P We can hide View & Administration node by changing settings in Web.config. But can we hide Application Node in TM1 web's Navigation Tree? Actually I read that Applications node...

We can hide View & Application node by changing settings in Web.config.

But can we hide Application Node in TM1 web's Navigation Tree?

Hey Paul
Thanks a ton...

But can u please give link of your earlier post???

N 1 more question...Where is web.config located?

Hi All, Consider evrything in TM1 WEB I got the URL to access Cube View, Web Sheet and Navigation Tree. Do read Developer's Guide for the same.(Chapter 8). It goes like this: FOR CUBE VIEWS: http://domain name/tm1web/tm1webMain.aspx?action=OpenObject&type=CubeViewer&value=Cubename$$Viewname ...

I am really Sorry...
I posted it in hurry...

Hi All


Like, in Cognos we have "My Folders" concept where a user can view all the reports created by him.
Do we have such a functionality in TM1 Cognos where users can have all the views created by him in 1 folder ?

Please reply fast.
Its urgent:P

Hey Alan...Thanks I'l definitely go through the doc.
N Hey lotsaram Thanks for ur reply...
But
"all or nothing" means we cant get ONLY Views in Navigation tree right?