TM1 Forum

Thanks for this and it looks good so far and I do have a couple of enhancements in mind.

Cheers
Afshin

Interesting and a curly one,

What is the value <client id="thinClient"> in
in pmpsvc_config.xml in the folder Apache Software Foundation\Tomcat 6.0\webapps\pmpsvc\WEB-INF\configuration ?

You will also find "IBM Cognos TM1 Backup and Recovery Guide" from the IBM Developer Works helpful !!

"Steps: 1) take back of dev data folder 2) delete the data directory objects from folder 3) copy data objects from prod and paste it in dev" "I noticed that Views that are built in prod are lost when i refreshed the data from Prod to dev- could you please comment." At no point yo...

Although not officially supported, Excel 2010 and CX 9.5.1 work perfectly, we have had a few minor issues with Active Forms.
At this stage IBM has its hands full with TM1 10 and the push to integrate it into CX suggests H1 2012 is a bit far fetched.

Another way possibly you could do this is call a stored procedure using TI wherein you pass the measures, dimension as parameters and then issue the commit statement in the Epilog via another stored procedure.

I have never done this but I am sure this would work.

Andy,

This is a known issue and had IBM Support send us the file and the issue was resolved.
Backup the registry just in case and or take a snapshot and test before you deploy.

Cheers
Afshin

Dear All,

I was hoping if somebody could please post a complete sample code with regards to import into a GridView in a ASP.NET page with preferably the ASP .NET code as well.

And some more commentary on DO's and Don't with regards to the approach.


cheers
afshin

Sorry I hit the button too soon,

what I was trying to convey was and every time the user access a workbook from the tm1 applications folder it opens in an another window where in the TM1 addin is not enabled.

G'Day, I understand that 9.5.1 is not officially supported with Excel 2010 however we have tested the same and have deployed it for a 2 users as a pilot group before we rolling it out to other users in a Dev environment. Whilst both the user faces no problems connecting to TM1 using Perspectives. On...

Lotsa , further to your comment "Set TM1RebuildOption to the appropriate value for the use case of the particular report (usually False IMO)" . Appreciate your and everybodys thoughts on this one. A couple of our Excel Sheets ( Accessed via TM1 Applications), open and retrieve from our cli...

It would be great if you could let us know how you got on ? I am working on something like this as well. Some of our users are complaining that perspectives is slow ( templates open in approx 10 seconds ).

Hi Anthony, I would ask the resident Oracle DBA to have a look at the issue before looking at flat files etc. This could largely be due to size of redo logs, rollback contention, indexes etc. I suggest you ask the DBA to execute dbms_system.set_sql_trace_in_session(170, 590, true); to understand the...

Try this . CREATE OR REPLACE FUNCTION GetData (p_parameter IN table_name.fieldname%TYPE) RETURN sys_refcursor IS c1 sys_refcursor; BEGIN OPEN c1 FOR SELECT * FROM yourtable where column=p_parameter return c1; END GetData ; your Query should be select GetData (???) from dual and use the prolog to pas...

lookup PowerShell

and particular this website.

http://msmvps.com/blogs/richardsiddaway ... -file.aspx

cgywin is another option !!

Hello All, Our client is not in favour of using the right click option in Perspectives to do Relative Proportional Spread or Relative Percent Adjustment. Hence I was hoping if we could use the VB API options to automate the Relative Proportional Spread and Relative Percent Adjustment in Perspectives...

FYI ..

Trick is to change the IntegratedSecurityMode = 1 then assign the administrator user created by Cognos Express to the admin group in TM1 and then change it back in IntegratedSecurityMode = 5.

Hi All, I have successfully installed the latest Cognos Express 9.5 on WIN 2008 Server Release 2. While I do have an Cognos Express administrator account created and can log onto the TM1 Server. I cannot seem to create TI objects or dimensions in Cognos Express. I suspect this is largely because the...

Certainly Looks interesting and will play with it, Whats yr opinion so far ? "BOARD International, the global leader in the Business Intelligence (BI) and Corporate Performance Management (CPM) toolkit space, announces that it has been positioned in the Gartner 2011 Magic Quadrant for Business ...

Thanks for the solution an absolute beauty, somebody must have read my mind. I was tearing my head over this just yesterday and decided to give it a go after the caffeine kicked in. Maybe I just need a beer now.

Cheers to all ..