Search found 3278 matches

by lotsaram
Mon Jul 13, 2020 7:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RptFilter
Replies: 2
Views: 53

Re: TM1RptFilter

TM1RptFilter does the same as the filter function in the Perspectives/Architect cube viewer. It only works if the view has a single dimension on rows.

I don't think you can call it a bug. It's always been like this, even if it sucks.
by lotsaram
Sat Jul 11, 2020 9:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Expand function with numbers
Replies: 11
Views: 182

Re: Expand function with numbers

Could it be that Expand rounds numbers to 4 decimal places? ... and therefore your “day part” goes to zero?

You could get around this by multiplying by a factor of 10^6 and then dividing again.
by lotsaram
Thu Jul 09, 2020 11:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW information for PAX
Replies: 10
Views: 223

Re: PAW information for PAX

I would 3rd it :D

No reason tm1py can't have a module for PAW API
by lotsaram
Tue Jul 07, 2020 9:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Get TM1 Web Application name using the GUID
Replies: 2
Views: 113

Re: Get TM1 Web Application name using the GUID

I believe if cube cell comments are entered from the TM1 Application Web application then the GUID of the particular application shows up as an element in the }Annotation_ApplicationID control dimension which is used in the }CellAnnotations cubes. I don't ever use Application Web so in this dimensio...
by lotsaram
Mon Jul 06, 2020 3:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: STR(Num, len, dec) with only one argument
Replies: 11
Views: 620

Re: STR(Num, len, dec) with only one argument

It should be simple to implement as well, just right click on the Function dimension and create the alias. If only we had access to the objects the next level down in the database. :lol: FWIW you can use CellGetS and CellGetN in place of DB in rules ... lol! I have always wanted some function alias...
by lotsaram
Thu Jul 02, 2020 11:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Query Length Limit for TI
Replies: 10
Views: 234

Re: SQL Query Length Limit for TI

My Query is not for ODBCOutput. Rather it is for SQL when importing data to TM1. Actuall I do not need to put all SQL query into a single String variable. I can have multiple string variables that are being used in the SQL statement for SELECT, such as ?SQLPart1? and ?SQLPart2?...etc. Does this 32K...
by lotsaram
Wed Jul 01, 2020 2:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: re-order dimension result
Replies: 8
Views: 2892

Re: re-order dimension result

Hi, I have been checking our dimension orders and notice that I can gain -20, -50 on some cubes. But some of the cubes are quite small, so 100mb and another is 1gb. So my question is, when does dimension reordering become worth it based on the size of the cube? Maren This is one of those ultimate "...
by lotsaram
Wed Jul 01, 2020 8:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bringing Allocated Resource from another cube
Replies: 2
Views: 270

Re: Bringing Allocated Resource from another cube

Well, urrrm, what have you actually done? The requirement you state is pretty simple. You just need a zero supressed view on the first cube with only the "Allocated Resource" measure selected. Then on the data tab take the variable from the Resource dimension and write it with CellPutS to the "Resou...
by lotsaram
Wed Jun 24, 2020 7:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SKIP If doesn't exist instead of ERROR
Replies: 3
Views: 192

Re: SKIP If doesn't exist instead of ERROR

This question is so basic I think it's appropriate to guide you to the request for assistance guidelines. This is really TurboIntegrator scripting 101. Usually you would make sure that metadata (that is dimension updates) is loaded in a separate process from a separate source, and that this happens ...
by lotsaram
Tue Jun 23, 2020 7:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Not Moving to Cell
Replies: 13
Views: 311

Re: Data Not Moving to Cell

The issue is not with the calculation but with the feeding . The screenshots of the rule trace don't help at all as due to the Continue the tracer only shows the FIRST rule which applies to the cell and not the FINAL AND ACTUAL calculation. But in this case it doesn't matter as the screenshot of the...
by lotsaram
Mon Jun 22, 2020 8:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Multiple COA Best Practice
Replies: 6
Views: 249

Re: Multiple COA Best Practice

