Search found 269 matches

by appleglaze28
Wed Feb 10, 2016 1:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI processing locking file
Replies: 7
Views: 1967

Re: TI processing locking file

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.
by appleglaze28
Wed Feb 10, 2016 1:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI processing locking file
Replies: 7
Views: 1967

Re: TI processing locking file

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.
by appleglaze28
Wed Jan 27, 2016 2:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI processing locking file
Replies: 7
Views: 1967

TI processing locking file

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...
by appleglaze28
Mon Jun 24, 2013 2:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Approval hierarchy in the source view should not be unmapped
Replies: 1
Views: 962

Approval hierarchy in the source view should not be unmapped

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.
by appleglaze28
Thu Jun 13, 2013 3:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: List Measure Dimensio using Dimensions or Subset as Picklist
Replies: 4
Views: 1388

List Measure Dimensio using Dimensions or Subset as Picklist

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...
by appleglaze28
Tue Oct 23, 2012 9:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Express 10.1 Installation Error - SDK-ERR-0064 & 0095
Replies: 0
Views: 558

Express 10.1 Installation Error - SDK-ERR-0064 & 0095

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 .Net ...
by appleglaze28
Wed Sep 12, 2012 9:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error in SQL Query
Replies: 6
Views: 1508

Re: Error in SQL Query

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...
by appleglaze28
Wed Sep 12, 2012 9:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error in SQL Query
Replies: 6
Views: 1508

Re: Error in SQL Query

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 ...
by appleglaze28
Wed Sep 12, 2012 8:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Certification Certificate
Replies: 2
Views: 712

Re: TM1 Certification Certificate

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...
by appleglaze28
Wed Sep 12, 2012 7:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error in SQL Query
Replies: 6
Views: 1508

Error in SQL Query

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_Commission_MKT...
by appleglaze28
Thu Jun 14, 2012 2:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Attributes in Cognos BI Report
Replies: 0
Views: 839

TM1 Attributes in Cognos BI Report

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...
by appleglaze28
Thu Jun 14, 2012 2:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Missing Values in BI Chart
Replies: 0
Views: 442

Missing Values in BI Chart

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.
by appleglaze28
Fri May 18, 2012 8:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM Cognos TM1 Application:Could not connect to TM1 Server
Replies: 3
Views: 4009

IBM Cognos TM1 Application:Could not connect to TM1 Server

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...
by appleglaze28
Mon Feb 27, 2012 9:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating Textfile for all Cubes
Replies: 13
Views: 2045

Re: Creating Textfile for all Cubes

Thanks Steve for pointing that out....Thanks everyone for the help.
by appleglaze28
Mon Feb 27, 2012 9:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating Textfile for all Cubes
Replies: 13
Views: 2045

Re: Creating Textfile for all Cubes

Was expecting the elements of the datapoint of those values to appear and not the dimension name.
by appleglaze28
Mon Feb 27, 2012 8:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating Textfile for all Cubes
Replies: 13
Views: 2045

Re: Creating Textfile for all Cubes

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...
by appleglaze28
Mon Feb 27, 2012 3:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating Textfile for all Cubes
Replies: 13
Views: 2045

Re: Creating Textfile for all Cubes

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.
by appleglaze28
Mon Feb 27, 2012 3:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating Textfile for all Cubes
Replies: 13
Views: 2045

Creating Textfile for all Cubes

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?
by appleglaze28
Thu Feb 23, 2012 9:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Chore or Process run outside TM1
Replies: 1
Views: 556

TM1 Chore or Process run outside TM1

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

Can you write a script in Command Prompt that calls process outside TM1?
by appleglaze28
Thu Feb 23, 2012 7:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unload Cube
Replies: 4
Views: 3169

Re: Unload Cube

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