Search found 10 matches

by Ana Ventura
Fri Aug 04, 2017 1:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Loading data in Cube with Picklist TM1
Replies: 12
Views: 1775

Re: Loading data in Cube with Picklist TM1

Hi everyone, Thank you very much for your help. I'm going to read the documentation. I know how i can do the simple process to load data in tm1 cube with odbc data source, but this case i have some data columns on the table in database and i want to load the into the TM1 cube, and this cube has a pi...
by Ana Ventura
Thu Aug 03, 2017 10:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Loading data in Cube with Picklist TM1
Replies: 12
Views: 1775

Re: Loading data in Cube with Picklist TM1

Hello, Thank you for answer. but i have a doubt in writing my query in prolog or metadata section. The query is like: ODBCOpen( 'DSNname', ' userid' , 'passwd ' ); Squery = 'Select Services, client from table'; How i can associate Services and Client on variables? In addition to these columns (Servi...
by Ana Ventura
Wed Aug 02, 2017 4:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Loading data in Cube with Picklist TM1
Replies: 12
Views: 1775

Re: Loading data in Cube with Picklist TM1

yes sure. I have a table with: Services, client (image on attachment table.png) this table has a information that i want to load in Rubricas, Tipo Serviço that this elements are a picklist in my TM1 cube, you can see this in elements.png. So i want to create a TI process to load this columns and upd...
by Ana Ventura
Wed Aug 02, 2017 3:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Loading data in Cube with Picklist TM1
Replies: 12
Views: 1775

Re: Loading data in Cube with Picklist TM1

Thank you your for answer. I have a table with columns that represent my dimension elements, for example, i have a dimension RUB with two elements: Services; Client; This elements has a picklist with data from other dimension. My table in database has two columns Services and Client with the informa...
by Ana Ventura
Wed Aug 02, 2017 3:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Loading data in Cube with Picklist TM1
Replies: 12
Views: 1775

Loading data in Cube with Picklist TM1

Hello everyone, I want to load data into a TM1 cube with TI process, but my cube has a dimension with picklist elements. How can I load the data from my table in sql to the cube with a picklist? The data that is on the picklist exists in my fact table that i want to load. Do you have any idea that i...
by Ana Ventura
Tue Aug 01, 2017 10:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Manage Rights error Cognos Planning Analytics V2.0.X
Replies: 0
Views: 491

Manage Rights error Cognos Planning Analytics V2.0.X

Hello, I have a problem with manage rights from my TM1 Web Applications. When i tried to save my rights i had an error "An error occurred while creating Cognos objects". I added the Clients and Groups from Cognos BI in Architect and after i tried to save my rights i received this error. I saw the lo...
by Ana Ventura
Fri Jul 28, 2017 4:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Manage Rights error - Migration between Cognos 10.2.2 to Cognos Planning Analytics
Replies: 0
Views: 496

Manage Rights error - Migration between Cognos 10.2.2 to Cognos Planning Analytics

Hello everyone, I did a migration of Cognos TM1 10.2.2 to Planning Analytics 2.0.2, and i have a problem with manage rights in Cognos Planning. When i created the new Cognos Groups and selected the group->security and clicked in apply in TM1 web Applications, i had a error "An error occurred while c...
by Ana Ventura
Mon Jul 18, 2016 1:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Express is already initialized
Replies: 0
Views: 346

Cognos Express is already initialized

Hi everyone, When i access the portal Cognos Express i have a error "Cognos Express is already initialized". I made my research in google and i found this: "Resolving the problem 1) Stop all Cognos Express services: - IBM Cognos Express - IBM Cognos Analytic Server - CXMD - IBM Cognos Analytic Serve...
by Ana Ventura
Wed Jan 06, 2016 4:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problem to assign to native TM1 groups within the Manage Rights
Replies: 3
Views: 906

Problem to assign to native TM1 groups within the Manage Rights

Hi guys, I configure my TM1 Entreprise 10.2.2 with AD Cognos BI authentication. On my tm1s.cfg i have a Integrated Security Mode=5 but with this configuration i don't have access my TM1 groups on manage Rights in my TM1 web applications. This way how i can access TM1 groups in manage rights applicat...
by Ana Ventura
Tue Dec 15, 2015 12:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Configuration IBM Cognos TM1 Aplications with users AD
Replies: 0
Views: 614

Configuration IBM Cognos TM1 Aplications with users AD

Hello, I'm trying to configure TM1 (Cognos TM1 Enterprise) Aplications with users AD of cognos BI. My first step was configure the file tm1s.cfg with: IntegratedSecurityMode=5 ServerCAMURI=http://<BI server>:9300/p2pd/servlet/dispatch ClientCAMURI=http://<BI server>:9300/p2pd/servlet/dispatch After ...