TM1 Forum

Hi, I'm not sure if this is possible, from all the research i did it seems like this is not possible but i'm hoping someone else in this forum has a workaround for this:) We have built many websheets and published them in different application folders. We have users for multiple languages ( english/...

I tried the same thing last night after i posted my question and it worked!!! I'm happy someone else has experienced this issue and has used this workaround. This was working fine in 10.2.0 but we upgraded this week to 10.2.2 and after that we started experiencing this issue. I am also having issues...

Hi, This is driving me crazy. I am using TM1 10.2.2, and I have built some websheets for data entry and I have also some action buttons that execute TI processes on the backend to recalculate / move data to other cubes. In my TIs, I have written code to check for parameter values and other validatio...

Thanks guys, I have one more question. In our dimensions we have lots of subsets, some of them static, some of them dynamic ( by dynamic I don't mean MDX subsets, but MDX subsets converted to Static subsets and they get refreshed daily or on demand ) Is there any way to expose these subsets in BI? I...

so if we switch to IntegratedSecurityMode = 5, then we will have to rely on Cognos BI Groups, right? So we cannot automate the group creation in TM1. That sucks since we have an automated security maintenance process, our TM1 admin enters users and groups in an external access database and them we h...

Thanks for the reply, So you're telling me that if we want to use Cognos BI to create reports using a TM1 Cube as data source, we have to go to "IntegratedSecurityMode = 5", right? This is not ideal, since for so many reasons we want to keep at least groups in TM1, and probably we can buil...

Hi, We have a model which is built in prior versions of TM1, now we upgraded to TM1 10.2, and we still use the IntegratedSecurityMode = 2. We have many users and groups in TM1, and each user has limited access ( depending on their role / and location ). So we have }ELementSecurity and }CellSecurity ...

Thank you lotsaram, Can you please elaborate more in this one? In my action button properties, i have selected "Automatically Recalculate Sheet" under Calculate Tab, and also I have selected the same under Process tab / Options ( just next to where you specify the TI process name) . I dont...

Hi, I am having issues with TM1 10.2, I have a websheet with an active form to capture data entry. Also I have an Action Button which runs a TI to copy/recalculate into another cube. The issue is that the cells that have been changed stay in "green" and they are not saved in the cube, so m...

Why do you have to do it 12 times? Just hide the DBRA formula in a row and apply one set of conditional formatting in the active form formatting area that applies to the 12 columns. Thanks. That's what i was trying to do, define the conditional formatting rule in the whole range ( with 12 cells) , ...

Hi, I need to build an active form for users to enter Forecast data into our Forcasting cube. We populate the forecasting cube with Actual Data from all Periods Prior to Current Period, and these columns will be read only. For the rest of the Year, we want users to modify the data and they want all ...

Hi guys, What is the best practice you follow for the server name in websheets. Our dev instance name is different from testing environment and production environment, so any time we have to migrate a websheet we have to open it and change the cell value that contains the TM1 server name. This is an...