Search found 1313 matches

by Steve Rowe
Wed Nov 22, 2017 9:24 am
Forum: Cognos TM1
Topic: Questions for Code editor (TI/Rule)
Replies: 7
Views: 343

Re: Questions for Code editor (TI/Rule)

Hi Thomas, would you mind giving some more detail on the use case for active form client memory runaway?
by Steve Rowe
Tue Nov 14, 2017 5:14 pm
Forum: Cognos TM1
Topic: after Cube optimization -> TI won't run
Replies: 7
Views: 264

Re: after Cube optimization -> TI won't run

You're using commands like ViewRowDimensionSet(sCube, sqView, sDim, 1); these are redundant when building a view to be used as a datasource (in my experience), on the basis that less code is better you could try removing them. My personal preference would be to destroy the subsets if they exist rath...
by Steve Rowe
Mon Nov 13, 2017 2:01 pm
Forum: Cognos TM1
Topic: after Cube optimization -> TI won't run
Replies: 7
Views: 264

Re: after Cube optimization -> TI won't run

Not an issue that I have ever come across so I guess it is could be a problem with the specific fix pack you are on. Do you create the view from scratch in the TI or is it a permanent object that existed from before re-ordering? I always build from scratch, if you are working from a permanent object...
by Steve Rowe
Mon Nov 13, 2017 9:37 am
Forum: Cognos TM1
Topic: after Cube optimization -> TI won't run
Replies: 7
Views: 264

Re: after Cube optimization -> TI won't run

Are you 100% sure that this TI ran before the cube was re-ordered?

99.9% of the cases of TIs "not running" are because they have a C level in them and the view definition has Suppress consolidations checked.
by Steve Rowe
Fri Nov 10, 2017 12:18 pm
Forum: Cognos TM1
Topic: Name of subset using in view
Replies: 4
Views: 466

Re: Name of subset using in view

You can process the relevant .vue file and extract it from this, there is no direct way function based way that I know of.
by Steve Rowe
Thu Nov 09, 2017 5:19 pm
Forum: Cognos TM1
Topic: Tool to analyse TM1 web dumps
Replies: 2
Views: 176

Re: Tool to analyse TM1 web dumps

Hi Jamie, I don't have a direct answer for you but our experience suggests that majority of crashes are because TM1 Web is running out of memory. The main cause of this tends to be. 1. The shipped default is too low, it should be increased. 2. Too much white space in an excel sheet. The white space ...
by Steve Rowe
Fri Nov 03, 2017 1:06 pm
Forum: Cognos TM1
Topic: Planning Analytics Perspectives Issue
Replies: 9
Views: 1191

Re: Planning Analytics Perspectives Issue

Pretty sure that they both can't be loaded in Excel at once but you don't have to uninstall PAx It works for a while but for example if you try and slice from a perspectives cube viewer with PAx loaded but not connected then the slice fails. From our experience perspectives works fine if you don't h...
by Steve Rowe
Thu Nov 02, 2017 1:12 pm
Forum: Cognos TM1
Topic: DimensionSecurity Rules not being fired
Replies: 11
Views: 332

Re: DimensionSecurity Rules not being fired

I've seen issues in the past with "stuff" that hangs off the }Dimensions dimension. My understanding of the trigger for this is that the }Dimensions dimension can be fully deleted and rebuilt under some circumstances, like a restart. I hit this once a long time ago with some attributes on the }Dimen...
by Steve Rowe
Thu Nov 02, 2017 9:54 am
Forum: Cognos TM1
Topic: static subsets saved disappears
Replies: 6
Views: 262

Re: static subsets saved disappears

As well as the delete mentioned by Tom you can see issues in this space if you delete and recreate an alias that is being used by the subset
by Steve Rowe
Thu Nov 02, 2017 9:51 am
Forum: General
Topic: Email has been disabled
Replies: 2
Views: 180

Re: Email has been disabled

Thanks for your efforts Martin
by Steve Rowe
Wed Nov 01, 2017 2:14 pm
Forum: Cognos TM1
Topic: TM1 process in chore starts with 2 min delay
Replies: 2
Views: 100

Re: TM1 process in chore starts with 2 min delay

