Check the TM1 help files for Excel worksheet functions. The function that you want is DBRA()bunchukokoy wrote: Does anyone know how I am gonna dispalay a specific element attribute to a cell in excel?
It's like I have an attribute for Dimension Stores which is EStablishedDate. This attribute is a string type. And I want to display on a cell the attribute of Store#1.
My bet is that the value in cell A1 is stored as a numeric one. To force the DBRA formula to read it as a string, insert a single quote in front of it; so '106 (the quote won't be visible in Excel) rather than just 106.bunchukokoy wrote:Hi! Allan,
I have used the function so I have this sample =DBRA("server:store",$A$1,"EST DATE"), but it returns blank. But when I hard-code the Store into
=DBRA("server:site","106","EST DATE"), it returns the right one... Do you know what's wrong Sir?
That's correct, though I probably wouldn't; as far as possible I try to strip out any unnecessary formulas in an Excel report workbook using TM1. By themselves the calculation time can be insignificant but as more and more functions go in it can start to have a performance impact. If you have say 30 stores, that's an extra 30 function calls that Excel has to make in the process of calculating the sheet. But certainly that expression should still return the correct result.bskalli wrote:You can also use DBRA("server:store",Text($A$1,"@"),"EST DATE")