Weird behaviour of Picklist at TM1 websheet

[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 ?

[tomok]

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?

[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

[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.

[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.

[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.

[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.

[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??

[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