Search found 63 matches

by beek
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: 7892

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, ...
by beek
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: 7892

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...
by beek
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: 7892

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...
by beek
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: 3234

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...
by beek
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: 7892

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...
by beek
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: 6526

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...
by beek
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: 6526

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, ;)
by beek
Tue May 20, 2014 8:37 am
Forum: Useful code, tips and tricks
Topic: Using Dates And Times In TM1
Replies: 18
Views: 109392

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....
by beek
Fri Mar 28, 2014 6:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Difference in writing feeders
Replies: 9
Views: 6934

Re: Difference in writing feeders

I see. Got it. Thank you Wim & Java :)
by beek
Fri Mar 28, 2014 2:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Difference in writing feeders
Replies: 9
Views: 6934

Re: Difference in writing feeders

Hi Wim Gielis,
Thanks for your reply.
beek wrote:I would try to solve this with consolidation structures, since you have sums...
Refering to the above, can I assume you are refering to the 1st set of FEEDERS?
by beek
Wed Mar 26, 2014 4:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Difference in writing feeders
Replies: 9
Views: 6934

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;
by beek
Thu Sep 26, 2013 12:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Persistent Feeders
Replies: 14
Views: 12521

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.
by beek
Tue Sep 24, 2013 12:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Persistent Feeders
Replies: 14
Views: 12521

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...
by beek
Mon Sep 23, 2013 1:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Persistent Feeders
Replies: 14
Views: 12521

Re: Persistent Feeders

Thanks ET, you are right. I just did and it works. :D 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 ?
by beek
Mon Sep 23, 2013 1:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Persistent Feeders
Replies: 14
Views: 12521

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...
by beek
Thu Jul 04, 2013 7:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Cube with Many Dimensions
Replies: 7
Views: 5224

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...
by beek
Thu Jul 04, 2013 6:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Cube with Many Dimensions
Replies: 7
Views: 5224

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...
by beek
Thu Jul 04, 2013 3:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Cube with Many Dimensions
Replies: 7
Views: 5224

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...
by beek
Thu Jul 04, 2013 2:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Cube with Many Dimensions
Replies: 7
Views: 5224

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...
by beek
Thu Jul 04, 2013 1:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Cube with Many Dimensions
Replies: 7
Views: 5224

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...