TM1 Forum

Hi,
Just in case you have access to Planning Analytics for Excel you can use Hierarchies there as well.

If you have not installed PAW (as opposed to not being able to access it), then you won't be able to use (all of) PAfE and so won't be able to report with hierarchies.

Cheers,

Yes

You don't edit it by right clicking the button anymore
Goto the task pane / object tree, select the worksheet tab, in here you should find all your action buttons listed. Right click and edit.

Couldn't you use the Elweight function to pull the value out into an attribute and then run your MDX filter versus the attribute value?

In the set editor toggle the Show Totals Leading / Trailing which is the Epsilon with the bars above and below it in the middle of the editor.
Make sure the set editor is in to Hierarchy mode rather than definition mode as well as this (might) make a difference too.

Hi I've created an RFE for the addition of new type of picklist definition MDX:{MDX Expression}. Would like to try and avoid the creation of loads of redundant subsets to drive picklist selectors. All adds to the development time, server clutter and risk of deletion in error. When we have to create ...

@Bakkone, must have missed this option, I did look, I'll look harder!
@MarenC, it just comes back on the next edit so Yes you have to remove it for sure but I was looking to stop it happening in the first place.

Removing the snail stops it from happening as well.

Thought I'd keep all the nonsense that arises from the at sign in one place. Working in active forms in Pafe where we have the at in front of report row formula i.e. =@TM1RPTROW($C$11,"Server:DimName",,,"Description",,$D$21) If I edit (f2, return) this then Excel decides that this is an email addres...

Hi, It sounds you have some problems.... From what you have said the OS is using the swap file / virtual RAM on the disc to provide all the memory that TM1 requires. This _may_ not be hurting your performance since this is all garbage but far from ideal. This would explain why adding more RAM didn't...

Hi, Your first place to check for where the rest of the memory is the stats for server cube and the Garbage Memory. Garbage Memory is memory that TM1 has used but is not at the moment. Common reasons for a large Garbage Memory are Multi threaded start-up options or very large views being generated i...

How have you published the websheet? Make sure you have picked the upload to server option rather than the linked approach.

Hi _BM_ I don't have an answer for you but some more questions that may clarify the position. Is this a new install or an upgrade? Has the connector every worked? Assuming this is an on-premise build? "Cannot open connection to database" This would normally mean that either the PA hardware can not s...

Obviously only working with a little bit of detail but.... Some questions What is the difference between the 4 sets of actual data and why are they in different cubes? What is the difference in between the forecast data and the actual data, is there some difference in granularity? General Comments. ...

Without getting into the merits of what you are doing in the 'Forecast Intermediate' cube put [{'Subset list of common measures' , 'M1' , 'M2' , etc]=>DB('Reporting' , !Version, !Actual and Forecast Types, !Products , !Current Time, !FORECAST Measures) ; I can't help but ask if the situation is as y...

Just a note to say there is an APAR associated with this
https://www.ibm.com/support/pages/apar/PH16537

You'd think I would use the search button... Just cross linking for anyone who finds this post and not the other one https://www.tm1forum.com/viewtopic.php?f=3&t=14797&p=73290&hilit=viewmdxset#p73290 thanks Lotsaram Also there is an APAR associated with this https://www.ibm.com/support/pages/apar/PH...

Hi, This function appears to suffer from the same issue as the subset function in that it errors if the MDX does not return any values. This seems like very dumb behaviour (though I'll no doubt be told its by design and to raise a RFE..). I've been fiddling around with creating a union of my real qu...

I'd strongly recommend that you regard this as a formatting problem not a data problem. If you go the rule approach then you will duplicate all the data (bad). You could round the data on loading in the TI process, this is probably the most right way. but.... As TM1 (and almost any computer) sums 2 ...

Hi, I think the answer is no but... With an active form I can change the MDX being used to generate the row headers in a very dynamic way. For exploration, quick and custom reports there is the VBA CreateFromMDX method available. I've a strong preference for not using VBA as it traps any front end d...

As an FYI, this seems to clear by doing an edit replace of "=@" with "=" across all cells and sheets. I've not seen the "@" get re-introduced to date.

In both PAfe and perspectives version 2.0.43 / TM1 Build 11.5 I can see that =@DBRW causes the type over write back to fail, instead just ending up with the value you entered in the cell? Any ideas what release this was fixed in or does the defect still exist in the 2.0.9 series? Cheers and Good Hea...