Search found 1294 matches

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: 11
Views: 201

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

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

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

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

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: 44
Views: 15944

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

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

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

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

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

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

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

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

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

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: 6
Views: 297

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

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).
by Steve Rowe
Wed Aug 23, 2017 3:04 pm
Forum: Cognos TM1
Topic: HierarchySize Function
Replies: 4
Views: 231

HierarchySize Function

Anyone seen the equivalent of DimSiz for Hierarchies?

HierarchySize or HierarchySiz doesn't compile and I can't see any other likely candidates.

Anyone spotted the function?
by Steve Rowe
Fri Aug 04, 2017 3:24 pm
Forum: Cognos TM1
Topic: Feeders - for conversion rule
Replies: 8
Views: 436

Re: Feeders - for conversion rule

For speed efficiency consider putting an additional measure in your exchange rate cube to calculate the average (((DB('Exchange Rates', 'Actual', !Currencies, !Currency, 'Ending Rate', !Months))+(DB('Exchange Rates', 'Actual', !Currencies, !Currency, 'Ending Rate', ATTRS('Months', !Months, 'Prior'))...
by Steve Rowe
Thu Aug 03, 2017 2:12 pm
Forum: Cognos TM1
Topic: Need Help in coding
Replies: 5
Views: 239

Re: Need Help in coding

Maybe zero suppression would just do this?