deleted

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

deleted

Post by manchala »

deleted
Last edited by manchala on Tue Oct 08, 2013 3:10 pm, edited 1 time in total.
--Kumar
lotsaram
MVP
Posts: 3703
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: New interface in TM1

Post by lotsaram »

Wikipedia wrote:Clairvoyance:
The term clairvoyance (from French clair meaning "clear" and voyance meaning "vision") is used to refer to the ability to gain information about an object, person, location or physical event through means other than the known human senses, a form of extra-sensory perception.
As the overlap between active clairvoyants and TM1 experts is presumed to be very small how about you review the Request for assistance guidelines? For good measure a quick look at http://www.whathaveyoutried.com wouldn't hurt either ...
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
manchala wrote:Hi,

We have to build the new dimensions in existing TM1 Cube and below are the coulums extracted from source system.Generally data extracted from BW and make this as csv pick the data from CSV.

Please advice here how many dimension required with the belos colums and pleas give some clear idea on this.

Start_Date
End_Date

Cust_Code
Cust_DESC

Brand_Code
Brand_DEDC

Size_Code
Size_DESC

Pack_Code
Pack_DESC


Thank you,
Kumar
Attachments
Excel report issue.docx
screen shots doc
(208.58 KiB) Downloaded 228 times
--Kumar
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

Pleae read excel issue

Post by manchala »

I can not send the new post therefore i replyed with earlier post so displaying earlier post first pls ignore that and read below post
--Kumar
Post Reply