Search found 122 matches

by image2x
Mon Nov 16, 2015 5:35 pm
Forum: Cognos TM1
Topic: Cafe VBA TM1 Automation
Replies: 1
Views: 829

Re: Cafe VBA TM1 Automation

As I've yet to find an official method to automate Cafe login and refresh with TM1 objects, I had to go down the emulation path. Below are two AutoIT scripts that get the job done. The first is the actual Cafe refresh script while the second is for maintaining a username/hashed-password .ini file (n...
by image2x
Wed Nov 11, 2015 11:34 pm
Forum: Cognos TM1
Topic: Cafe VBA TM1 Automation
Replies: 1
Views: 829

Cafe VBA TM1 Automation

Is Cafe's VBA automation only for BI objects and not for TM1 worksheet objects/references like dbrw's and flexviews?

The documentation does not make this distinction but the login function appears to want a BI server reference and not a TM1 app server URL.

Please tell me this is not true!

Thanks.
by image2x
Mon Mar 16, 2015 9:01 pm
Forum: Cognos TM1
Topic: Fix Pack Releases: 10.2 Series
Replies: 45
Views: 17041

Re: Fix Pack Releases: 10.2

kangkc wrote:Interim fix IF4 is available which will solve this problem. Not sure this is available on fix central for download.
Can you please confirm that it's IF4? Our support rep is saying IF2 is the latest. Thx.
by image2x
Mon Jan 26, 2015 3:51 pm
Forum: Cognos TM1
Topic: TM1Web 10.2 Subset Editor "Basic" View
Replies: 0
Views: 882

TM1Web 10.2 Subset Editor "Basic" View

I don't have high hopes for a resolution to this but thought I'd throw it out there. We're getting ready to move a large population (700+) TM1Web users from 10.1 to 10.2.2. These users make heavy use of customized subsets which they change between frequently. In 10.1 and prior, users were able to qu...
by image2x
Mon Jan 19, 2015 5:00 pm
Forum: Cognos TM1
Topic: Does SubsetMDXSet Work?
Replies: 3
Views: 2197

Re: Does SubsetMDXSet Work?

Yes, thank you lotsa... that was it. I'm used to Unix commands where optional parameters mean optional!
by image2x
Fri Nov 28, 2014 6:35 pm
Forum: Cognos TM1
Topic: Does SubsetMDXSet Work?
Replies: 3
Views: 2197

Does SubsetMDXSet Work?

I'm testing TM1's 10.2.2 FP1 undocumented SubsetMDXSet function ( see http://www-01.ibm.com/support/docview.wss?uid=swg27042401 ) and thus far cannot get it to function as documented: ### total_lvl_0_w_alias vDim = 'Legal_Entity'; vMdx = '{[legal_entity].[Total Company],TM1SORT( {TM1FILTERBYLEVEL( {...
by image2x
Thu Jul 17, 2014 9:21 pm
Forum: Cognos TM1
Topic: CAFE: "Formula mode required registration ..."
Replies: 3
Views: 2634

CAFE: "Formula mode required registration ..."

Can anyone shed light on this Cognos CAFE message: "Formula mode required registration and will not work until Excel is restarted" I've only been working with CAFE for a couple of days and get this message roughly half the time when clicking the IBM Cognos button. I have, BTW, added in the TM1 speci...
by image2x
Mon Jul 14, 2014 10:57 pm
Forum: Cognos TM1
Topic: TM1 Web: User "Log Out" does not return to Login Screen
Replies: 12
Views: 4784

Re: TM1 Web: User "Log Out" does not return to Login Screen

BTW, I found this in tm1web_config.xml which seems tantalizingly close to what I wanted, but alas, it doesn't appear to apply to CAM security:

Code: Select all

   	<!-- LogoutUrl to be executed after logout normally completes-->
	<add key="CustomCAMLogoutUrl" value="" />
by image2x
Fri Jul 11, 2014 2:11 pm
Forum: Cognos TM1
Topic: TM1 Web: User "Log Out" does not return to Login Screen
Replies: 12
Views: 4784

Re: TM1 Web: User "Log Out" does not return to Login Screen

Thanks for the confirmation... I'll open a ticket with IBM.

-- John
by image2x
Thu Jul 10, 2014 2:54 pm
Forum: Cognos TM1
Topic: TM1 Web: User "Log Out" does not return to Login Screen
Replies: 12
Views: 4784

TM1 Web: User "Log Out" does not return to Login Screen

I was hoping someone might have a solution to or can confirm the following behavior in their environment. Environment: TM1 10.2.2 with Cognos CAM security (mode 5) Behavior: 1) User is logged into TM1 Web 2) User session time's out or user clicks "Log Out" 3) User is redirected to what I believe is ...
by image2x
Fri Jun 06, 2014 7:29 pm
Forum: Cognos TM1
Topic: Multiple Portals in variables_tm1.xml
Replies: 2
Views: 938

