Search found 209 matches

by ioscat
Tue Mar 04, 2014 11:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create a pick list
Replies: 10
Views: 9896

Re: Create a pick list

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"
by ioscat
Tue Mar 04, 2014 10:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create a pick list
Replies: 10
Views: 9896

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
by ioscat
Mon Jan 27, 2014 7:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: AssociateCAMIDToGroup - How does it work?
Replies: 1
Views: 2896

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?
by ioscat
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: 6714

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...
by ioscat
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: 9956

Re: An error has occurred - when opening Contributor Applica

the adminhost name parameter in fpmsvc_config.xml was inconvinient.
by ioscat
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: 9956

An error has occurred - when opening Contributor Application

Good day.
I got an angooglable problem:
(see screenshot)
Безымянный.png
Безымянный.png (163.16 KiB) Viewed 9956 times
I can't find the cause, there is no description of what failed. Has anybody met it?
by ioscat
Sun Jan 12, 2014 11:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to write this Rules?
Replies: 11
Views: 6633

Re: How to write this Rules?

if you write

Code: Select all

[..., {'02','03'}, ...]=>DB(...)
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.
by ioscat
Mon Dec 30, 2013 8:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cafe - System URL
Replies: 9
Views: 15460

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...
by ioscat
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: 8286

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.
by ioscat
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: 8286

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
by ioscat
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: 8286

Re: Connect to TM1 from Cognos Insight

http://localhost:9510/pmpsvc opens ok...

IntegratedSecurityMode = 1
is BI necessary to Insight work?
by ioscat
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: 8286

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...
by ioscat
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...
by ioscat
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

:cry: wtf?
by ioscat
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...
by ioscat
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: 2092

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 ...
by ioscat
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: 2899

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...
by ioscat
Mon Jul 29, 2013 9:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }TimeInterval Question
Replies: 4
Views: 3284

Re: }TimeInterval Question

such an interesting feature... does it lags in some situations or work fine?
by ioscat
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