Search found 1297 matches

by Steve Rowe
Fri Oct 20, 2017 11:08 am
Forum: Cognos TM1
Topic: TM1 Turbo Debugger
Replies: 5
Views: 417

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: 366

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: 537

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: 12
Views: 385

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 ...
by Steve Rowe
Thu Sep 21, 2017 8:20 am
Forum: Cognos TM1
Topic: Unwanted TM1 dimension hierarchy levels showing up in Cognos report(Solved)
Replies: 5
Views: 221

Re: Unwanted TM1 dimension hierarchy levels showing up in Cognos report

I vaguely remember that this could happen if elements were in more than one consolidation in the dimension.
by Steve Rowe
Tue Sep 19, 2017 10:23 am
Forum: Cognos TM1
Topic: Is it possible to purge a stargate view?
Replies: 4
Views: 136

Re: Is it possible to purge a stargate view?

Also you can just put a number into the cube, this is enough to purge the cache. Unloading the cube is a bit drastic and may break the model if there are feeders.
by Steve Rowe
Fri Sep 15, 2017 8:59 am
Forum: Cognos TM1
Topic: Create hierarchy by attributes in PA
Replies: 3
Views: 147

Re: Create hierarchy by attributes in PA

I'm not convinced you will be able to see the hierarchy in TM1 Web, pretty sure it is only available in PAW and PAX. The "old" clients won't be able to see them, I'm slightly hesitant as I know they refreshed TM1 Web a little in the last release and I have not directly checked. As for your error, su...
by Steve Rowe
Wed Sep 13, 2017 10:55 am
Forum: Cognos TM1
Topic: Copying Data from Source Version to Target Version via TI
Replies: 4
Views: 208

Re: Copying Data from Source Version to Target Version via TI

Suggest you check the definition of the view in the TI then as per my previous post.
by Steve Rowe
Wed Sep 13, 2017 10:00 am
Forum: Cognos TM1
Topic: Fix Pack Releases: 10.2 Series
Replies: 45
Views: 16348

Re: Fix Pack Releases: 10.2 Series

@ckoenig

http://www-01.ibm.com/support/docview.w ... wg27049229

30 seconds of googling....at most
by Steve Rowe
Wed Sep 13, 2017 9:58 am
Forum: Cognos TM1
Topic: TI Process Doubling Elements?
Replies: 4
Views: 218

Re: TI Process Doubling Elements?

You might want to double check what is happening is not just an issue with the way you are looking at the dimension or give some more detail. You can't have an element in a single consolidation more than once, do you mean that the extant elements exist in their original location and in the CDM one. ...
by Steve Rowe
Wed Sep 13, 2017 9:47 am
Forum: Cognos TM1
Topic: Copying Data from Source Version to Target Version via TI
Replies: 4
Views: 208

Re: Copying Data from Source Version to Target Version via TI

Hi Rajesh, You should perhaps try and give some more detail. Best guess is that the view that is being used as the source for the data has been set-up to suppress ruled values (this is what you mean by links?) if un-supress this then you should find the data flows. If this does not work then it is p...
by Steve Rowe
Mon Sep 11, 2017 9:41 am
Forum: Cognos TM1
Topic: Workspace - Selector Widget Slider Timing
Replies: 3
Views: 259

Re: Workspace - Selector Widget Slider Timing

Hi Declan, That widget is really nice but we've not found anyway to control the speed. I don't think putting a "slow" widget on the page would help, I have seen situations where the selector advances before the data refreshes, though this may have been fixed in latter releases. (AmbPin, this thread ...
by Steve Rowe
Fri Sep 08, 2017 4:22 pm
Forum: Cognos TM1
Topic: PAW webpage constantly refreshing after logging in
Replies: 9
Views: 311

Re: PAW webpage constantly refreshing after logging in

codingCPA wrote:
Fri Sep 08, 2017 4:21 pm
I'm not sure what Steve means when he says "task manager" inside docker, but if you launch a powershell within the server and type the following:

docker container stats

You will get a live listing of active containers, and their cpu and memory usage.
Thanks, exactly what I meant!
by Steve Rowe
Fri Sep 08, 2017 4:21 pm
Forum: Cognos TM1
Topic: PAW error when trying to insert a report from TM1 Applications
Replies: 1
Views: 99

Re: PAW error when trying to insert a report from TM1 Applications

My first thought here is to check if TM1 Web is working correctly, if you can't see the report in TM1 Web you won't see it in PAW. The service IBM Cognos TM1 Application Server (ie. TM1 Web) must be running as well as PAW for Websheets to work (I think!)

I've not seen this message before.
by Steve Rowe
Fri Sep 08, 2017 4:16 pm
Forum: Cognos TM1
Topic: PAW workbooks stop working after change in dimension
Replies: 1
Views: 113

Re: PAW workbooks stop working after change in dimension

This is all guesswork, your are probably best raising this with IBM support. Can you say a bit more about the data grid, is it a saved view that you are just opening in PAW or a saved layout on saved PAW sheet or a saved view on a PAW sheet? Are there any (new style) hierarchies on the dimension con...
by Steve Rowe
Fri Sep 08, 2017 11:02 am
Forum: Cognos TM1
Topic: PAW webpage constantly refreshing after logging in
Replies: 9
Views: 311

Re: PAW webpage constantly refreshing after logging in

We've had this issue as well... From memory it relates to not all of the PAW services starting and being "unpacked" properly before you use PAW for the first time leading to corruption of the internal DB that PAW authenticates against. This leads the log-in screen to get stuck in loop authenticating...
by Steve Rowe
Tue Sep 05, 2017 9:33 am
Forum: Cognos TM1
Topic: Patch for JAVA vulnerabilities
Replies: 0
Views: 99

Patch for JAVA vulnerabilities

Hi, It may have passed some people by but the last two releases for 10.2 and 10.2.2 contain some patches for vulnerabilities in JAVA, as listed here here. Not being a JAVA or InfoSec specialist I'm not in a position to judge the criticality of the issues, anyone care to offer a view? Does anyone kno...
by Steve Rowe
Wed Aug 30, 2017 5:41 pm
Forum: Cognos TM1
Topic: HierarchySize Function
Replies: 4
Views: 255

Re: HierarchySize Function

BrianL wrote:
Wed Aug 23, 2017 3:17 pm
Have you tried passing 'DImensionName:HierarchyName' into DimSiz?
Thanks Brain, I can confirm that DimSiz ('DImensionName:HierarchyName' ) returns the correct information...
by Steve Rowe
Tue Aug 29, 2017 1:37 pm
Forum: Cognos TM1
Topic: PAW installation help
Replies: 10
Views: 447

Re: PAW installation help

Pretty sure what you are doing is not supported.
The windows version of PAW is only supported in Win 2016 server as this is the OS version that supports the use of docker.
by Steve Rowe
Thu Aug 24, 2017 11:55 pm
Forum: Cognos TM1
Topic: TM1 DBSW loop in VBA
Replies: 1
Views: 108

Re: TM1 DBSW loop in VBA

Pretty sure you can't do this via VBA.

If you have the skills to write VBA then you are likely better off putting the data into a csv (programmatically) and then triggering a TI to load the data (programmatically).