deleted
-
- 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
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 ...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.
-
- 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
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
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
-
- 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
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