If this is primarily for consolidation and you have business segment dimensions aside from Legal Entity then it could get messy and separate cubes per ERP/GL are probably a good idea. However, if all you care about is Legal Entity consolidation and statutory IFRS/GAAP reporting based on the CoA then...
by lotsaram
Mon Jun 22, 2020 1:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there an easy way to convert a dynamic subset to static?
Replies: 15
Views: 6375

Re: Is there an easy way to convert a dynamic subset to static?

Ever since SubsetMDXSet was introduced I only use that one to create dynamic subsets. It seems more robust. For example you do not get an error if your MDX returns an empty set. If you use SubsetCreateByMDX with such a subset an error will occur. But sometimes it is okay to have an empty set if you...
by lotsaram
Sat Jun 20, 2020 5:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Free Server Monitoring Tool other than TM1Top
Replies: 4
Views: 478

Re: Free Server Monitoring Tool other than TM1Top

The only thing that p*****s me off about it is its insistence on you following admin password rules that to my mind are complete and utter frapping overkill for an application that generally lives its life within a VPN; rules that I do NOT follow for my real TM1 login, so every time I want to log i...
by lotsaram
Fri Jun 19, 2020 1:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.0.9 Upgrade Concerns
Replies: 3
Views: 265

Re: PA 2.0.9 Upgrade Concerns

Yes I have a customer already on 2.0.9.1 and all is good. The MDX security issue doesn't really affect them. One really good thing is all the "sf_file" locking errors seem to be vastly reduced which is both good for performance and reduces garbage in the message log.
by lotsaram
Thu Jun 18, 2020 11:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change of MDX security in 2.0.9 - Discussion
Replies: 14
Views: 1072

Change of MDX security in 2.0.9 - Discussion

There is a potentially important change in 2.0.9 which Mike Cowie's Quebit has uncovered (and many thanks to Moby91 for pointing me to it), though it doesn't seem to be in the release notes and there doesn't seem to be a full technote on it yet. In short, it used to be that MDX would execute then c...
by lotsaram
Thu Jun 18, 2020 12:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Changing Quick view depending on cell drop down
Replies: 24
Views: 858

Re: Changing Quick view depending on cell drop down

You need to replace ALL the hardcoded references to the dimension with a reference to your dimension selection.
by lotsaram
Wed Jun 17, 2020 5:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Some icons missing on set editor
Replies: 10
Views: 704

Re: Some icons missing on set editor

ascheevel wrote:
Wed Jun 17, 2020 3:58 pm
scrumthing wrote:
Wed Jun 17, 2020 2:56 pm
Everybody calls it PAfE nowadays. Sorry.
I would argue PAX is the generally accepted abbreviation.
Well not if you’re IBM. They are doing their darnedest to discourage people using PAX.
by lotsaram
Tue Jun 16, 2020 8:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Changing Quick view depending on cell drop down
Replies: 24
Views: 858

Re: Changing Quick view depending on cell drop down

as i told i am very new to PAx and PAW, can you please tell roughly how to achieve it in the easy way, if you have time please As Tomok has demonstrated, you can explain in few words with little effort how to do this to someone who already knows what they are doing. The explaination above is enough...
by lotsaram
Tue Jun 16, 2020 8:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ISSUE IN MDX VIEW AS DATA SOURCE
Replies: 4
Views: 212

Re: ISSUE IN MDX VIEW AS DATA SOURCE

FYI this has previously been discussed here https://www.tm1forum.com/viewtopic.php?f=3&t=14797&p=73290&hilit=viewmdxset#p73290 And the issue with viriable assingment order (and the needed workaround in how to build the MDX select query) is discussed here https://www.tm1forum.com/viewtopic.php?f=3&t=...
by lotsaram
Tue Jun 16, 2020 4:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ISSUE IN MDX VIEW AS DATA SOURCE
Replies: 4
Views: 212

Re: ISSUE IN MDX VIEW AS DATA SOURCE

That’s one of mine. I was told that it should be fixed but I admit I haven’t tested it as I have more or less given up on MDX views as data sources for TI due to the hoops you need to jump through in constructing the MDX in order to achieve variable assignments in the same order as the dimension ord...