Search found 2693 matches

by tomok
Mon Mar 30, 2020 5:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What is correct way to write TM1 rule.
Replies: 5
Views: 73

Re: What is correct way to write TM1 rule.

If you keep in mind the logic for a rules statements is as follows: [Area of cube] = Rule calculation then you'll understand why you can't use dynamic values on the left hand side. If you don't specify a value on the left hand side of a rule for a specific dimension then it means all elements of tha...
by tomok
Mon Mar 30, 2020 5:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.0.7 - Accessing TM1 Web outside localhost
Replies: 2
Views: 42

Re: PA 2.0.7 - Accessing TM1 Web outside localhost

Have you checked your firewall settings?
by tomok
Fri Mar 27, 2020 4:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Connect the ODBC on -premise with the Planning Analytics on Cloud
Replies: 5
Views: 421

Re: Connect the ODBC on -premise with the Planning Analytics on Cloud

Whether you choose to use the secure gateway or re-engineer your load processes to utilize flat files is entirely up to you. The only way you are going to know is to do some performance testing of both. Just make sure your performance testing is the real thing, not some limited subset of your real s...
by tomok
Mon Mar 23, 2020 7:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to Fetch Data
Replies: 3
Views: 706

Re: Unable to Fetch Data

bubidibabadi wrote:
Mon Mar 23, 2020 7:27 pm
I have checked the dimension security as well and all the dimensions in Cube A have read access to all the Groups. Doesn't this mean she should be able to view the cube?
What about any }ElementSecurity_xxxx cubes, or even }CellSecurity cubes?
by tomok
Wed Mar 18, 2020 1:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance Modeler and security
Replies: 6
Views: 537

Re: Performance Modeler and security

Thank you all! I think I understood the basics. I also solved my little problem by simply deleting the hidden cubes }ElementSecurity_Dim_A }ElementSecurity_Dim_B }ElementSecurity_Dim_C Now the users in the group have access again. When it comes to security you must be careful of the actions you tak...
by tomok
Wed Mar 18, 2020 11:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance Modeler and security
Replies: 6
Views: 537

Re: Performance Modeler and security

TM1 works in this order: Cube security Dimension security Element security You can't skip a level on the way down. If you have none of these cubes then all users can WRITE to every cube. If you enable cube security, and nothing else, users will get the rights to the cubes per their group membership,...
by tomok
Tue Mar 17, 2020 5:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hold and Proportional Spread
Replies: 6
Views: 207

Re: Hold and Proportional Spread

How can you expect anybody to help when you haven't provided the actual code. Pseudo code is worthless, plain and simple. I verified more times that If I comment the CellPutProportionalSpread statement, cells are hold as I exptected. This one is kind of a no-brainer. According to your provided code,...
by tomok
Fri Mar 06, 2020 5:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBCOutput with select statement
Replies: 1
Views: 1116

Re: ODBCOutput with select statement

I've used ODBCOutput to do dml and ddl on oracle tables but is this possible? ODBCOutput(vConnection, 'select 12345 into %vNumber% from dual'); The reason is I'd like to use this as like a post-query against a sql based ODBC data source in a process. I've read all over the place and seen numerous i...
by tomok
Wed Mar 04, 2020 1:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cell Type is Real weirdness
Replies: 2
Views: 511

Re: Cell Type is Real weirdness

It makes perfect sense to me. In your first example trying to pull a numerical value with a CellGetS results in an error so no value is assigned to vDay and therefore the If( vDay @= '03' ); is false and nothing is written to sFile. In your second example, you are assigning a value to vDay and then ...
by tomok
Wed Mar 04, 2020 12:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web Snapshot with Excel Formulas
Replies: 3
Views: 336

Re: TM1Web Snapshot with Excel Formulas

Is there a way we can ensure that snapshot only removes TM1 formulas? Or what should be the alternative approach? The snapshot functionality is basically the same as range valuing a spreadsheet. It converts everything to values, not just TM1 formulas. There is no known workaround that I am aware of.
by tomok
Tue Feb 25, 2020 11:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation sum error - negative weighting
Replies: 8
Views: 415

