TM1 Forum

Thanks Mate!!

Cube now calculates perfectly

Hi All, I've been trying to build a Cube to store all of our Headcount data so that our analysts can review the movements of staff within Cost Centres & businesses. As seems to be typical, I had it all working sort of OK, all my rules were working OK (from what I could tell) but a screw up in th...

Hi Winson, The Raw Data is a Monthly Flat File that basically lists out all of the Staff ID's & names with their Cost Centre and a few other roll up details (for that Month only). So to determine if the Staff are "New" we have tried to apply the logic that if their ID did not exist las...

Hi All, I'm trying to build a Cube to store our Staff HC data and had this great idea of also including "dummy" accounts so that we could have a hierarchy like this: Beginning of Period (BOP) New Staff Attrition Transfers in Transfers out End of Period (EOP) As you can see in the attched f...

Hi All, I'm trying to write a rule that effectively "hides" all of our legacy Cost Centres from our users by updating the Element Security Cube relating to the Responsibility Centre. So the logic for the rule is: If the Responsibility Centre is in the "Legacy RC" consolidation &a...

Prolly should have google searched for images earlier, seems the TM1 Modeller is a new (for us anyway) set of tools for us to play with:

Just had a look at what we purchased: IBM Cognos Enterprise Planning TM1 Modeler Authorized User IBM Cognos 8 Enterprise Planning TM1 Contributor Authorized User So my assumption is that the Modeler package is our "Admin" Package & Contributor is the "Client" package. In that...

Ah... the joys of working in a Global company, the IT team in AU have to coordinate with the actual programers / packagers in China :roll: The Admin package contains both the Perspectives + Architect so should not be a problem, was just curious if anyone knew if there were any licencing issues in re...

Hi All, Hopefully a simple question :D Is there any difference in releasing the TM1 Admin Package to users over the Client Package other than the addition of the Architect app? Is Admin licenced differently or anything? The reason I ask is that our IT team have gone off and created a package for dis...

ok, for sh!ts & giggles, i put in my username & password into the ODBCOpen and ran the process, then put in the WRONG password and it still process successfully without actually updating the SQL database :shock: Shouldn't I get some error if i was really connecting to the ODBC source or is i...

Hi Jorel, My code does have the single quotation marks... BTW - found that the Could not Initialise Process was due to this line of code: # Execute process for check to see if Balances send in the SQL query match to the balances in z_ctrl_measures cube ExecuteProcess('123 JC Trans Daily 3a', 'cubena...

Just another note, I have run the Process without the code to do the SQL update - ODBCOutput('TM1DBP_UAT', sqlStmt ) ; I still get the same result... " Could not initialize process " And just to confirm that I have access to the ODBC source, I can retrieve the transactions from our Drill p...

Hi Tomok, Just to confirm, we are not using MS Access as the "database", it is merely used to execute the code to append our transactions from the text file into our main SQL Database tables on a SQL Server 2008. We are trying to eliminate that MS Access step and have a TM1 process execute...

I've got a similar issue, I'm trying to send the data from a text file to an SQL database. Our current set up is using MS Access to import the text file and then "append" the new transaction data into our SQL database, we want to automate this via a TM1 process. I seem to be able to genera...

I seem to have found most of my issue, the "TRANS_Details" is an alias I created in the Data Source, so renamed it to its real name and inserted the [] around it and now seems to export now :D BTW - Was lucky it didn't work previously, I was actually pointing to our Prod DB & not UAT :o

The Result of the ASCIIOutput is: "INSERT INTO TRANS_Details (COY_NO , GL_ACCOUNT , RC, TRANS_DATE ,TRANS_CODE , DESCRIPTION , TRANS_SOURCE , TRANS_REF , AMOUNT , LV , TRANS_DATE_EFF , SEQUENCE_NO ,BATCH_NO , TM1_MONTH , FDL_B , TM1_Daily , TYPE , MAPA , MAPB , MAPC , MAPD , PRODPROC ,AMOUNT_AV...

I thought I'd piggyback on this tread, I'm getting the same error with my SQL, code per below: ODBCOutput('TM1DBP_SQL', Expand( 'INSERT INTO TRANS_Details (COY_NO , GL_ACCOUNT , RC, TRANS_DATE , TRANS_CODE , DESCRIPTION , TRANS_SOURCE , TRANS_REF , AMOUNT , LV , TRANS_DATE_EFF , SEQUENCE_NO , BATCH_...

Hi Duncan,

Thanks for having a look, if we were to create a script, what would the "Find" be?

Getting our source system changed is an unlikely scenario unfortunately.

Hi Duncan P, Just a quick background, our current process is to copy a .data file from our source systems, there is scripting that moves that .data file to another location and renames it to a .txt file ready to import. We then use MS Access to do the necessary "Import to Table" / "te...