Search found 33 matches

by Ricky Marwan
Wed Nov 20, 2019 9:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: c# and Tm1
Replies: 5
Views: 3921

Re: c# and Tm1

Here is a quick and dirty console app to convert slice to snapshot. What you need: RestSharp EPPlus using System; using System.IO; using OfficeOpenXml; using System.Collections.Generic; using RestSharp; using RestSharp.Authenticators; using System.Text.RegularExpressions; namespace ConsoleApp1 { pub...
by Ricky Marwan
Tue Dec 10, 2013 12:35 am
Forum: Useful code, tips and tricks
Topic: Flow TM1 Rule Editor
Replies: 6
Views: 12896

Re: Flow TM1 Rule Editor

Seeing as we can't get the advanced editor working within a virtualised distribution of TM1 this looked promising, but is there any way to use it without the need for editing environment variables or running an installer? I have a tightly controlled environment which does not allow me to do either ...
by Ricky Marwan
Tue Oct 08, 2013 7:08 am
Forum: Useful code, tips and tricks
Topic: Another TM1 TOP
Replies: 53
Views: 66600

Re: Another TM1 TOP

Hi Philipp, What i meant by basic security is default TM1 Authentication where IntegratedSecurityMode in tm1s.cfg is set to 1. Check this http://pic.dhe.ibm.com/infocenter/cbi/v10r2m1/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.tm1_op.10.1.1.doc%2Fc_tm1usersandgroupssecurityoverview_n17005b.html Thanks...
by Ricky Marwan
Tue Oct 08, 2013 4:31 am
Forum: Useful code, tips and tricks
Topic: Another TM1 TOP
Replies: 53
Views: 66600

Re: Another TM1 TOP

Hi Philipp,

I personally haven't test CAM connection. Not sure why its crashing your server.
I would recommend to use basic TM1 security. I have been using it for long time with no problem.
by Ricky Marwan
Mon Sep 30, 2013 5:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: VBA AddUser/Group Refresh security
Replies: 9
Views: 5946

Re: VBA AddUser/Group Refresh security

Hi Darkhorse, You may try the code below. You need to use TM1ValStringEncrypt for password. Sub addclient() 'Declare Function TM1ClientAdd Lib "tm1api.dll" (ByVal hPool As Long, ByVal hServer As Long, ByVal sClientName As Long) As Long Dim SessionHandle As Long, ValPoolHandle As Long Dim S...
by Ricky Marwan
Wed Aug 28, 2013 3:33 am
Forum: Useful code, tips and tricks
Topic: Another TM1 TOP
Replies: 53
Views: 66600

Re: Another TM1 TOP

Could you possibly implement a command line call to export the log to a csv. We would like to have an automated way to provide some of this information to the users but we do not want them to install extra software (no matter how great it is ;-) ). This way I can pick up the csv file and put it in ...
by Ricky Marwan
Wed Apr 17, 2013 11:03 am
Forum: Useful code, tips and tricks
Topic: Another TM1 TOP
Replies: 53
Views: 66600

Re: Another TM1 TOP

Steve,

Installer size around 5mb and if i am not wrong max upload is limited 1mb.
Email me if you wish to have it via email.
by Ricky Marwan
Wed Apr 17, 2013 2:05 am
Forum: Useful code, tips and tricks
Topic: Another TM1 TOP
Replies: 53
Views: 66600

Re: Another TM1 TOP

Seems no problem with the link
alternative download link
https://docs.google.com/file/d/0B7QuHia ... sp=sharing
by Ricky Marwan
Mon Mar 25, 2013 7:36 am
Forum: Useful code, tips and tricks
Topic: Another TM1 TOP
Replies: 53
Views: 66600

Re: Another TM1 TOP

Andy Key wrote: Given that 10.1 onwards has a different default location would it be worth creating a second version pointing to that instead, or to both?
Currently i don't use TM1 10.1, not sure what the default installation path for TM1 10.1.
Thanks for the feedback, will add TM1 10.1 path for next release.
by Ricky Marwan
Wed Mar 20, 2013 9:48 am
Forum: Useful code, tips and tricks
Topic: Another TM1 TOP
Replies: 53
Views: 66600

Re: Another TM1 TOP

