Unable to Write to Cubes

[konjis1]

My co worker and I are running into an issue. We are currently transitioning from TM1 Enterprise 9.1.4 to Cognos Express 10.2.1. We have configured all ODBC connections and have run into an issue. We both have Admin rights to do everything within TM1/CE, but when we run a chore the Zero Out function occurs successfully, but we are unable to write to the cubes. It is acting as if we do not have permissions. We do not see the records processing during the run of the chore (which houses 4 processes). Within TI we can preview the data, so we know the connection to the source is good. When we copied over Cube data from our existing instance, the data is viewable in the new environment, but when we run the chore the zero happens and data is not replaced. Please help!

[tomok]

When you start a new thread try to make the title appropriate to the actual problem. The problem Is not that you can't write to a cube, it's that your TI process(es) are not loading data. The first thing that comes to mind is security to the ODBC source. Are you connecting to SQL Server? Are you using SQL security (meaning you are providing the ID and password as part of the TI parameters, or are you using Windows Authentication (meaning your ID automatically has rights to SQL Server? If the latter,does the account the TM1 service is running under have the same rights to the SQL server? Try running one the processes individually. Do you get an error message>? What is it?

[konjis1]

Tom,

Sorry about the title. As for our issue, we are providing the ID and password to the source (Oracle 11g) within TI. We are able to verify the connection through the Preview on TI as well. Still though, no data is writing to the cube when the process is ran. Are there other avenues you suggest?

[tomok]

Have you tried either checking or unchecking the "Use Unicode" radio button on the Data Source tab? Sometimes this can fix problems with Oracle data sources in TI.

[Alan Kirk]

Tom,

Sorry about the title. As for our issue, we are providing the ID and password to the source (Oracle 11g) within TI. We are able to verify the connection through the Preview on TI as well. Still though, no data is writing to the cube when the process is ran. Are there other avenues you suggest?

Unless you are opening the TI on the server box, using the same Windows login that is used to run the TM1 server, you're not verifying anything at all in the preview. It could be that the ODBC connection is not in fact set up on the server but is set up where your client is running. It could be that it's been set up as a user DSN instead of a system DSN. It could be that the drivers are not installed properly on the server but are on your client side.

The way you confirm that the connection really is good is to do an ASCIIOutput on the Data tab. My bet is that you'll get nothing in that file. If you don't, that's telling you that you aren't getting data from the connection, and that that's where your problem is.

If the file does contain data on the other hand, then it's time to start looking at whether the data is being written to and whether you have any issues with that (rules based cells, etc) though if that were the case I'd expect that you should have an error log.

Tomok beat me to the Unicode checkbox issue but I agree that's a known issue with Oracle datasources and should definitely be tried as well.

[konjis1]

Thanks to the both of you for the information. By checking "Unicode" it allowed for the data to be loaded!