Re: Consolidation sum error - negative weighting

PC Amount is 122,663.31 PO Amount is same How do you know PO Amount is the same? Did you look at the unformatted value behind that cell in TM1? Take your formatting off the cube and compare those two amounts. They are probably not the same which is why the net is not equal to 0. This is where you f...
by tomok
Thu Feb 20, 2020 4:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ruled cell not released for write
Replies: 10
Views: 408

Re: Ruled cell not released for write

Actually the way the attribute working is just a "Y" under the attribute "Active" in the "Version" dimension. Well, that's not exactly how it works because just setting some attribute on an element is not going to control whether or not you can write to it without some special code in the rules for...
by tomok
Thu Feb 20, 2020 3:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ruled cell not released for write
Replies: 10
Views: 408

Re: Ruled cell not released for write

If this "Active Version" you are referring to is an alias then you may need to separate the export and the import processes and update the alias in between the two. I have had similar issues in the past with using an alias in this manner and that is what I had to do.
by tomok
Wed Feb 19, 2020 3:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Query - ODBC or syntax issue?
Replies: 5
Views: 263

Re: SQL Query - ODBC or syntax issue?

The last part of my describe is copy/paste from Message Log. Please look rather on the parts, which I marked as Code. If this is copied verbatim from the message log: Error: MetaData procedure line (0): Error executing SQL query: "SELECT ZapisySap.[GJAHR],ZapisySap.[MONAT],ZapisySap.[LDGRP] ,Zapisy...
by tomok
Tue Feb 18, 2020 4:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill Through to ORACLE ODBC
Replies: 11
Views: 787

Re: Drill Through to ORACLE ODBC

If this: Error executing SQL query: "Select * from xxchc.xxgl_acc_analysis_det_tbl where Period_Name = FY-Nov-20 and LEDGER <>'CHC Consolidation Ledger' and Department = '103' and Company = '20' and Account ='411' and Division ='2003'" is copied verbatim from the error log then my original post is s...
by tomok
Tue Feb 18, 2020 11:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill Through to ORACLE ODBC
Replies: 11
Views: 787

Re: Drill Through to ORACLE ODBC

Error executing SQL query: "Select * from xxchc.xxgl_acc_analysis_det_tbl where Period_Name = FY-Nov-20 and LEDGER <>'CHC Consolidation Ledger' and Department = '103' and Company = '20' and Account ='411' and Division ='2003'" You do realize that the date value you supply to Oracle has to be encap...
by tomok
Mon Feb 17, 2020 12:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 cleaning up
Replies: 4
Views: 357

Re: TM1 cleaning up

Dear all TM1 experts: I have lots of elements in various dimensions which I am sure not been used at all, which I would like to delete. I also want to know which elements from what dimension been used in what cubes, so that I can do some clean ups (ie, delete those not been used at all elements and...
by tomok
Thu Feb 13, 2020 12:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monitoring User Logins
Replies: 21
Views: 1694

Re: Monitoring User Logins

While we're on the subject of logging, if you put this in your tm1s-log.properties file it will create a separate log called TI.log that will contain all messages you send from a TI: log4j.logger.TM1.TILogOutput=DEBUG, Debug_LogOutput log4j.appender.Debug_LogOutput=org.apache.log4j.SharedMemoryAppen...
by tomok
Thu Feb 13, 2020 11:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monitoring User Logins
Replies: 21
Views: 1694

Re: Monitoring User Logins

kumesh wrote:
Thu Feb 13, 2020 7:51 am
Hi,

I cannot find the location for the tm1slog.properties file? Is it not in the same location as the tm1s config file?

Thanks,
It is actually called tm1s-log.properties.
by tomok
Wed Feb 12, 2020 3:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monitoring User Logins
Replies: 21
Views: 1694

Re: Monitoring User Logins

Maybe it used to work in TM1 but it does not in PA. I am on PA and I double-checked again to make sure. There is nothing written to the transaction log for the }ClientProperties cube when a user logs in. The solution involving the tm1s-log.properties setting is the only sure-fire way to get what you...