Search found 27 matches

by yyround
Tue Aug 25, 2020 3:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What would you do: creating year, month, day dimension separately in the cube or create them in one dimension
Replies: 2
Views: 1910

What would you do: creating year, month, day dimension separately in the cube or create them in one dimension

Hi All, I use year, month, day as an example but in real case, it is for a business structure where the "Month" equivalent level has 20-30 possibilities and for the "day" equivalent level, the number of members is increased when a new item is added by the user. Our external devel...
by yyround
Sun Aug 25, 2019 5:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: loading fields from csv without knowing the type of value
Replies: 6
Views: 11595

Re: loading fields from csv without knowing the type of value

Thanks guys for all your advices.

I guess we will have to get the notes dB to send a separate metadata file along with the data file.

Regards
YY
by yyround
Thu Aug 22, 2019 10:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: loading fields from csv without knowing the type of value
Replies: 6
Views: 11595

loading fields from csv without knowing the type of value

Hi TM1 Gurus, I stumble upon this when try to create a TI that loads the data (a csv file contains header and the data from second row and onwards) into a cube. Data comes from an external Notes server. The number of columns varies, although it shouldnt happen very often but once a while, there coul...
by yyround
Thu Aug 08, 2019 2:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Examples of GET/DELETE/PATCH applications in REST
Replies: 1
Views: 1723

Re: Examples of GET/DELETE/PATCH applications in REST

Thanks for sharing.

Looking forward to more of the RESTAPI tips:).

Regards
YY
by yyround
Thu Aug 08, 2019 3:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Loggers on what websheet has been opened by who and when
Replies: 11
Views: 8790

TM1 Loggers on what websheet has been opened by who and when

Hi All,

Can you tell me whether there is a TM1 logger that logs the info of what websheet has been opened by who and when?

We don't have pulse but wondering how does pulse tracks that?

Thank you so much
YY
by yyround
Wed Mar 13, 2019 11:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: JAVA Extension
Replies: 9
Views: 5506

Re: JAVA Extension

Thanks EvgenT,

The problem is we are not going to move to PA anytime soon and we need to deliver something within a few months that requires the statistical ad finacial functions.

Also we are not familar with Python but used Java before so thought we will give it a try.

Regards
Y
by yyround
Tue Mar 12, 2019 12:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: JAVA Extension
Replies: 9
Views: 5506

JAVA Extension

Hi, I followed the steps in this link to explore java extension. https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_turb.2.0.0.doc/c_tm1_enabling_configuring_java_extensions.html when I tried to resart the server, i received "Error 1067: The process terminated un...
by yyround
Fri Jul 06, 2018 1:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form Performance in Excel and tm1 web
Replies: 1
Views: 1507

Re: Active Form Performance in Excel and tm1 web

Further to my previous post, I think I should fine-tune my question. I want to understand how data is transferred between the following: TM1 server and TM1 web; TM1 server and TM1 client (perspective); Particularly with TM1 client, say when user requested to view an active form with filtering, what ...
by yyround
Fri Jul 06, 2018 1:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form Performance in Excel and tm1 web
Replies: 1
Views: 1507

Active Form Performance in Excel and tm1 web

Hi, I was just wondering why the same active form runs a lot longer in excel than in web? With the filter i put in, the active form returns 2000+lines, but excel takes about 30-40 seconds while in web it is so swift scrolling down to the bottom of the form. I check my memory and cpu usage, it is far...
by yyround
Wed May 16, 2018 11:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Filtered by string measure in a 3 dimension cube
Replies: 12
Views: 6825

Re: Filtered by string measure in a 3 dimension cube

Thank you all for your help.

Much appreciated!

YY
by yyround
Mon May 14, 2018 11:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Filtered by string measure in a 3 dimension cube
Replies: 12
Views: 6825

Filtered by string measure in a 3 dimension cube

Hi all, I am wondering whether anyone has come across a situation like this: There is Cube with 3 dimensionS, Dim1, Dim2, DimMeasure. There is a string Measure element under DimMeasure lets called it StrMeasure. StringMeasure is only recorded in the N level elements of Dim1 and Dim2. Now I want to l...
by yyround
Fri Oct 13, 2017 1:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Seeking idea for users management in multiple instances
Replies: 7
Views: 4717

Re: Seeking idea for users management in multiple instances

Hi Mark,

Awesome!
That is very detailed and thanks a lot for your time and patience. I will bring it back for discussion.

Regards
YY
by yyround
Tue Oct 10, 2017 1:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Seeking idea for users management in multiple instances
Replies: 7
Views: 4717

Re: Seeking idea for users management in multiple instances

Thanks orlando,

That really helps, I now have an idea of how to start tackling this.

Much appreciated!

YY
by yyround
Sun Oct 08, 2017 4:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using IBM TM1 Turbo integrator Debugger
Replies: 3
Views: 4370

Re: Using IBM TM1 Turbo integrator Debugger

Thanks Wim,

You are right, the port number is 12354, I had it as 12345. Very silly mistake!

Thanks again.

YY
by yyround
Sat Oct 07, 2017 7:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using IBM TM1 Turbo integrator Debugger
Replies: 3
Views: 4370

Using IBM TM1 Turbo integrator Debugger

Hi all, I am using TM1 10.2.2 FP7 and would like to use TI debugger to help debug some of the TIs in the newly-built model. I follow this http://cogknowhow.tm1.dk/?s=debugger&submit=Search page but clicking on the login button didnt lead me anywhere. I even tested it on the "planning sample...
by yyround
Sat Oct 07, 2017 7:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Seeking idea for users management in multiple instances
Replies: 7
Views: 4717

Re: Seeking idea for users management in multiple instances

Thank you very much guys for your input.

Orlando, can I please ask you to elaborate a bit more on how you "track which user uses which environment via a cube?"

Regards
YY
by yyround
Wed Sep 06, 2017 6:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Seeking idea for users management in multiple instances
Replies: 7
Views: 4717

Seeking idea for users management in multiple instances

Hi all, We have 5 TM1 instances in both acceptance and production environment. Our organisation has purchased X amount of admin licences and Y amount of write licences. Some users use more than 1 instance. We are looking for a way (preferable free) to manage the user in all instances under both envi...
by yyround
Tue Aug 29, 2017 1:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 super user
Replies: 2
Views: 2114

Re: TM1 super user

Thanks Alan,

Much appreciated:)

Regards
YYround
by yyround
Mon Aug 28, 2017 1:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 super user
Replies: 2
Views: 2114

TM1 super user

Hi All, We are thinking about creating a new TM1 role called "Super"that has access to all our 90k+ cost centres but not utilizing the admin licences. Is there a quicker way to give write access to all 0 level element in the cost centres dimension then just copy and paste "write"...