Also check the time on the server is the same as the time on the client. I suspect what you are seeing is just a time difference between the client and the server.
by Steve Rowe
Wed Nov 01, 2017 2:12 pm
Forum: Cognos TM1
Topic: Problem after upgrading from TM1 10.2.2 to 10.3
Replies: 3
Views: 234

Re: Problem after upgrading from TM1 10.2.2 to 10.3

Obviously sounds odd, have you checked if you have a formatting issue? Which client environment are you seeing the issue and what formatting is in place?

If you look in the transaction log what value is being written to the cube?
by Steve Rowe
Mon Oct 30, 2017 1:53 pm
Forum: Cognos TM1
Topic: Child Elements are not visible under consolidations
Replies: 14
Views: 362

Re: Child Elements are not visible under consolidations

Hi this is not an issue but expected behaviour. The no-named subset view of a dimension you get when you open the subset editor is the natural underlying order of the dimension, which by default is I think the order in which the elements were added. You can fix the natural order of the dimension in ...
by Steve Rowe
Mon Oct 30, 2017 1:47 pm
Forum: Cognos TM1
Topic: Adding a subset to a dbrw
Replies: 7
Views: 370

Re: Adding a subset to a dbrw

Isn't this functionality just a hack? There should only be one way to return a number from TM1 and that is via a reference to a dimension member. Otherwise you lose control of what results the system is returning. This is one of the main reasons that companies move from spread sheets to systems, one...
by Steve Rowe
Mon Oct 30, 2017 12:11 pm
Forum: Cognos TM1
Topic: MDX using TI Parameters
Replies: 3
Views: 141

Re: MDX using TI Parameters

Yup, just concatenate the vars into the MDX string

Code: Select all



sMDX='{FILTER({TM1FILTERBYLEVEL( 
{TM1SUBSETALL( [Period] )}, 0)}, 
[Config_JPS].( [Year].[' | sYear |'], [Scenario_Plan].[' | sScenario |'], [Config_Measure].[Source]) > 0 )}'

SubsetCreateByMDX (SubNameSRC, sMDX);

by Steve Rowe
Tue Oct 24, 2017 1:15 pm
Forum: Cognos TM1
Topic: Cognos Integration Server
Replies: 1
Views: 114

Re: Cognos Integration Server

Bumped as posted in the wrong forum, Stefan, please post in the correct forum.
by Steve Rowe
Fri Oct 20, 2017 11:08 am
Forum: Cognos TM1
Topic: TM1 Turbo Debugger
Replies: 7
Views: 661

Re: TM1 Turbo Debugger

Hmmm, I suspect that the support person is speaking out of turn here. The TI Debugger was developed by an individual in IBM, not by an external person with a desire to improve our lot. It is also mentioned as a feature in many IBM presentations that I have attended. It's pretty rich to then claim th...
by Steve Rowe
Fri Oct 06, 2017 8:15 am
Forum: Cognos TM1
Topic: Improve TI process time for cubes with heavy rules
Replies: 11
Views: 463

Re: Improve TI process time for cubes with heavy rules

With a ten minute refresh by design your very close to wanting the system "always live" anyway, why use a TI instead of rules? Is the issue with the performance of the TI just the elapsed time or the fact that it is locking? If it always takes 3 minutes to run and is non-locking your data is still u...
by Steve Rowe
Wed Oct 04, 2017 4:52 pm
Forum: Cognos TM1
Topic: Active Form Drill down help
Replies: 9
Views: 577

Re: Active Form Drill down help

A solution If you gave every element you want visible in the active form an available flag and then put MDX referencing this in the report row formula and disabled drill down in the report row formula then you would get close to this. Report would need to have all rows expanded to the level of inter...
by Steve Rowe
Fri Sep 22, 2017 10:42 am
Forum: Cognos TM1
Topic: Undo after save in Excel 2016 with TM1 add in
Replies: 15
Views: 626

Re: Undo after save in Excel 2016 with TM1 add in

Hi, Just wanted to note that we have not been able to reproduce. Excel 2016 MSO(16.0.8326.2076) Version 1707 which I think is the version being reporting but on an ordinary Office install, so not Office 365. TM1 Perspective version PA 2.0 Refresh Pack 2 (11.0.00200.998) Windows Server 2016 Standard ...