TM1 Forum

We checked it in Computer Management there is no user having the csv file open. But when we try to restart the TM1 Application Server, the file is now available to be overwritten.

We checked it in Computer Management there is no user having the csv file open. But when we try to restart the TM1 Application Server, the file is now available to be overwritten.

Is there anyway to determine if a TI process is keeping the file open. Cause we had an instance where the user is trying to override the source file but we're getting an error that the file is opened by another program. There was no running TI process so we were unable to kill the process. When we s...

I was trying to publish this Cognos Insight file to TM1 portal but I'm getting this error and I can't figure out why. I check the views there and made sure the views are using the approval hierarchy.

I was able to find a IBM article on how to create a csv file with a list of the dimensions and what cubes are using the dimensions. I was wondering if anybody has tried to do this but determining the which dimension are being used as a picklist. Just for maintenance purposes, I was just wondering if...

Anybody encountered this problem when installing IBM Cognos Express 10.1? I've browse the web for similar problems and I haven't come across anyone with the same problem....Only the advisor & planner won't install. I've done check relevant issues from previous versions like checkin the IIS and ....

I'm not passing any parameter nor local variables. Yes the preview box contains data and I was able to set additional variable in the variables tab and write the query in the Advance Tab. I even tried to use the same query to create a new dimension and use 1 variable in the query as my element and I...

tables are the same just the source database I've been given access to. I usually do my SQL Query in SQL Management Server and then copy it to TM1 its easier that way. I'm able to preview the Query but when it comes to uploading the data to the TM1 Cube I get that error. Its something new for me to ...

Prometrics will provide the actual score output then I think Prometrics registers your email you provide.You have to log in to IBM website to request for them to send you the PDF copy of the Certificate or you can request the Actual certificate with corresponding fees for it to be sent to you. I'm n...

This is a first time error. My source changed so I had to change my query for loading data to my TM1 Cube and I got this error. 1824 [2] ERROR 2012-09-12 07:04:55.727 TM1.Process Process "LOAD_Commission_MKT_1": : Execution was aborted. Error file: <TM1ProcessError_20120912070455_LOAD_Comm...

Does anybody know a any good tips to use TM1 attributes in Cognos BI Reports? Cause I'm doing a chart with that filters the data using TM1 attributes? When I do this the calculated value disappears and only inputted values are the only ones that display in the charts. When I create a crosstab and tr...

I'm just doing a chart report in BI using TM1...just found it a bit odd that calculated values in TM1 doesn't appear in the BI reports. Only inputted value appears in chart.

Just wondering...if anybody encountered this problem before. I'm trying to log into the TM1 Contributor Application as a user but every time I log in I get this error. I know its how I set the CAM security that's causing the problem but I'm not sure what. I have no problem logging in the Server Expl...

Thanks Steve for pointing that out....Thanks everyone for the help.

Was expecting the elements of the datapoint of those values to appear and not the dimension name.

There's something wrong with how the TI function: Code 1 Prolog: # DEFINE CUBE SOURCE***** DatasourceNameForServer = vCubeName; DatasourceNameForClient = vCubeName; #DESTROY IF ALREADY AVAILABLE CUBE VIEW SOURCE IF(ViewExists(vCubeName, vCubeName|' - '|pViewName)=1); ViewDestroy(vCubeName, vCubeName...

Hi Alan....

Sorry...its just this is something I have never tried out of doing and I was wondering if there is another function that would be easier than looping through a hundred 100 dimensions. Thanks for you utmost patience with me.

Is there anyway to create a TI that would output specify the number of dimensions in a cube? Im just thinking if its possible to create a TI process that loops through all the cubes and output a text file for each cube.

Would it even be possible to create a single TI to do this for all cube?

Is it possible to run a process or chore outside TM1?

Can you write a script in Command Prompt that calls process outside TM1?

Tried both your suggestion and it doesn't seem to work.