TM1 Forum

I am having the exact issue. Did you resolve this? Does anyone have any suggestions?

Thanks for the help everyone!

I tried the following but I keep getting an error. It wants me to add a comma but I am not sure why. odbcopen('MyDB', 'Admin', 'password'); odbcoutput('MyDB', 'Update ViewDailySalesStaging set MaterialCost = (Amount * .40) WHERE (LEFT(CONVERT(VARCHAR,TransactionDate,102),7) = LEFT(CONVERT(VARCHAR,GE...

I need to add a simple update query to my prolog for a process. How can I accomplish this? The data source I want to run the query against is the datasource the process is using. It does not work if I try to put it in the query box. Here is the query I need to add: Update ViewDailySalesStaging set M...

Another update: I can replicate the issue by running all of my nightly chores, waiting for them to finish, and then running this process. I can re-run the process as many times as I want and it will fail everytime. However, if I unload the cube that the failing process uses as a data source, the pro...

Here is the process (in a different chore that completes before the failing process) that updates the customer dimension. Metadata Tab: #****Begin: Generated Statements*** TM1Date= SUBST(TransactionDate, 1, 10); vMonth=subst(TransactionDate,6,2); vTime=IF(vMonth@='01','Jan-'|subst(TransactionDate,3,...

This process does NOT do anything in the metadata tab. Yes, that is the alias name for the element, not the principal.

This process is in a stand-alone chore that starts several hours after the other scheduled chores have completed. Some of the other chores do insert elements into the customer dimension but finish before this process runs. Also, this process doesn't have anything in the metadata tab.

I initially thought this as well, but when I open up the dimension, the element is there.

I have a process that fails only periodically with the following error: Error: Data procedure line (68): error repeats 15 times "Agriculture","Australia","06-0300-AF SHEET","AUTOMOTIVE COMPONENTS LTD-06-CAUT501","BIRollup","Local","06&...