TM1 Forum

Okay I changed the ASCIIOUTPUT command to:
asciioutput('c:\temp1.txt', store);

and it actually returned the first value in my cube view. So I guess I just need to sort out my SQL statement....which has proven a difficult task.

When I input the following asciioutput statement: asciioutput('c:\temp1.txt', ('INSERT INTO sendodbc (Store) VALUES ( Store)' )); it returned the following into my temp1.txt file: "INSERT INTO sendodbc (Store) VALUES ( Store)" I am assuming I want to see actual values and not literals corr...

I could really use some help if someone has an idea. I need to get a value to access from my cube view and am getting an SQL error. In my prolog tab I have the following: Source='sendodbc'; ODBCOpen('sendodbc',' ',' '); (sendodbc is the name of the odbc I set up to connect to my table called sendodb...

Have a perspective client who is currently on SAP R3 (not using BW)...can anyone provide the lowdown on connection options to TM1 for them? Possible solutions?

Regards,
Chris

Thank you Eric...however I am still getting nothing. I'm sure my mistake is painfully simple. Is there a process to see exactly what the process will try to pull other than in the preview window. By that I mean is there another way to show the output from the execution of the SQL Statement? Regards

I have finally moved past the 'cannot connect to remote machine' error thanks to the advice from the board. However I am still not getting data to populate into my Access Database. This is the entirety of my Data Tab in TI: #****GENERATED STATEMENTS START**** #****GENERATED STATEMENTS FINISH**** ODB...

I realize this will sound eerily similar to a question just posted but the source and destinations were reversed..when setting up the ODBC connection to publish FROM TM1 to access...what should I select for the Database? I am trying to publish the entire cube called Sales. Also, do I need to do anyt...

Thank you Martin, I will take a look.

I was interested in knowing if there is a way to take data from a cube and to publish it into a source like MS Access. If this is possible can someone please show me how this is done or where to find out how?

Thanks

I have someone interested in developing dynamic TM1-spreadsheets using action buttons-TM1 TI processes that would work as macros within a spreadsheet. I was curious if someone could answer the following: 1. Performance Factors 2. Things to consider\possible problems when using and point me to a good...