TM1 Forum

Not sure if you have this type of operation a lot or if it is only applying to one specific account. If you have to have this working in lots of places then... Avoid ConsolidateChildren at all costs, you will regret it eventually. First thought, can you ABS or flip sign on the values when you are wr...

Hi, The general form of the MDX I am using is as follows for a 5d cube sMDXToUse='SELECT {%sMDX5%} ON 0, %sFilterHead% NONEMPTY( CROSSJOIN(%sMDX1%, CROSSJOIN(%sMDX2%, CROSSJOIN(%sMDX3%, %sMDX4%))), {%sMDX5%} %sFIlterEnd% ) ON 1 FROM [%sCubeName%]'; ViewCreateByMDX(sCubeName , sObjectName, sMDX, booT...

Afternoon or the local equivalent, I've an MDX view. It a level 0 view of a medium sized cube, not huge by any means, with a Filter applied to the cells based on the value of one of the measures in the cube. Fairly straight forward. If I try and display the view in PAW I get an out of memory error I...

This might be the a bug or might be the different calculation method in Pafe. In Pafe with calculation set to automatic (the default behaviour) the Pafe piggy backs on Excel cell dependency logic to determine what cells to calculate. Since TM1PRIMARYDBNAME() has no dependency it probably never gets ...

Hi, Wrestling with TM1 Web published through PAW and getting consistent behaviour. Use Case: User enters data into custom report. User runs TI with Recalculation before and after the TI runs turned on. TI runs taking into account the data that has just been committed in the calculation pass that tak...

Hi Paul,

Not sure where you are stuck but picklists is the functionality you need.

Cheers

On the license side, you can point an action button at the TI process and the user can access this from within Excel or TM1 Web. No PAW license required for this. You could put your TI process in a chore with some added code that checks for the existence of the file and then runs the load at the end...

So to use PAW, admin license is not required, but to work on PAW's admin utilities, Admin license is required. Correct Is PAW License separate? It depends on the exact nature of your existing arrangement, if you have upgraded from the 10 series then it is probably additional. If your first purchase...

Hi,
You need to use the StrToMember function to pull the reference from the previous selection into the next MDX subset.

There are some examples on this thread

Just to check you are using the Design Mode on the Pafe toolbar, not the one on the Developer toolbar?

Hi Samiamsz, Please do not create multiple posts for the same issue, I have deleted your other posts. How far have you got with implementing your solution and have you read the FAQ for requesting help? I'd suggest that you attempt a solution yourself and ask specific questions on issues you encounte...

An admin licence is not required to consume or create PAW content but a PAW licence is. The admin licence is required for development and maintenance / admin functionality, but this should not require additional admin licences. Where the confusion may arise is that admin licence people do not requir...

If you have space in your cube then you can add a measure next to your loaded data and then write a rule to round the input values.

There is obviously an overhead to this on the rules and feeders required, you'll need the balance this versus the problems the zero suppression is causing.

On the logging for the stats cube it can be very useful to have the logging on in specific circumstances. If you are trying to track an issue or a specific event over a long time period and want granular stats then you can do some nice analysis from the transaction log by just taking the information...

Good to see we're not the only people that wrestle with this!

https://www.theregister.com/2020/08/06/ ... ene_names/

FYI

This doc appears to address your question.

Cheers,

You need to take care when using indexes and be clear what it is referring to. In this case SUBNM ('branch', Sub-chosen-ENTITY, 1) will display the 1st element of the subset "Sub-chosen-Entity". Depending on how the subset is ordered this may not be the first child of the sub-entity. So check how th...

Just in case, consider that the TM1 DB will probably have shut down after generating these messages so if you looked at RAM consumption after the messages you won't have seen the impact of the TM1 DB. Are you sure the TM1 DB was running when you checked the resource levels? Most likely explanation i...

If we assume your code is correct and the error message is correct then the element must already exist. I seem to remember being caught out by subset names clashing with new elements at one time. A by product of UDCs. Try and dimix the element, what does it return? If the Dimix > than max elements i...

Hi Lotsaram, Not convinced that it isn't supposed to work across the whole tuple set. I did some testing vs SData and get reliable correct sorting irrespective of the number of dims in the row position. cigar.png You can see in the above screen shot the whole tuple on a row is sorted independently. ...