picklist cube must be named somthing like }Picklist_CubeName
it should be created be TM1 when you right click some cube and choose "create picklist cube"
Search found 209 matches
- Tue Mar 04, 2014 11:34 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Create a pick list
- Replies: 10
- Views: 9897
- Tue Mar 04, 2014 10:39 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Create a pick list
- Replies: 10
- Views: 9897
Re: Create a pick list
You ought to not create picklist cube manually. Create it with right click - create picklist cube
Picklist cube allows you to create a picklist for a cell. If you need to create picklist for a column (for a measure), you should use elementattributes cube
Picklist cube allows you to create a picklist for a cell. If you need to create picklist for a column (for a measure), you should use elementattributes cube
- Mon Jan 27, 2014 7:39 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: AssociateCAMIDToGroup - How does it work?
- Replies: 1
- Views: 2897
AssociateCAMIDToGroup - How does it work?
Hello, community. There is a function AssociateCAMIDToGroup in TM1 10.2.
http://pic.dhe.ibm.com/infocenter/cx/v1 ... group.html
Could you please help me to get through how does it work and what for?
http://pic.dhe.ibm.com/infocenter/cx/v1 ... group.html
Could you please help me to get through how does it work and what for?
- Wed Jan 15, 2014 8:26 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PMPSVC - The planning service parameter was not specified
- Replies: 3
- Views: 6719
Re: PMPSVC - The planning service parameter was not specifie
Hello once again. I have configured my system, it seems to OK but not enough. All configuration files are set to http://testpc... (not testpc.localdomain) If I go to http://testpc/ibmcognos - I can see my applications When I try to go to http://testpc:9510/pmpsvc it redirects me to http://testpc/ibm...
- Wed Jan 15, 2014 7:35 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Web 10.2 application web error while opening
- Replies: 10
- Views: 15145
- Mon Jan 13, 2014 3:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: An error has occurred - when opening Contributor Application
- Replies: 6
- Views: 9959
Re: An error has occurred - when opening Contributor Applica
the adminhost name parameter in fpmsvc_config.xml was inconvinient.
- Mon Jan 13, 2014 1:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: An error has occurred - when opening Contributor Application
- Replies: 6
- Views: 9959
An error has occurred - when opening Contributor Application
Good day.
I got an angooglable problem:
(see screenshot) I can't find the cause, there is no description of what failed. Has anybody met it?
I got an angooglable problem:
(see screenshot) I can't find the cause, there is no description of what failed. Has anybody met it?
- Sun Jan 12, 2014 11:20 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to write this Rules?
- Replies: 11
- Views: 6636
Re: How to write this Rules?
if you write you will feed from both '02' and '03'. So if there is a number or fed value in '02' it will feed further. The same for '03'. If you need to feed month from previous month, use ATTRS.
Code: Select all
[..., {'02','03'}, ...]=>DB(...)
- Mon Dec 30, 2013 8:59 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cafe - System URL
- Replies: 9
- Views: 15466
Re: Cafe - System URL
Good morning! I can't beat the error COI-ERR-2019 Connection failed. Connection returned an error... I'm trying to configure CAFE connection to TM1 server, and have tried to use as system URL different names: http://localhost:9510 http://localhost:9510/pmhub http://testpc:9510 http://testpc:9510/pnh...
- Thu Dec 19, 2013 12:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Connect to TM1 from Cognos Insight
- Replies: 7
- Views: 8289
Re: Connect to TM1 from Cognos Insight
The issue was caused by incorrect MDX that somehow passed to work in Architect, TM1Web, Contributor. I corrected it and finaly got Insight display my cube view.
- Wed Dec 18, 2013 10:11 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Connect to TM1 from Cognos Insight
- Replies: 7
- Views: 8289
Re: Connect to TM1 from Cognos Insight
I got connected to the TM1 server, thaks for advice. But when I try to put a cube view to the workspace I got disconnected. Import data did not succeed too. I can't even google this error. =( Error connecting to the Cognos TM1 server: Cognos Insight will now close the connection to TM1 Безымянный.png
- Wed Dec 18, 2013 8:29 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Connect to TM1 from Cognos Insight
- Replies: 7
- Views: 8289
Re: Connect to TM1 from Cognos Insight
http://localhost:9510/pmpsvc opens ok...
IntegratedSecurityMode = 1
is BI necessary to Insight work?
IntegratedSecurityMode = 1
is BI necessary to Insight work?
- Tue Dec 17, 2013 1:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Connect to TM1 from Cognos Insight
- Replies: 7
- Views: 8289
Connect to TM1 from Cognos Insight
Hello, forum. I got a problem that I cannot find how to solve. The planning server configuration settings could not be found. Initialize the planning server then press enter to try connectiong again. Безымянный.png I tried to put "localhost" to the string but with no success Has anybody me...
- Fri Nov 29, 2013 7:31 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: No read access to elements, cannot view
- Replies: 2
- Views: 3149
Re: No read access to elements, cannot view
Hello, community. Could anyone confirm or refute the following idea: (lets define driver as dimension that drives filtering) It is not possible to save a view where three conditions obtained: 1) MDX filtering {filter ({tm1subsetall ([a])}, [a].[test1] = [1].[test1])} 2) Dimension with dyn.sub. is pl...
- Thu Nov 28, 2013 12:16 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: No read access to elements, cannot view
- Replies: 2
- Views: 3149
Re: No read access to elements, cannot view
deleted and added elements of dimension Dyn dim B (B1,B2...) and all worked
wtf?
wtf?
- Thu Nov 28, 2013 11:06 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: No read access to elements, cannot view
- Replies: 2
- Views: 3149
No read access to elements, cannot view
Hello, forumers. I got a problem with saving view with two dimension dynamic subset. MDX expression is {filter ({tm1subsetall ([Dyn_dimA])}, [Dyn_dimA].[test1] = [Dyn_dimB].[test1])} I need to filter one dimension by correspondance with another dimension in context. In this case choosing context dim...
- Thu Nov 14, 2013 2:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cognos TM1 & SQL: What you gonna do if TI failed ODBCclose?
- Replies: 1
- Views: 2093
Cognos TM1 & SQL: What you gonna do if TI failed ODBCclose?
Hello, community! When we use ODBCopen/ODBCclose in TI there is possibility to fail procces in the middle and miss execution of second command. In this case there are opened connections to ODBC are suspended in SQL until tm1 service is restarted. So the question is - is it somehow possible to close ...
- Tue Nov 05, 2013 1:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: empty view as data source for TI
- Replies: 2
- Views: 2901
empty view as data source for TI
Hello, forum. If TI get an empty view as data source (for example if all subset elements were deleted or subset was cleaned), it will break with following error Error: Prolog procedure line (0): Unable to open data source "<CUBENAME>". I suppose this behaviour is logic enough, not a bug. B...
- Mon Jul 29, 2013 9:21 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }TimeInterval Question
- Replies: 4
- Views: 3285
Re: }TimeInterval Question
such an interesting feature... does it lags in some situations or work fine?
- Thu Jul 25, 2013 7:42 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Stargate Views for complex TM1 Cube
- Replies: 16
- Views: 9827
Re: Stargate Views for complex TM1 Cube
have you tried adjust CalculationThresholdForStorage parameter?
http://pic.dhe.ibm.com/infocenter/ctm1/ ... orage.html
http://pic.dhe.ibm.com/infocenter/ctm1/ ... orage.html