Search found 323 matches

by EvgenyT
Fri Apr 21, 2017 11:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Query Error On TI Prolog tab
Replies: 4
Views: 2168

Re: SQL Query Error On TI Prolog tab

I always use sQuote = CHAR (39)/CHAR(34) in cases when '/" required in SQL statement. Find easier to understand and debug.

ET
by EvgenyT
Fri Apr 21, 2017 7:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Keep Active form expanded
Replies: 4
Views: 1799

Re: How to Keep Active form expanded

Never really used it myself, but give this a try ToggleDrillState ( MDX Function )

Cheers

Evgeny
by EvgenyT
Thu Apr 13, 2017 3:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: A maniac list of new functions...
Replies: 0
Views: 1051

A maniac list of new functions...

Hi Fellows, I've just came across this new maniac list of functions ( or maybe just new to me :lol: :lol: :lol: ) https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_ref.2.0.0.doc/c_attributemanipulationturbointegratorfunctions_n71004.html Seems to me over-engineered, ...
by EvgenyT
Tue Dec 13, 2016 8:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to get info from tm1server.log for which cube indivitual info is related to?
Replies: 1
Views: 1250

Re: How to get info from tm1server.log for which cube indivitual info is related to?

If memory servers me right, then TM1.Cube.Stargate.Definition will give you detailed definition of a star gate, as well as a cube name

Please let me know how you go


Cheers
by EvgenyT
Tue Dec 13, 2016 10:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server Crash
Replies: 9
Views: 2770

Re: TM1 Server Crash

Well noted mate. What I meant is circular reference per se
by EvgenyT
Tue Dec 13, 2016 9:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server Crash
Replies: 9
Views: 2770

Re: TM1 Server Crash

You mentioned overfeeding as one thing, when reading up on this I came across circular referencing. So just wondered if there were any schoolboy errors that could lead to this Don't think circular reference would normally crash the server, but blowing feeder stack and memory would. Any server log m...
by EvgenyT
Mon Dec 12, 2016 9:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Server not starting
Replies: 7
Views: 2848

Re: Tm1 Server not starting

Well it happened again this morning and it looks like I've found out what the culprit was... there was a default view on a control cube and when I've deleted that folder from the data directory it has started up fine. Absolutely no idea why that would stop a server from starting but it has resolved...
by EvgenyT
Sun Dec 11, 2016 10:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server crash after data entry
Replies: 8
Views: 2663

Re: Server crash after data entry

Entry for Attrition %, Attrition calculated based on Average Balance, Average balance calculated as (Opening Balance + Closing Balance)/2 Sorry, I may not all the specific here, but why do you need to calculate Avg Balance with the rule? Cant you just use weighting to get your avg balance: avg: ope...
by EvgenyT
Thu Dec 08, 2016 3:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Security question
Replies: 11
Views: 3488

Re: TM1 Security question

Hah, nice one Andy! ( Didnt look very hard, did I ) :roll: :roll: :roll: :roll:
by EvgenyT
Wed Dec 07, 2016 11:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Security question
Replies: 11
Views: 3488

Re: TM1 Security question

As of I think FP5 or FP6 there is a new config parameter which disables this default behaviour and enforces users being added manually or via TI as opposed to on the fly on first login if the default behaviour is not what you want. Interesting info. Haven't been able to locate any documentation on ...
by EvgenyT
Wed Dec 07, 2016 10:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Security question
Replies: 11
Views: 3488

Re: TM1 Security question

I haven't imported any CAM Group yet. I added couple of CAM users and then tried to remove one user.
Sorry, that's a little contradicting. You can either add a CAM user to a CAM group or any of the three TM1 admin groups under security mode 4
by EvgenyT
Wed Dec 07, 2016 9:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Maximum rows in active form?
Replies: 1
Views: 968

Re: Maximum rows in active form?

First point of call would be to check inconsistently named named ranges, TM1 web sometimes acts funny with those.
by EvgenyT
Wed Dec 07, 2016 9:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Security question
Replies: 11
Views: 3488

Re: TM1 Security question

Isnt the user automatically validated against the existing group and created on the fly, given it's a mode 4?
I would have thought procedures would be as followed:
Run RemoveClientFromGroup, then remove the user from the group in CAM
by EvgenyT
Thu Nov 24, 2016 8:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 wait state processes are not executed
Replies: 12
Views: 3628

Re: TM1 wait state processes are not executed

The issue the OP is raising though is that when the multi-threaded TIs get locked, when the lock is released from thread 1 why doesn't thread 2 run?
Something fails along the way and the rest is trashing perhaps..
by EvgenyT
Wed Nov 23, 2016 7:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 wait state processes are not executed
Replies: 12
Views: 3628

Re: TM1 wait state processes are not executed

Metadata update is the most common offender when it comes to locking. Such operations should never be a part of a multi-user concurrent operation. I would be very surprised if metadata needs to updated each time someone executes Master Process
by EvgenyT
Tue Nov 22, 2016 2:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 wait state processes are not executed
Replies: 12
Views: 3628

Re: TM1 wait state processes are not executed

Thank you all for you responses. The chore is auto schedule and executed from 5 to 5 minutes. It s searches using a select in the DB and it runs the master process for the entities where the flag is 0. Example: we have a,b,c,d rows in the DB and the flag for a,b is 0, the chore will run the process...
by EvgenyT
Fri Nov 18, 2016 9:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 wait state processes are not executed
Replies: 12
Views: 3628

Re: TM1 wait state processes are not executed

Does chore run in multi or single commit mode?
Each user runs a chore...?
by EvgenyT
Thu Nov 17, 2016 10:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: FEEDERS issue/Bug
Replies: 4
Views: 1875

Re: FEEDERS issue/Bug

PersistentFeeders would be number one offender on my list, caused headache too many times before. Rule of thumb: Keep them off during the development at all times!
by EvgenyT
Thu Nov 17, 2016 9:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 wait state processes are not executed
Replies: 12
Views: 3628

Re: TM1 wait state processes are not executed

Wait state indicates that target is still locked by another TI. Can you please identify what type of contention it is, e.g. IX etc. ? You said it triggered by a chore: does the chore run in single/multi commit mode? From the description below its not clear whether there is a single process or multip...
by EvgenyT
Wed Sep 28, 2016 11:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to create dimension in TM1 cube with 3 alias?
Replies: 9
Views: 2872

Re: How to create dimension in TM1 cube with 3 alias?

Perhaps try learning basics of TM1 first ( there is plenty of documentation out-there) before wasting people's time on this forum...

ET