Search found 6 matches

by AlexanderZ
Mon May 20, 2013 2:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exec SQL Server Jobs?
Replies: 5
Views: 71611

Re: Exec SQL Server Jobs?

There is another way to execute stored proc!
Just write on Prolog tab:

Code: Select all

ODBCOpen('sql_server', 'login', 'password');
ODBCOutput('sql_server', 'sqlquery');
ODBCClose('sql_server');
by AlexanderZ
Wed Nov 07, 2012 8:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 cube > Cognos Report Studio > BI Report
Replies: 7
Views: 9190

Re: TM1 cube > Cognos Report Studio > BI Report

I dunno about crossjoined levels, but here is pretty good article on DQM: http://www.ibm.com/developerworks/data/library/cognos/infrastructure/cognos_specific/page529.html?ca=drs- Also Dqm can be enabled in Framework manager when publishing package: http://www.ibm.com/developerworks/data/library/cog...
by AlexanderZ
Wed Nov 07, 2012 8:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 10.1 Adding Help Docs to the TM1 Application
Replies: 13
Views: 11536

Re: 10.1 Adding Help Docs to the TM1 Application

Could you please clarify several questions:
1/ what files (odf, doc, xls, etc.) can be attached?
2/ are there any limitations on file size?
3/ where files are stored after being attached?

Thanks in advance!
by AlexanderZ
Wed Jun 06, 2012 2:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 cube > Cognos Report Studio > BI Report
Replies: 7
Views: 9190

Re: TM1 cube > Cognos Report Studio > BI Report

Try this: Change settings to two parameters below in <cognos_install>\configuration\qfs_config.xml file <parameter name="UseProviderCrossJoinThreshold" value="1000"/> UseProviderCrossJoinThreshold introduces crosstab row / column edge member retrieval optimisations where the nest...
by AlexanderZ
Tue Apr 17, 2012 2:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 WorkFlow-->Urgent..Help Needed...
Replies: 3
Views: 3119

Re: TM1 WorkFlow-->Urgent..Help Needed...

Oliver,

Can you explain in detail what you mean
oliver sullivin wrote:assign a task to a different user.
Do you mean something like changing the user for the task?

Thanks in advance.
by AlexanderZ
Fri Apr 13, 2012 3:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Changing Default Actions for TM1 Workflow...
Replies: 3
Views: 2751

Re: Changing Default Actions for TM1 Workflow...

Hi,
Did changes in java code helped and where you (or your friend) have made them?

Thanks in advance.