Search found 63 matches
- Mon Apr 12, 2021 2:12 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ASCIIOUTPUT does not create output file
- Replies: 18
- Views: 8025
Re: ASCIIOUTPUT does not create output file
When you use a view as a data source, by default the consolidated elements are skipped This is something I missed out. The default behaviour of cubeview. I thought if I use the view which I can see from the architect in the TI, Data tab will be reading it too. Thank you for highlighting this. Yes, ...
- Mon Apr 12, 2021 1:01 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ASCIIOUTPUT does not create output file
- Replies: 18
- Views: 8025
Re: ASCIIOUTPUT does not create output file
Here's what I tested. I select a view from cube A (consists of 17 dims) from the Data Source tab. At the Variables, I set all to Others At the Prolog, I use code asciioutput('\\analyst-app\libraries\Lib\TM1\Cost\aaa.txt','zzzTEsting'); MetaData, i use code asciioutput('\\analyst-app\libraries\Lib\TM...
- Sat Apr 10, 2021 9:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ASCIIOUTPUT does not create output file
- Replies: 18
- Views: 8025
Re: ASCIIOUTPUT does not create output file
Hi Wim, Thanks for responding to my thread. Yes, I made sure that view is the correct view. I put below in the Prolog tab. DataSourceType = 'VIEW'; DatasourceNameForServer= s_SourceCube; DatasourceCubeview=s_SourceView; At first I suspected it was my coding that is having problem, then I try it with...
- Sat Apr 10, 2021 8:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Asciioutput Data Export is not working
- Replies: 5
- Views: 3266
Re: Asciioutput Data Export is not working
Hi dharav9 , Have you found the answer to your problem? I seem to be facing the same problem with you. Not able to asciioutput from a cubeview. I can confirm no problem with the view, as I managed to open and see data from the architect. Then I try something, I tried to do asciioutput with other cub...
- Sat Apr 10, 2021 8:45 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ASCIIOUTPUT does not create output file
- Replies: 18
- Views: 8025
Re: ASCIIOUTPUT does not create output file
Hi there, Just like to ride on the topic. I am facing a problem at my end to asciioutput a file from data tab. Data source is cubeview. I have checked the cubeview (even from TM1 architect), confirm that view is not blank. But nothing appears when I tried to asciioutput the data. If I put the asciio...
- Wed Nov 11, 2015 7:10 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Error with Package Connector 32-bit when using TM1 10.2
- Replies: 4
- Views: 6561
Re: Error with Package Connector 32-bit when using TM1 10.2
Hi all, Just to share. I managed to solve the above issue. I heed the advice of dr.nybble, by setting <logCommands value="2"/>. Then I see another error in the log, quoted me another error code. I can't remember exactly what error code now. But I did a search online, and it references me t...
- Tue Nov 10, 2015 3:34 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Error with Package Connector 32-bit when using TM1 10.2
- Replies: 4
- Views: 6561
Re: Error with Package Connector 32-bit when using TM1 10.2
Hi there,
Any updates on this topic? I'm facing the same problem here. Kindly share your status or resolution with me if there's any. Thanks in advance.
Cheers,
Any updates on this topic? I'm facing the same problem here. Kindly share your status or resolution with me if there's any. Thanks in advance.
Cheers,
- Tue May 20, 2014 8:37 am
- Forum: Useful code, tips and tricks
- Topic: Using Dates And Times In TM1
- Replies: 18
- Views: 111541
Re: Using Dates And Times In TM1
Hi all, For instance in the Web when the user enters "01/01/2010" (US format) the format held in TM1 as originally input, but now when the user enteres "01/01/2010" in Excel it saves as "40179" in TM1. Just to share, I've just encountered the same thing few minutes ago....
- Fri Mar 28, 2014 6:28 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Difference in writing feeders
- Replies: 9
- Views: 6956
Re: Difference in writing feeders
I see. Got it. Thank you Wim & Java
- Fri Mar 28, 2014 2:41 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Difference in writing feeders
- Replies: 9
- Views: 6956
Re: Difference in writing feeders
Hi Wim Gielis,
Thanks for your reply.
Thanks for your reply.
Refering to the above, can I assume you are refering to the 1st set of FEEDERS?beek wrote:I would try to solve this with consolidation structures, since you have sums...
- Wed Mar 26, 2014 4:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Difference in writing feeders
- Replies: 9
- Views: 6956
Re: Difference in writing feeders
Hi there,
I'm facing a similar situation here. Assuming below is my rule & feeders, any idea which way of putting the feeders would be more efficient ?
A=B+C;
D=A+E;
FEEDERS;
B=>A;
C=>A;
A=>D;
E=>D;
OR
B=>A,D;
C=>A,D;
E=>D;
I'm facing a similar situation here. Assuming below is my rule & feeders, any idea which way of putting the feeders would be more efficient ?
A=B+C;
D=A+E;
FEEDERS;
B=>A;
C=>A;
A=>D;
E=>D;
OR
B=>A,D;
C=>A,D;
E=>D;
- Thu Sep 26, 2013 12:50 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Persistent Feeders
- Replies: 14
- Views: 12596
Re: Persistent Feeders
Yes, you are right. Only the subsequent startup will be faster. For my case, from 5hours, it cut down to 30mins, and the data directory, the size increased by 3~4 times of the original size.
- Tue Sep 24, 2013 12:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Persistent Feeders
- Replies: 14
- Views: 12596
Re: Persistent Feeders
Thanks ET & Gabor. For my environment, in CX9.0 it is taking 5hours to start up the environment (some of the cube is very heavy, it took 2hrs to fully loaded the feeder). and we only have 1 DB directory, hence, I think for our case, it might be good to use the PersistentFeeder? Anyway, I had not...
- Mon Sep 23, 2013 1:52 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Persistent Feeders
- Replies: 14
- Views: 12596
Re: Persistent Feeders
Thanks ET, you are right. I just did and it works. I noticed some people here choose not to on this setting. Can I know why ? Coz from what I see, since it can improve the startup time, why not ?
- Mon Sep 23, 2013 1:04 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Persistent Feeders
- Replies: 14
- Views: 12596
Re: Persistent Feeders
Hi there, I had recently setup Cognos Express 10.1 for migrating our 9.0. I heard Persistent Feeder is a new feature which give faster startup time. However, I noted my started up time unchanged, and I do not see any .FEEDER file created in my data directory. Is there anything I missed out? Must I e...
- Thu Jul 04, 2013 7:50 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Cube with Many Dimensions
- Replies: 7
- Views: 5256
Re: TM1 Cube with Many Dimensions
my bad. Just solved this mystery. merely 4 dimensions with 2000 elements should not have crashed tm1. It is the rule that is killing it. I did not put the SKIPCHECK!! I turn on the TM1log and I saw system keep busying with the rules. So I check on the rules. I was so careless, did not put the SKIPCH...
- Thu Jul 04, 2013 6:19 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Cube with Many Dimensions
- Replies: 7
- Views: 5256
Re: TM1 Cube with Many Dimensions
The log shows "4360 ERROR 2013-07-04 03:41:27.648 TM1.Server TM1 Server Abort: System Out Of Memory." From the cube explorer, i can see this cube is only 48KB. But the view I'm trying to create might be too huge. I put 4 dimensions on the left, and 1 dimension has about 2,000 elements. Thi...
- Thu Jul 04, 2013 3:16 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Cube with Many Dimensions
- Replies: 7
- Views: 5256
Re: TM1 Cube with Many Dimensions
Yes, I did :( It seem if I put too many dimensions on the left, with all elements, the system crashes. If the lesser dimensions on the left, then it will work just fine. But then, how will I be able to get a report/view of all the Material#,Customer,EndUser, Application Codes, Salesman, etc that I h...
- Thu Jul 04, 2013 2:09 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Cube with Many Dimensions
- Replies: 7
- Views: 5256
Re: TM1 Cube with Many Dimensions
Hi Macsir, I was just trying to create a view. I put a few dimensions like material, customer, shiptoParty, ApplicationCode, and Salesman at the left pane, and Time dimension on the right (or top). I select all elements in the dimensions on the left, and select current Year (12 mths). When I click o...
- Thu Jul 04, 2013 1:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Cube with Many Dimensions
- Replies: 7
- Views: 5256
TM1 Cube with Many Dimensions
Dear all, Here's the situation that has been bugging me. Recently we are planning to deploy TM1 to a department to do forecasting. Below are the information they are inputting when they are doing the forecast in the manual system. Material# Customer CustomerPart# (Same Material for same customer can...