Search found 38 matches

by A.Pete
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...
by A.Pete
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

Gabor wrote:Try ['Tiltakstype'] =S: 'static:Yes:No'; (add single quotes to left side)
Thanks for your answer. Unfortunalety it did not work.
by A.Pete
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?
by A.Pete
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...
by A.Pete
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
by A.Pete
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
by A.Pete
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
by A.Pete
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 ...
by A.Pete
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...
by A.Pete
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
by A.Pete
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...
by A.Pete
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
by A.Pete
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
by A.Pete
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...
by A.Pete
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
by A.Pete
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...
by A.Pete
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...
by A.Pete
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...
by A.Pete
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...