Page 1 of 1
Weird behaviour of Picklist at TM1 websheet
Posted: Wed Aug 01, 2012 2:51 pm
by olap_knk
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 the cell is '#REF!'
The first column-cell shows me a drop-down box with all picklist values BUT next to this cell, till end of the grid area, all cells displays ONLY '#Ref!' in a drop-down box.
The screen cut is attached.
Did you guys came across to such issue ?Would you suggest me work around ?
Re: Weird behaviour of Picklist at TM1 websheet
Posted: Wed Aug 01, 2012 5:03 pm
by tomok
olap_knk wrote:The first column-cell shows me a drop-down box with all picklist values BUT next to this cell, till end of the grid area, all cells displays ONLY '#Ref!' in a drop-down box.
What is the formula in those cells that are coming back with #Ref? Are they valid?
Re: Weird behaviour of Picklist at TM1 websheet
Posted: Thu Aug 02, 2012 5:30 am
by olap_knk
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$15,"New Forecast Date")
and goes on....
On excel I can see these working but on web except 1st column all shows '#REF!' in dropdown list.
'New forecast date' - is an element (string) of the measure dimension which has attribute (Picklist) months.
D$15/E$15/F$15/ - Is excel cell reference value which holds the item name.
The planning cube has a rule attached which calculates values on inputting new forecast date in lookup_cubename
Re: Weird behaviour of Picklist at TM1 websheet
Posted: Thu Aug 02, 2012 8:10 am
by declanr
Are the "Items" in D15, E15 and F15 populated by a DBRW formula by any chance?
If so try and change it to a DBR.
Re: Weird behaviour of Picklist at TM1 websheet
Posted: Fri Aug 03, 2012 4:54 am
by olap_knk
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.
Re: Weird behaviour of Picklist at TM1 websheet
Posted: Fri Aug 03, 2012 8:17 am
by declanr
If I was in your situation the first thing I would do is create a copy of the sheet and go through changing each type/group of formulas one at a time to a hard-coded value and see which one gets the sheet to start working... then you narrow down the problem.
Re: Weird behaviour of Picklist at TM1 websheet
Posted: Thu Aug 16, 2012 8:38 am
by olap_knk
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 could not see any improvement. I can see only '#Ref'!' as option in each input list cells at excel. (Only the top 1st cells shows associated list options) . Attached screenshot for reference.
Re: Weird behaviour of Picklist at TM1 websheet
Posted: Fri Apr 11, 2014 9:07 am
by tarry9
Hi,
Did you get any solution on above. I am facing the kind of similar issue where I can not see the dropdown itself in Web However, it is working fine in perspective.
The cell has DBRW formula and fetching value from the cube and this cube has picklist.
Is it the known issue of 10.2 Web??
Re: Weird behaviour of Picklist at TM1 websheet
Posted: Mon Jun 30, 2014 11:47 am
by jacktuckerman
Hi tarry9,
You can resolve this issue by highlighting all the cells that have a DBR or DBRW reference that relates to a picklist and then removing Excels data validation from the TM1 picklist reference to "Any Value".
If you then save and republish your sheet back to TM1 then the #REFs will go away in the web.
Jack