TM1 Forum

Hi all, I have a view currency dimension that has Top level rollup called Reporting_A and under this rollup there are two n level elements Reporting_B and Reporting_C. There is a rule in a cube that is loading data at reporting_B and Reporting_C level which shows the consolidation of that data at Re...

Hi all, I had the same issue with one of my client. It looks like if the client does not disconnect properly and next time when client tries to log in again on the same instance but server security shows the client is already "Active" and Gives message N6) Client not registered. Here is wh...

My guess is that strCurrYr = CELLGETS ( 'bpmControls', 'Value', 'Current Actual Year' ); is returning nothing. Try using "ItemReject(strCurrYr);" to test that theory - or just check in the cube itself. Can you screenshot what the view looks like after you've created it (right click on the...

Hello, I have my financial data load process to load data for one period at a time (for 2013 only) and keeping historical data in cube. I created a zero out view that had 12 months of 2013 and in my process i have a loop to keep historical data. Please see attached file for my prolog code. The proce...

Thanks all for your suggestions especially Matt. Here is what I have done and so far everything is running smoothly. I created a one time load process instead of running all period every night. That reduced Process run time significantly (55 minutes to 10 minutes of course). Secondly, I scheduled al...

Sorry i am not a developer so please bear with me if i use some non technical language here. First of all i think wrapper is a "call" process that has few processes within one process. is that right? if yes, then I have not created a separate wrapper Process for these two processes however...

I do want to mention one thing here that yesterday it took the same amount of time 55 minutes but loaded the data successfully so if there is any table lock issue then we would have same issue with cube. As i said earlier, it does not happen every day, it just happens may be couple time a week other...

Tom, I totally agree with you. Can you please post a line of code that i can use to implement this flag? I have no flag information in my SQL statement. I have attached my TI script for the cube as well. Thanks for your help!

I am sure the data source has values at that time because there is another cube that has "actual" bucket and has same ODBC process and data loads successfully in that cube with no issue at all. Secondly last week I changed the time to run the chore, just thought it might had to do with oth...

Hello, Firs of all i have Cognos Express 10.0 running on Windows server 2008 R2 Enterprise. I have weird issue going on with one of my cube. I have chore scheduled to load financial data through ODBC in "Actual" and "Budget" buckets of the cube at around 4am in the morning. Data ...

No longer Valid

Hello All, I recently had weird issue in one of my cube which was missing "budget" values for some of the key elements. There is no error recorded in log file. Data load process ran successfully through ODBC but when my Manager ran reports, she noticed there were some of the elements with ...

I have looked into event viewer of server 2008 and found following three errors: Please see below if you can help on that. Thanks 1. Log Name: Application Source: tm1sdx64 Date: 1/7/2013 12:44:14 PM Event ID: 0 Task Category: None Level: Error Keywords: Classic User: N/A Computer: The following inf...

Hello, I am going through a tough situation, Please help me on this. Here is what i am doing and facing issues. I have installed COGNOS EXPRESS 10.0 in my development server windows 2008 standard full. I have copied my production Data folder to my development server and when i change default databa...

Hello, I am going through a tough situation, Please help me on this. Here is what i am doing and facing issues. I have installed COGNOS EXPRESS 10.0 in my development server windows 2008 standard full. I have copied my production Data folder to my development server and when i change default databas...

Got it. so i used the parameter IPaddress=T as a first parameter in .cfg file and it worked. This issue happened only with my Development server which is a Virtual Machine. Thanks

Can u please post a sample configuration file. I have the same issue and struggling to get solved. I am using Cognos Express 10 . Thanks

Hello all, Please help me on this. I have one cube that has several dimensions including PERIOD dimension and one dimension call "ABC" which is basically a measure dimension that holds my flat file data and has 10 elements. The requirement is to add few more elements in "ABC" mea...

Hello experts! I need to load first time monthly ProForma data ranging from 2003 to 2020 to my existing bucket "Pro Forma". The file has months as columns for example "for each year there are 12 colmuns from JAN-DEC means for 18 years there are 216 columns". I can load data in ye...

I changed the name in .CFG file and restarted the services and it is working as i wanted. Thanks for your help