TM1 Forum

Hi

I've build tm1 websheet that allow me to put data to the tm1 dimension.
But I have problem, I want to allo edit data that is in dimension
In first cell I have element name, and i can choose it thanks to subnm.
In the second cell i have attribute value, that also is dictionary:
SUBNM("CXMD:dMes1";"Miesiace";DBRA("CXMD:dMes2";B1;"From"))
When i choose something from dimension dictionary DBRA("CXMD:dMes2";B1;"From") is disapering from formula.
How to avoid this, or refresh sheet to the orginal state (rebuild from action button don't work)

Please help

Motyl wrote:Hi

I've build tm1 websheet that allow me to put data to the tm1 dimension.
But I have problem, I want to allo edit data that is in dimension
In first cell I have element name, and i can choose it thanks to subnm.
In the second cell i have attribute value, that also is dictionary:
SUBNM("CXMD:dMes1";"Miesiace";DBRA("CXMD:dMes2";B1;"From"))
When i choose something from dimension dictionary DBRA("CXMD:dMes2";B1;"From") is disapering from formula.
How to avoid this, or refresh sheet to the orginal state (rebuild from action button don't work)

Please help

In one cell you can't. Every time you make a SUBNM selection you are essentially rewriting the formula in that cell.

Why would you need the second column to be a SUBNM at all, if they are using the first to select the element with a SUBNM; just keep the DBRA part (without the SUBNM) in the second column that looks at the first.