Search found 38 matches
- Wed Dec 16, 2015 11:26 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Picklist on Control cube
- Replies: 11
- Views: 9821
Re: Picklist on Control cube
-The rule checks out and I then double click the cube }Picklist_}ElementAttributes_Tiltak to open it in Cube viewer - Then the picklist is just showing the text I wrote in the rule: static:Yes:No Just to confirm, regarding the parts in bold: you are checking the picklist in the control cube for att...
- Wed Dec 16, 2015 11:15 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Picklist on Control cube
- Replies: 11
- Views: 9821
Re: Picklist on Control cube
Thanks for your answer. Unfortunalety it did not work.Gabor wrote:Try ['Tiltakstype'] =S: 'static:Yes:No'; (add single quotes to left side)
- Wed Dec 16, 2015 9:46 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Picklist on Control cube
- Replies: 11
- Views: 9821
Re: Picklist on Control cube
Hi
I'm on 10.2.2 so it should work. At least according to IBM
http://www-01.ibm.com/support/knowledge ... rol_000123
Does anyone see any fundamental error I'm doing?
I'm on 10.2.2 so it should work. At least according to IBM
http://www-01.ibm.com/support/knowledge ... rol_000123
Does anyone see any fundamental error I'm doing?
- Wed Dec 16, 2015 9:18 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Picklist on Control cube
- Replies: 11
- Views: 9821
Re: Picklist on Control cube
It says so on IBMs page:
http://www-01.ibm.com/support/knowledge ... rol_000123
http://www-01.ibm.com/support/knowledge ... rol_000123
- Wed Dec 16, 2015 8:45 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Picklist on Control cube
- Replies: 11
- Views: 9821
Picklist on Control cube
Hi there Im trying to create a picklist on a control cube but I must be doing something wrong since the cell im adding the rule to just displays the text static:Yes:No. The steps im doing it are: -I have a dimension called Tiltak and want to create a picklist on the controlcube for this dimension -r...
- Tue Oct 22, 2013 12:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Error Cognos Insight 10.2.1 or 10.2 using dimensions
- Replies: 4
- Views: 3859
Re: Error Cognos Insight 10.2.1 or 10.2 using dimensions
Hi
Its some dimensions but i cant get any logic around them since, some of them work and some do not.
Im upgrading to TM1 10.2 now and hopefully it will work better then. Ill post here if it does work .
Thanks for your help!
/Peter
Its some dimensions but i cant get any logic around them since, some of them work and some do not.
Im upgrading to TM1 10.2 now and hopefully it will work better then. Ill post here if it does work .
Thanks for your help!
/Peter
- Tue Oct 22, 2013 8:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Error Cognos Insight 10.2.1 or 10.2 using dimensions
- Replies: 4
- Views: 3859
Re: Error Cognos Insight 10.2.1 or 10.2 using dimensions
Hi
Thanks for you answer.
I have gotten this to work before so that should not be an issue.
Ive attached the miles long error message if you want to take a look at the whole message.
/P
Thanks for you answer.
I have gotten this to work before so that should not be an issue.
Ive attached the miles long error message if you want to take a look at the whole message.
/P
- Tue Oct 22, 2013 7:44 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Error Cognos Insight 10.2.1 or 10.2 using dimensions
- Replies: 4
- Views: 3859
Error Cognos Insight 10.2.1 or 10.2 using dimensions
Hi
Im connected to a customer that has TM1 10.1.1 but using Insight 10.2 or 10.2.1 (I've tried both). When i drag a dimension into the workspace i get the attached error message. Has anyone seen this before and know a solution for it?
/Peter
Im connected to a customer that has TM1 10.1.1 but using Insight 10.2 or 10.2.1 (I've tried both). When i drag a dimension into the workspace i get the attached error message. Has anyone seen this before and know a solution for it?
/Peter
- Mon Mar 18, 2013 1:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cognos Group/Role as TM1 Security Client
- Replies: 1
- Views: 3841
Cognos Group/Role as TM1 Security Client
Hi Not sure this question does work but are there a way to import Cognos 8/10 Groups/Roles into TM1 and clients? Ive setup everything so that when i click on add client or group in tm1 i need to select from the cognos namespace. I would however like to get a specific group in cognos BI and use that ...
- Mon Feb 04, 2013 9:17 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Do selections of dimensions in excel and run export process
- Replies: 1
- Views: 2240
Do selections of dimensions in excel and run export process
Hi Im trying to create an export from a cube view that should populate Cognos Controller Staging tables. I would like the users to do a select and click from excel and then use that excel in Tm1Web (that is then integrated into cognos 10 BI). The key points for the users are: 1. Create selections an...
- Fri Dec 21, 2012 1:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Wierd data loads with Group By SQL
- Replies: 2
- Views: 2452
Re: Wierd data loads with Group By SQL
That was my thought too so I changed it to Data tab only but still the same behaviour
- Fri Dec 21, 2012 12:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Wierd data loads with Group By SQL
- Replies: 2
- Views: 2452
Wierd data loads with Group By SQL
Hi im having a hard time undertanding if im doing something wrong or if this is as intended. So I have an sql statement, I.e Select A,B,Amount from Table I put this in a TI process using the wizard so A and B are element and Amount is Data. This should load data to my cube using the ackumulate optio...
- Wed Dec 19, 2012 4:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Running process locks cube from Read
- Replies: 5
- Views: 3797
Re: Running process locks cube from Read
Have not tried that but since it soes not even work to browse the cubes dimensions in BI when the process is running.
/P
/P
- Wed Dec 19, 2012 2:08 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Running process locks cube from Read
- Replies: 5
- Views: 3797
Re: Running process locks cube from Read
Hi
No Im only loading data to cube A. The dimensions are shared between the two cubes though, which I missed to inform.
/P
No Im only loading data to cube A. The dimensions are shared between the two cubes though, which I missed to inform.
/P
- Wed Dec 19, 2012 12:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Running process locks cube from Read
- Replies: 5
- Views: 3797
Running process locks cube from Read
Hi gurus Im trying to run a process that updates Cube A. At the same time users are reading, using Cognos 10 BI, from Cube B and since there are No rules or feeders between these cubes I thought i could run the process without it affecting users reading from Cube B. What happens is that anything run...
- Thu Dec 06, 2012 5:45 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Wierd attribute output
- Replies: 5
- Views: 4671
Re: Wierd attribute output
Thx for all your replies! I kinda solved it with the tips from you Duncan but the bug also made me understand this a bit more!!
Thx again
Peter
Thx again
Peter
- Thu Dec 06, 2012 11:52 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Wierd attribute output
- Replies: 5
- Views: 4671
Re: Wierd attribute output
Hi V14 is the value from the source cube containing the value in Company Code attribute in the HFMCompany Dimension. I tried Trim(V14) to see if that did anything different but it didnt. The source cube contains a company, I.e 4050, and I want get the corresponding company in the HFMCompany dimensio...
- Thu Dec 06, 2012 10:19 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Wierd attribute output
- Replies: 5
- Views: 4671
Wierd attribute output
Hey I have an attribute in a dimension called CompanyCode (see picture below). Im using a TI process to create a textfile where I send in the attribute Company Code to the dimension and want the HFMCompany from it (using the ATTRS function seen in the picture.) But when I look in the file it just wr...
- Mon Nov 26, 2012 3:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Many to Many In TM1 or Framework manager
- Replies: 3
- Views: 3153
Re: Many to Many In TM1 or Framework manager
It's "kind of hard to explain" yet you offer no attempt at trying to explain it except for a worthless diagram? Where in TM1 is this? A TI process, a dimension structure, or a cube rule? You say the rule works as intended and then you say it doesn't work? Which one is it? You need to prov...
- Mon Nov 26, 2012 2:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Many to Many In TM1 or Framework manager
- Replies: 3
- Views: 3153
Many to Many In TM1 or Framework manager
Hi Im having some difficulties making Many 2 Many relationsship work in TM1. The trouble is that it sums up the total of the many2many dimensions. This works in Framework Manager, which is my source in TM1, but when the data is summed up to the total its wrong. I know its working as intended and i h...