Search found 23 matches
- 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 ...
- 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
Thanks a lot for all your help.. Finally I am able to do it successfully... I really appreciate all your help..
Thanks again..
Regards
- 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
I have attached a .pro file here. Please let me know if this works or not...
Thanks
- 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.......
- 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...
- 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...
- 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...
- 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...
- Thu Oct 06, 2011 6:22 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
Any one has any Idea?
- 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 ...
- 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 ...
- 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...
- 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...
- 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
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
- 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.
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.
- 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
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
- 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...
- 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
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
- 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...
- 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...