Excel report issue in TM1
Posted: Tue Oct 08, 2013 3:08 pm
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
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