Page 1 of 1

Excel report issue in TM1

Posted: Tue Oct 08, 2013 3:08 pm
by manchala
Hi,

I am facing one issue with Excel report in TM1 9.5.1
User trying to filter and select the subsets and he could select the leaf level element ,the value are displaying in the report ,but when he select the consolidated elements ,it is not displaying the element name and the values are not generating only showing error.
using the following function
=SUBNM("pftm1serv:Account_PF","AccMgr_Fox","")


The report accesed from TM1 Web and he could select consolidated and leaf level elements

--> I have attached the screenshots for better understanding

Please respond and give the solution for my query

Looking farword for reply

Thank you in advance

Re: Excel report issue in TM1

Posted: Sun Oct 13, 2013 12:55 am
by rkaif
Try this formula:

Code: Select all

SUBNM("pftm1serv:Account_PF","AccMgr_Fox","Andrea_Underhill")

Re: Excel report issue in TM1

Posted: Mon Oct 14, 2013 6:28 am
by manchala
HI ,
Thank you for the reply
Can you please tell me what is the diffrence between perspective funtionality and TM1web,because the same excel report when you opened from TM1web can able to select all the subset and displayed the valuse.

-Kumar