Search found 1602 matches

by Steve Rowe
Mon Oct 05, 2020 8:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unexpected behavior of consolidations
Replies: 8
Views: 251

Re: Unexpected behavior of consolidations

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...
by Steve Rowe
Fri Sep 25, 2020 11:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX views, where / how are they evaluated?
Replies: 6
Views: 300

Re: MDX views, where / how are they evaluated?

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...
by Steve Rowe
Thu Sep 24, 2020 2:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX views, where / how are they evaluated?
Replies: 6
Views: 300

MDX views, where / how are they evaluated?

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...
by Steve Rowe
Thu Sep 17, 2020 4:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1PrimaryDBName() not firing in promoted PAfe but is in Web
Replies: 2
Views: 198

Re: TM1PrimaryDBName() not firing in promoted PAfe but is in Web

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 ...
by Steve Rowe
Tue Sep 15, 2020 3:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web , Commit data entry and run a TI
Replies: 1
Views: 179

TM1 Web , Commit data entry and run a TI

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...
by Steve Rowe
Thu Sep 10, 2020 12:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 - From Dropdown - Data Validation
Replies: 3
Views: 202

Re: TM1 - From Dropdown - Data Validation

Hi Paul,

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

Cheers
by Steve Rowe
Thu Sep 10, 2020 12:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Uploading data with PAW/PAX
Replies: 2
Views: 200

Re: Uploading data with PAW/PAX

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...
by Steve Rowe
Thu Sep 10, 2020 12:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW License
Replies: 4
Views: 257

Re: PAW License

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...
by Steve Rowe
Tue Sep 08, 2020 3:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using a loop to check an mdx
Replies: 1
Views: 121

Re: Using a loop to check an mdx

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
by Steve Rowe
Tue Sep 08, 2020 8:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Design Mode
Replies: 2
Views: 166

Re: Design Mode

Just to check you are using the Design Mode on the Pafe toolbar, not the one on the Developer toolbar?
by Steve Rowe
Fri Sep 04, 2020 11:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: create report filters that are cascading
Replies: 3
Views: 183

Re: create report filters that are cascading

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...
by Steve Rowe
Fri Sep 04, 2020 8:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW License
Replies: 4
Views: 257

Re: PAW License

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...
by Steve Rowe
Tue Sep 01, 2020 8:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Zero Suppression - very small #'s
Replies: 3
Views: 193

Re: Zero Suppression - very small #'s

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.
by Steve Rowe
Tue Aug 18, 2020 11:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: LOGGING for }StatsBy Control Cubes
Replies: 7
Views: 375

Re: LOGGING for }StatsBy Control Cubes

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...
by Steve Rowe
Wed Aug 12, 2020 11:38 am
Forum: General
Topic: Genes, Excel and Dates
Replies: 2
Views: 312

Genes, Excel and Dates

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

https://www.theregister.com/2020/08/06/ ... ene_names/
by Steve Rowe
Mon Aug 03, 2020 11:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM License Metric Tool?
Replies: 17
Views: 3868

Re: IBM License Metric Tool?

FYI

This doc appears to address your question.

Cheers,
by Steve Rowe
Wed Jul 29, 2020 7:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subnm index change
Replies: 6
Views: 427

Re: Subnm index change

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...
by Steve Rowe
Mon Jul 20, 2020 8:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Windows Server errors ERROR_NOT_ENOUGH_MEMORY ERROR_NO_SYSTEM_RESOURCES
Replies: 9
Views: 1245

Re: Windows Server errors ERROR_NOT_ENOUGH_MEMORY ERROR_NO_SYSTEM_RESOURCES

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...
by Steve Rowe
Wed Jul 15, 2020 4:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error while trying to build a Named Hierarchy in a TI process
Replies: 4
Views: 584

Re: Error while trying to build a Named Hierarchy in a TI process

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...
by Steve Rowe
Tue Jul 14, 2020 10:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RptFilter
Replies: 2
Views: 286

Re: TM1RptFilter

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