Excel report issue in TM1

Post Reply
manchala
Posts: 17
Joined: Tue Feb 26, 2013 1:32 pm
OLAP Product: Cognos BI,Cognos TM1
Version: Cognos TM1 5.1
Excel Version: 2007

Excel report issue in TM1

Post 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
Attachments
Excel report issue.docx
(208.58 KiB) Downloaded 226 times
--Kumar
User avatar
rkaif
Community Contributor
Posts: 328
Joined: Fri Sep 05, 2008 6:58 pm
OLAP Product: IBM Cognos TM1
Version: 9.1 or later
Excel Version: 2003 or later

Re: Excel report issue in TM1

Post by rkaif »

Try this formula:

Code: Select all

SUBNM("pftm1serv:Account_PF","AccMgr_Fox","Andrea_Underhill")
Cheers!
Rizwan Kaif
manchala
Posts: 17
Joined: Tue Feb 26, 2013 1:32 pm
OLAP Product: Cognos BI,Cognos TM1
Version: Cognos TM1 5.1
Excel Version: 2007

Re: Excel report issue in TM1

Post 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
--Kumar
Post Reply