Excel report issue in TM1

[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

[rkaif]

Try this formula:

Code: Select all

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

[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