Display message in TM1 web

[krithika331]

Hi,

I have a requirement to display the custom message in TM1 web, when the database load or Cube load is happening. We are capturing the load status column from database into to a look up cube. The first web sheet has navigation to other sheet. But can we run a TI process from an action button which also navigates to the worksheet? It means run the process, display custom message pop up and then go to other worksheet. This custom message will be populated from a lookup cube. I have tried the approach and it is working in perspectives but it is not working in the TM1web.

OR is there any way of populating a scrolling message dynamically in the TM1 Web interface based on the database load.

And what exactly is the difference between Automatically recalculate sheet and Rebuild sheet in action button? When should we use each one.

TM1 Version 10.1.1

Thanks in advance

[lotsaram]

I don't know what you mean by "scrolling message" but you can meet this requirement in quite a simple crude way by having a DBR to the "message status cube" display in a text box on the user homepage which they land on when they log into Tm1Web.

You could also have a small status placeholder in the header of each any every websheet if you wanted to.

[paulsimon]

Hi

If you want a message to display when the user clicks the button to run the process, you can tick the box for a confirmation message in the Action Button and then override the standard confirmation message by entering a formula as = Range Name, and then you put the message you want to display in that Range Name eg by retrieving it from a cube with a DBR.

I haven't tried it with the confirmation message, but we use this approach with the Error Message and it works well.

Regards

Paul Simon

[krithika331]

Thanks for the information. Actually, I want to run the process first with one action button, get the status from a cube and then display the message, then navigate to the other worksheet from same action button. By putting the confirmation message, and when we click the button it is first displaying the message without running the process. By using a separate action, i am achieving the required message using DBR,but this wont have navigation to to other worksheet. Can we reuse the existing button and achieve the requirement.

[tomok]

TBy putting the confirmation message, and when we click the button it is first displaying the message without running the process.

Use the advice Paul gave you but don't put it in the confirmation box, put it in both the Successful box and Failure box. That way the process will run and will not display the message until the process finishes. If you have set the action button to run a process AND navigate to another sheet it will run the process, display the message and then go to the other workbook.

[krithika331]

I have tried the above option previously but it is still not working for Run a process, display the message , go to worksheet. When I click on the action button, it is directly navigating to the worksheet and not running the process in the TM1 web only. But in the TM1 Perspective sheet, it works. I have given process options using the DBR function for the success message and failure message and selected the Rebuild Sheet option everywhere. I still dont know if there are additional properties I am missing or anything in TI and not sure why TM1 web is having this issue. The other thing is when I remove the Go to worksheet, the process runs and gives message.

Thanks in advance

[paulsimon]

Hi

Not sure if it will work, but try the process completion message instead of the confirmation message

Paul

[krithika331]

I have tried the above option previously but it is still not working for Run a process, display the message , go to worksheet. When I click on the action button, it is directly navigating to the worksheet and not running the process in the TM1 web only. But in the TM1 Perspective sheet, it works. I have given process options using the DBR function for the success message and failure message and selected the Rebuild Sheet option everywhere.

The other thing is when I remove the Go to worksheet, the process runs and gives message.