TM1 Forum

Hi Currently for opening a tm1 web worksheet in report studio am using an iframe script. Please follow below code. <iframe src="http://tm1lab.us.hsbc/TM1Web/TM1WebMain.aspx?AdminHost=tm1lab.us.hsbc&TM1Server=narm_risk_dashboard&action=OpenObject&type=Websheet&value=Applications/...

Hi, Is there any way we can pass the parameters from report studio to tm1 web to retrieve particular view(filter) according to the parameter selected. We are actually using iframe jaava script to open a particular worksheet through report studio. We had to create 30 different worksheet to open that ...

Thank you. Gurus

Will do a VBA for that.

hi, I have a worksheets with a chart in it. I have formatted the chart according to the user req and published as an application. When i open it in tm1 web format gets change and it looks like a mess. Is there any parameter to be changed to retain the format used in worksheets?? (TM1 version 9.5.1)....

Hi All I have 50 worksheets as an application in one TM1(dev) server. We want to migrate to different(uat) server but admin wanted to change the instance name. Due to this instance change we have to change all the worksheets pointing to that instance name(Subnm formulae, View formulae). Is there any...

Hi All I have a requirement, where user wants a blog kinda interface for discussing on a situation. Like 1st user writes a description of the situation, and the next user writes a comment(by clicking on reply button) and comments goes on. This should capture the user and date time automatically. Thi...

Thank you for the comments. I will research on vba email feature and get it done.

Hi,

I have a requirement where user enters data into the cubes through worksheets and clicks on a button which fires an email to his manager to view what did he just enter. Is there anyway we can accomplish this scenario.

Thanks
Daya

Got it...Thanks All....

@Tomok

I tried using Continue, but dint make difference.

@ Michel

I tried using 'Write', but same error repeating.

Hi Martin

I tried to write a rule in Control cube But am getting an error. Rule: Error:

Hi I have a req where in the below cube, user has to enter comment in 'edit comment' field. When ever higher official likes the comment, he has to enter 'Y' in Approve field so that comment from edit comment will be copied to Comment filed. Q.JPG I used the foll rule ['Comment']=S:(IF(DB('Test Comme...

Hello Wim

Thankyou
Its working!!

Hello Gurus

I have a requirement where user enters a comment in xl application through tm1 web. Is there any wy that i can restrict max characters. User cannot be able to write the comment which is more than 300 characters. Please help me with ideas.

Thanks
Daya

Hi

I have to get the highest index value element into left side of the rule dynamically. Please share ur idea on this.
I tried to do this but it returns error
Thanks
Daya

Hi Gurus I have a requirement where a cube has 4 dims and one of the dimension is Date dimension. Date dimension consists of only one element which is last day date of given month. This dimension will be recreated when ever new date enters into the data base(So that date dim contains only updated da...

thank you so much. ill refer the guide..

Hi, I have a requirement where user want to audit trail the changes made to 2 elements in worksheet app. They want to just know who did it and at what time. How is this possible?, i am able to get the most resent change using tm1user function. They want history of at-least last 4 changes. Please hel...