Search found 1748 matches
- Tue Feb 15, 2022 8:31 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Use TOPCOUNT to get the top ones in order of the year you want
- Replies: 2
- Views: 861
Re: Use TOPCOUNT to get the top ones in order of the year you want
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...
- Wed Feb 09, 2022 10:50 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Filter by Cube Value
- Replies: 4
- Views: 2986
Re: MDX Filter by Cube Value
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...
- Tue Feb 01, 2022 5:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: DBRW with alternative hierarchies
- Replies: 18
- Views: 22121
Re: DBRW with alternative hierarchies
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...
- Wed Jan 26, 2022 8:45 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Subset Picklist not refreshing
- Replies: 4
- Views: 10301
Re: Subset Picklist not refreshing
Check if there is a }picklist cube - if there is, it will take precedence over the attribute picklist setting.
- Mon Jan 10, 2022 3:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Parallel ODBC loads
- Replies: 9
- Views: 42703
Re: Parallel ODBC loads
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...
- Sat Oct 23, 2021 9:46 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeder took 20 min to save. Can we reduce it?
- Replies: 15
- Views: 23133
Re: Feeder took 20 min to save. Can we reduce it?
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...
- Sun Oct 17, 2021 9:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Access a users private View
- Replies: 3
- Views: 5145
Re: Access a users private View
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...
- Wed Oct 06, 2021 2:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rule Erroring on Duplicative Dimension in DB Formula
- Replies: 16
- Views: 14204
Re: Rule Erroring on Duplicative Dimension in DB Formula
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.
!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.
- Mon Oct 04, 2021 9:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rule Erroring on Duplicative Dimension in DB Formula
- Replies: 16
- Views: 14204
Re: Rule Erroring on Duplicative Dimension in DB Formula
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 - ...
- Mon Sep 27, 2021 8:43 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Spreading data in a procedure
- Replies: 6
- Views: 4934
Re: Spreading data in a procedure
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 (...
- Sat Sep 25, 2021 8:06 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Client shows list of TM1 Servers but cannot connect to any of them
- Replies: 5
- Views: 4241
Re: TM1 Client shows list of TM1 Servers but cannot connect to any of them
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...
- Mon Sep 13, 2021 3:56 pm
- Forum: Useful code, tips and tricks
- Topic: Expand is SLOOOOOOOOOOW
- Replies: 4
- Views: 31771
Re: Expand is SLOOOOOOOOOOW
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...
- Mon Sep 13, 2021 10:05 am
- Forum: Useful code, tips and tricks
- Topic: Expand is SLOOOOOOOOOOW
- Replies: 4
- Views: 31771
Expand is SLOOOOOOOOOOW
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...
- Tue Aug 31, 2021 6:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Error in MDX in PAX
- Replies: 3
- Views: 3040
Re: Error in MDX in PAX
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...
- Thu Aug 26, 2021 7:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX: Filtering on negative values
- Replies: 5
- Views: 4388
Re: MDX: Filtering on negative values
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 )...
- Thu Aug 26, 2021 7:27 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX: Filtering on negative values
- Replies: 5
- Views: 4388
Re: MDX: Filtering on negative values
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...
- Sat Aug 21, 2021 4:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Warning: PAX and Rest API do NOT support filters in Views
- Replies: 5
- Views: 26661
Re: Warning: PAX and Rest API do NOT support filters in Views
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...
- Fri Aug 20, 2021 6:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Warning: PAX and Rest API do NOT support filters in Views
- Replies: 5
- Views: 26661
Re: Warning: PAX and Rest API do NOT support filters in Views
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...
- Thu Aug 12, 2021 7:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW Forecast Feature - Ver. 2.0.62
- Replies: 3
- Views: 3323
Re: PAW Forecast Feature - Ver. 2.0.62
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 ...
- Tue Aug 10, 2021 8:16 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI Process Simple Code Changes not working as expected - Requesting your kind help
- Replies: 9
- Views: 5629
Re: TI Process Simple Code Changes not working as expected - Requesting your kind help
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 ...