By default the installer will create environment variable pointing to TM1 9.5 default installation path "C:\Program Files\Cognos\TM1\bin" if your are using TM1 9.5 and installed on default location then no need to worry. For those having TM1 installed on different location other than above...
by Ricky Marwan
Wed Mar 20, 2013 8:21 am
Forum: Useful code, tips and tricks
Topic: Another TM1 TOP
Replies: 53
Views: 66600

Re: Another TM1 TOP

New Version, build using Qt no .Net Framework required If TM1 installed other than C:\Program Files\Cognos\TM1 add your TM1 bin directory to PATH environment variables or copy executable and related dlls into TM1 bin folder printscreen.png download here: http://sdrv.ms/16KJzuI Note: For those using ...
by Ricky Marwan
Sat Mar 16, 2013 11:28 am
Forum: Useful code, tips and tricks
Topic: Another TM1 TOP
Replies: 53
Views: 66600

Re: Another TM1 TOP

Hi Pawel, I plan to have all security type, but currently i don't have TM1 server configured with CAM security. I can add function to verify CAM easily, but for sure i need to test it myself before releasing the tool. If you keen to help, i can give you the tool compiled with CAM for you to test, em...
by Ricky Marwan
Thu Mar 14, 2013 2:28 am
Forum: Useful code, tips and tricks
Topic: Another TM1 TOP
Replies: 53
Views: 66600

Re: Another TM1 TOP

show75,

are you reporting bug? if so, provide me a screenshot of the error please.

check this out http://www.tm1forum.com/viewtopic.php?p=9378
by Ricky Marwan
Thu Mar 07, 2013 2:58 am
Forum: Useful code, tips and tricks
Topic: Another TM1 TOP
Replies: 53
Views: 66600

Re: Another TM1 TOP

Steve,

Thanks for the feedback, will fix the bug soon.

the settings file is located in (Win XP):
C:\Documents and Settings\<user>\Application Data\TM1 Server Monitor

you may delete the file.

cheers
by Ricky Marwan
Wed Feb 27, 2013 9:29 am
Forum: Useful code, tips and tricks
Topic: TM1 Simple Replicate
Replies: 21
Views: 25473

Re: TM1 Simple Replicate

Actually i don't want to release the CAM version as i am unable to test it myself (i don't have server using CAM to test). but i did send the same copy to mw20000 (forum user) and mw20000 able to use it without any problem. Apologies for not being able to help, you can contact mw20000, maybe he has ...
by Ricky Marwan
Sat Feb 23, 2013 5:03 am
Forum: Useful code, tips and tricks
Topic: TM1 Simple Replicate
Replies: 21
Views: 25473

Re: TM1 Simple Replicate

CAM Supported, download here.
TM1 Simple Replicate CAM.rar
(182.35 KiB) Downloaded 240 times
by Ricky Marwan
Wed Nov 28, 2012 4:54 am
Forum: Useful code, tips and tricks
Topic: TM1 Simple Replicate
Replies: 21
Views: 25473

Re: TM1 Simple Replicate

Good to hear that the tool useful out there :D
by Ricky Marwan
Wed Oct 31, 2012 6:33 am
Forum: Useful code, tips and tricks
Topic: TM1 Simple Replicate
Replies: 21
Views: 25473

Re: TM1 Simple Replicate

Hi Olivier,

Which TM1 version you use?

You may check tm1api.h for function
TM1DimensionAttributesGet( TM1P hPool, TM1V hDimension );

It shouldn't be a problem if function exists, did a test with TM1 version 9.4, 9.5.2 and 10.1
by Ricky Marwan
Wed Oct 24, 2012 10:01 am
Forum: Useful code, tips and tricks
Topic: TM1 Simple Replicate
Replies: 21
Views: 25473

Re: TM1 Simple Replicate

Sorry, currently only supported for basic connection.
I can turn it on but i don't have any servers using CAM security to test the connection.

So, come back in near future :D
by Ricky Marwan
Wed Oct 10, 2012 4:39 am
Forum: Useful code, tips and tricks
Topic: Another TM1 TOP
Replies: 53
Views: 66600

Re: Another TM1 TOP

Updated Version 1.1

- Monitor TM1 Server Message Log