TM1 Forum

Thank you declanr for taking time to reply my post. What it appears to me is - Something is going wrong at TM1 software Picklist functionality on web. Though I have changed all DBRW to DBR. I tried designing a very simple .xlsx doc with cell input TM1 Picklist instead of excel 'list' option but coul...

No the sheet has DBRW functions, but the cells D15, E15, F15.. are getting populated by DIMNM formula to get item name from the dimension.

The formula in 1st column at excel is =DBRW("ServerName:lookup_CubeName",D$15,"New Forecast Date") In 2nd column at excel is =DBRW("ServerName:lookup_CubeName",E$15,"New Forecast Date") In 3rd column at excel is =DBRW("ServerName:lookup_CubeName",F$1...

Hi Guys, I have designed an application in active form and it's hosted over TM1 Web. Everything is OK at active form level and works fine. But I notice that the pick-list is not working appropriately at TM1 web to input value 'by selection' into the desired cell. The error what I get on selecting th...

Hi guys,

Do we have any TM1 function like 'VUSLICE' (creates a slice worksheet) to get an active form worksheet ?

Seeking suggestion on how to get an active form created at worksheet using macros ?

Thanks,

Hi,
I'm using Microsoft excel 2000 and cognos TM1 9.0 SP3. I'm not seeing Action Button over there when I use TM1 Perspective under TM1 tab.
Can any one help me if I can have an action button created over there ?

Yup, got your point.

Thanks a lot.

Hi Team, There is a requirement to archive cube data - older than 5 years. Presently X.cub file size is 3.0 GB. Seeking for a better advise to achieve this. The cube X has a dimension 'Week', which has elements like week1, week2, week3 ...week52. and elements rolls up to 'All weeks'. My requirement ...