TM1 Forum

You just need to specify the specific elements for any dimension that's in the Sales Test cube. If the Year dimension is called "Year" it would look something like below: { TOPCOUNT( { TM1FILTERBYLEVEL( {tm1subsetall( [Month] )} ,0)} ,5 , [Sales Test].([Year].[2013],[Sales Analysis Measure...

How many dimensions does the "Plan Employee" cube have? Your expression accounts for 3 dimensions; Employee, Category, and Measures_Plan_Employee. If there are more dimensions in the cube then it will either be trying to automatically derive an element for those dimensions - it can do this...

What is the use case for involving more than 1 alternative hierarchy from the same dimension in the same formula? Consider a sku dimension where n-level elements are car models. You want all automatic models from hierarchy 1, all SUV models from hierarchy 2 - this result returns only the sum of n-l...

Check if there is a }picklist cube - if there is, it will take precedence over the attribute picklist setting.

In addition to the good points from Lotsaram, I will throw in an additional possibility that is easy to rule out. The problem can be the time taken querying the data source. Particularly if the source is a view and takes 1 minute to query all, sometimes (depending on keys and so such) you can find t...

Just to add a different spin/idea. It's a rate so do you actually need to feed it? Feeding gives you 2 benefits, 1 is that you can consolidate the results up - since it's a rate you don't need that. The other is that it allows you to zero suppress. Even if you don't feed the cells, they still contai...

You can't exactly access a user's private view. But you can copy it from the users private }vues folder in the data directory to your own (note that if it contains any private subsets you will also need to copy those over.) Then you should be able to see the view as a private view of your own, where...

Do all of these dimensions exist in the cube that you are writing the rule for:
!Metrics Scenario
!MidstreamAssets
!MidstreamMetrics
!Year
!Period
!MetricScenario
!MidstreamContractMetrics


I expect that the issue you are seeing is more fundamental than the name of the cube/dimension being the same.

What error message does it give you? And what editor are you using: Architect, Workspace, Performance Modeler, Arc etc? I don’t think any of my models have had cubes and dimensions with the same name but I feel like some of the sample IBM models did and I’m pretty sure it shouldn’t cause an issue - ...

I looked into that particular function but only it spreads across only one axis Just tested with Sdata and confirmed CellPutProportionalSpread works multidimensionally. Because OP is looking for an iterative proportional spread, they don’t quite just want proportional. Rather they are looking for (...

My AWS is windows 10 and Excel version 2008/Office 365 and I installed the perspectives 64-bit (TM1 10.2.2). while opening my TM1 reports (VBA code/macros) for testing/input numbers then it is showing that incompatible (attached error). My question is, 32-bit perspectives would it support? Is there...

Yeah, my use case is a pretty extreme one. I've always gone with Expand before (or at least since I knew how to use it) and have never needed to even consider it before but the process in question is a beast. So I ended up checking all sorts of things - like whether TextOutput or AsciiOutput would b...

Recently stuck a blog post up over on the IBM Community https://community.ibm.com/community/user/businessanalytics/blogs/declan-rodger/2021/09/10/time-to-stop-using-expand but long story short is that if you are using Expand to concatenate your variables up into a big string (for exporting to flat f...

Hello I have this MDX {[Year{Month].[Jan 2021]:[Year{Month].[May 2021]}. It work fine But when i try to do {[Year{Month].[&$G$1&]:[Year{Month].[&$G$2&]} or {[Year{Month].["&$G$1&"]:[Year{Month].["&$G$2&"]} in PAX. It doen't work. Could some help m...

I should also add that if you stick it into the View MDX box in PAW it will convert it a bit to have a distinct function in something like below: SELECT NON EMPTY {[Version].[Version].[Actual]} ON 0, {FILTER ( {DISTINCT ( { TM1FILTERBYPATTERN ( { TM1FILTERBYLEVEL ( { TM1SUBSETALL ( [Month] ) } , 0 )...

By the looks of the first MDX view you got to so far: You have multiple December months as columns All leaf elements from Country, Operator and Platform on your rows 4 other dimensions as Title Elements You have tried placing the negative filter in the Month columns. If you only want to show negativ...

Since generally we need to sort the data we need to be able to sort on the tuples on the rows, AFAIK this isn't possible in a dynamic report and I don't know of a way to have a dynamic MDX view driven report in Excel in Pafe at this point. This is exactly what the TM1RptFilter allows you to do, you...

In PAX and I assume by extension the API, view filters are not supported in either Dynamic Reports or the Viewer. Not sure if I am missing something on the "viewer" side - I assume you mean the cube viewer in PaFE? If so you can right click on a column header (element) and you have sort o...

It likely means that it worked out a forecast and then tried to place it in cells which are either derived by rules (so it can’t put a value there) or protected by security (also can’t put a value there.) Can you check the intersection you are running it for and see if you have access? If there are ...

Hi Declan, Isn't the problem with adding the If as you suggest that there are 2 divisions in the example given (5410 and 7207), so it will run through the status twice? And the second time it will put in the zero, therefore not solving the issue? And of course there may be 3 or 4 divisions for all ...