Re: Multiple Portals in variables_tm1.xml

Trying to do the same thing... did you or anyone else ever get this figured out?

Thanks,

-- John
by image2x
Fri Apr 18, 2014 10:13 pm
Forum: Cognos TM1
Topic: Tops-down child/parent dimension export
Replies: 8
Views: 1294

Re: Tops-down child/parent dimension export

Hey Wim, Nice to chat with one of the TM1 legends. :) As for the pFirst check, I've actually found it useful to be able to disable the file delete. For example, if you want to export two different consolidated members of the same hierarchy, you run the export on the first member and then pass in pFi...
by image2x
Fri Apr 18, 2014 6:44 pm
Forum: Cognos TM1
Topic: Tops-down child/parent dimension export
Replies: 8
Views: 1294

Re: Tops-down child/parent dimension export

Instead, you need a starting script which does the AsciiDelete and then kicks off the process. Or one additional parameter, like pMode, set to 1 initially. When doing a next call to the process, set the pMode = 0. In the code, test if pMode = 1. If yes, AsciiDelete. If not, no AsciiDelete. Yes, goo...
by image2x
Fri Apr 18, 2014 6:20 pm
Forum: Cognos TM1
Topic: Tops-down child/parent dimension export
Replies: 8
Views: 1294

Re: Tops-down child/parent dimension export

One important callout is that you do need to delete the output file before calling the process: Can you use the AsciiDelete function? Not in this case as the process calls itself repeatedly and the text file needs to persist. Instead, you need a starting script which does the AsciiDelete and then k...
by image2x
Fri Apr 18, 2014 3:58 pm
Forum: Cognos TM1
Topic: Tops-down child/parent dimension export
Replies: 8
Views: 1294

Tops-down child/parent dimension export

I thought I'd share the following process as I wasn't able to find anything in the archive that quite fit the bill. Objectives: 1) For a given consolidated member and its descendants, output: Child, Parent, Child_Alias, Weight 2) Output in a tops-down manner where parents are always defined before c...
by image2x
Tue Sep 25, 2012 9:22 pm
Forum: Cognos TM1
Topic: "15","E15) Server unable to listen on port
Replies: 3
Views: 1638

Re: "15","E15) Server unable to listen on port

Probably a dumb question, but have you confirmed that the processes (both tm1s.exe and the shared memory reader) are actually dead?

An 'lsof -i:11446' may also yield useful information.

What Unix are you running?

-- John
by image2x
Thu Jul 19, 2012 5:12 pm
Forum: Cognos TM1
Topic: How to Disable Taking Ownership in a Central Application
Replies: 4
Views: 1512

Re: How to Disable Taking Ownership in a Central Application

*bump*

Same question. Anyone found a way?

Thanks.
-- John
by image2x
Thu Mar 15, 2012 7:16 pm
Forum: Cognos TM1
Topic: TM1 10.1 - Trace Calculation behaviour
Replies: 16
Views: 2927

Re: TM1 10.1 - Trace Calculation behaviour

+ 1 for seeing this in the wild.

Thanks for pointing out the trace and drill work around.
by image2x
Tue Feb 28, 2012 4:00 am
Forum: Cognos TM1
Topic: TM1 Web Load Balancing
Replies: 9
Views: 3008

Re: TM1 Web Load Balancing

So fundamentally, two separate web servers with TM1 web components cannot connect to the same TM1 instance?
by image2x
Mon Feb 27, 2012 8:26 pm
Forum: Cognos TM1
Topic: TM1 Web Load Balancing
Replies: 9
Views: 3008

TM1 Web Load Balancing

I'd like to hear people's thoughts and hopefully experiences with load balancing the web-tier in TM1 environment. I know TM1, as a data store, doesn't support clustering or load balancing (not counting replication). Is it possible for the web tier? Possible LB options (1) Active-Active: Would LB nee...