Search found 23 matches

by JayM
Fri Oct 07, 2011 6:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CellPutN doent put value in to the cube
Replies: 25
Views: 14163

Re: CellPutN doent put value in to the cube

For the benefit of others who may read this thread looking for solutions, please post what steps you took to fix your problem. I had a consolidated value in my view which was not allowing me to put values in my cube with CellPutN. ***Following are the steps I took to solve the issue**** 1) Created ...
by JayM
Fri Oct 07, 2011 6:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CellPutN doent put value in to the cube
Replies: 25
Views: 14163

Re: CellPutN doent put value in to the cube

Hi All,

Thanks a lot for all your help.. Finally I am able to do it successfully... I really appreciate all your help..

Thanks again..

Regards
by JayM
Fri Oct 07, 2011 1:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CellPutN doent put value in to the cube
Replies: 25
Views: 14163

Re: CellPutN doent put value in to the cube

Hi

I have attached a .pro file here. Please let me know if this works or not...

Thanks
by JayM
Thu Oct 06, 2011 9:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CellPutN doent put value in to the cube
Replies: 25
Views: 14163

Re: CellPutN doent put value in to the cube

I will upload .pro file soon for the same.......
by JayM
Thu Oct 06, 2011 9:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CellPutN doent put value in to the cube
Replies: 25
Views: 14163

Re: CellPutN doent put value in to the cube

Sir, I am not showing any attitude or rudeness... what I meant to say was.. I am a beginner and trying to solve the problem since long.... I have always appreciated and provided what they have ask..... I was unable to upload the file more then 512kbs and that the reason I put it in .rar... Apologies...
by JayM
Thu Oct 06, 2011 9:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CellPutN doent put value in to the cube
Replies: 25
Views: 14163

Re: CellPutN doent put value in to the cube

Have you followed any, and I mean ANY of the advice already listed? 1. Give you actual code 2. Do an ASCIIOutput on the data tab to test if your data source actually contains any records 3. Have another look at your CellPutN function. Unless you actually have an element called "Account" a...
by JayM
Thu Oct 06, 2011 8:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CellPutN doent put value in to the cube
Replies: 25
Views: 14163

Re: CellPutN doent put value in to the cube

I think it's on you to show that you have comprehended and thought about the ideas (plural) that you have been given. Yes you are clearly doing something wrong but unless you post the actual code no one can really help you. I understand the fact but the only thing I am using or say writing in the T...
by JayM
Thu Oct 06, 2011 7:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CellPutN doent put value in to the cube
Replies: 25
Views: 14163

Re: CellPutN doent put value in to the cube

Unless you actually decide to show us what you are doing, we can keep guessing for a long time. My guess is - there's something wrong with your data source definition and Data tab is not being executed, because there are no rows of data to execute it for. You could check that with a simple ASCIIOUT...
by JayM
Thu Oct 06, 2011 3:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CellPutN doent put value in to the cube
Replies: 25
Views: 14163

Re: CellPutN doent put value in to the cube

You're making a lot of mistakes here. Firstly, your CellPutN should be used like that (without referencing dimension names): CellPutN(1,'MyCube','ele1','ele2',...); What you want to do is - create a source view that does NOT have the 'skip zero/blank values" option checked (but rule calcs and ...
by JayM
Thu Oct 06, 2011 2:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CellPutN doent put value in to the cube
Replies: 25
Views: 14163

CellPutN doent put value in to the cube

Hi, I have 0s at some of the intersection and value at some. I would like to put value 1 at the intersection where the value is 0 only because I would like to spread the value at the Consolidation after putting 1. I have created a VIEW and am using that view as my data source in TI process. In data ...
by JayM
Mon Oct 03, 2011 6:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Equal spread allocation using TM1 rule
Replies: 4
Views: 4312

Re: Equal spread allocation using TM1 rule

Can you elaborate what you mean by this? Where does the value sit? Consolidations in TM1 cannot store numeric values, so in order to "have" any values they have to have them calculated, either by consolidating, or by a rule-driven computation. Now, if you want your consolidated value whic...
by JayM
Mon Oct 03, 2011 4:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rule error...
Replies: 1
Views: 1550

TM1 Rule error...

Hi, When I use following TI function in TM1 rule editor, I get below attached error...... Function Used: CellPutProportionalSpread(7704,'GL','expense','Engineering','2011','Actual'); I am not sure whether I can use this function under rule editor or not? if yes, Am I using this function correctly? R...
by JayM
Fri Sep 30, 2011 8:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Equal spread allocation using TM1 rule
Replies: 4
Views: 4312

Equal spread allocation using TM1 rule

Hi

I am struggling with Equal Spread allocation formula using TM1 rule. I

I know how to do it using Server Explorer/Active forms.

I want to spread my consolidated element value to all its children. Is there anyway to do this?

Thanks
by JayM
Tue Sep 27, 2011 4:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change not reflected in Active form
Replies: 5
Views: 3393

Re: Change not reflected in Active form

Hi Chris,

Thanks for the reply.

By change I meant the structure. I changed the data from list view to tree view and I need that to be reflected in the Active form.

I will try and implement the comments above.
by JayM
Tue Sep 27, 2011 2:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change not reflected in Active form
Replies: 5
Views: 3393

Re: Change not reflected in Active form

Hi Chris,

I am rebuilding the current sheet with button provided in the Active form. Is it wrong? Do I need to perform any other checks to update the current sheet?

Regards
by JayM
Mon Sep 26, 2011 5:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change not reflected in Active form
Replies: 5
Views: 3393

Change not reflected in Active form

Hi All, I need help with following. My Active form is not getting updated automatically after doing some changes in TM1cube. Initially I sliced my active form with all the data exposed(drilled down) and saved it. Now I have done some changes to the cube and want my data under some specific element a...
by JayM
Mon Sep 26, 2011 3:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Xcelerator loading XLSM files to application folder
Replies: 14
Views: 9261

Re: Xcelerator loading XLSM files to application folder

Hi,

I am having the same issue with xslx or xlsm files under Application folder. What is this }Application\ folder where this .blob file needs to be saved?

Thanks
by JayM
Tue Sep 20, 2011 4:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: YTD dimension/element/subset calculation/formula
Replies: 1
Views: 1897

YTD dimension/element/subset calculation/formula

Hi I am new to this. I have Time Dimension in my cube which has everything separately rolling up to Year i.e, Year <-- quarter <-- Month, which I have uploaded from an excel source file. Do I have to create new column called YTD in excel and then rerun the process in TM1 or I can create the new elem...
by JayM
Tue Sep 20, 2011 3:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performing YTD and other relative time calculations in TM1
Replies: 13
Views: 14883

Re: Performing YTD and other relative time calculations in T

Hi I am new to this. I saw your attachment. I have Time Dimension which has everything separately rolling up to Year i.e, Year <-- quarter <-- Month which I have uploaded from a excel source file. Do I have to create new column called YTD in excel and then rerun the process in TM1 or I can create th...