TM1 Forum

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.

I would 3rd it

No reason tm1py can't have a module for PAW API

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...

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...

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...

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 "...

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...

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 ...

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...

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...

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...

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...

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.

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...

You need to replace ALL the hardcoded references to the dimension with a reference to your dimension selection.

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.

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...

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=...

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...

Why do you specify quick report?
There are a number of ways you could achieve this. It would be very easy for example with an active form (now called dynamic custom report in PAfE).
Or it could be done very simply with a native drill-through.
Plus other ways to do it.