TM1 Build Number: 11.8.02800.9 (2.0.9.20 IF2)
Search found 1155 matches
- Thu Jun 26, 2025 5:01 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: security overlay - what am I doing wrong
- Replies: 22
- Views: 69187
- Tue Jun 24, 2025 4:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: security overlay - what am I doing wrong
- Replies: 22
- Views: 69187
Re: security overlay - what am I doing wrong
For my 2 cents, it works for me. The GIF should demonstrate how I use the overlays to block off scenarios e.g. snapshots and periods on the rolling forecast that are not relevant and should not be input. My overlay cube for the demo only has two dimensions: Scenario and Period. Essentially when I bl...
- Thu Jun 12, 2025 4:38 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: security overlay - what am I doing wrong
- Replies: 22
- Views: 69187
Re: security overlay - what am I doing wrong
Try adding a rule with the following:
['OverlayData']=S:'1';
That should block all input across the defined dimensions, assuming no admin user. On PAoC, ensure the test user is not a subscription admin or similar too (CAMID groups).
['OverlayData']=S:'1';
That should block all input across the defined dimensions, assuming no admin user. On PAoC, ensure the test user is not a subscription admin or similar too (CAMID groups).
- Wed Jun 11, 2025 4:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: security overlay - what am I doing wrong
- Replies: 22
- Views: 69187
Re: security overlay - what am I doing wrong
And now there are two of us using security overlays... In my scenario I am using rules to set the OverlayData to 1 to block intersections. Data admin can write to these intersections but a TI process that runs as a pseudo-data admin cannot and you need to apply CubeLockOverride in cases where this m...
- Mon Jun 09, 2025 4:17 pm
- Forum: Useful code, tips and tricks
- Topic: An Introduction to MDX views
- Replies: 7
- Views: 29971
Re: An Introduction to MDX views
Part 9 just added In the last part of the Introduction to MDX Views series in Planning Analytics, we look at a practical example of joining data from multiple cubes into one view. The example looks at bringing in the underlying components of an allocation model to present them in a concise view all...
- Tue Jun 03, 2025 9:50 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: install PAW in windows server 2019
- Replies: 5
- Views: 4059
Re: install PAW in windows server 2019
That error message may also appear when the TM1 Login Server URI points to a TM1 instance that is not running/not available/wrong port etc.
Double-check that this instance is accessible from your new server: HTTPPortNumber, firewalls etc. etc.
Double-check that this instance is accessible from your new server: HTTPPortNumber, firewalls etc. etc.
- Mon May 26, 2025 2:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Attributes referencing in MDX queries
- Replies: 1
- Views: 1562
Re: Attributes referencing in MDX queries
Have a look for some guidance in this article. If you are trying to convert the value in the attribute to a member, you will need to use StrToMember() If you are trying to display the attribute in a view then you need to create a calculated member. Either way, the content in the articles should guid...
- Tue Apr 22, 2025 4:53 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1User() variable in Rules
- Replies: 3
- Views: 5760
Re: TM1User() variable in Rules
If you added the security group, why not just let it do what it should?
Sounds like you need two groups.
Have you test Trace Cell to see that they cannot see the underlying values?
Sounds like you need two groups.
Have you test Trace Cell to see that they cannot see the underlying values?
- Tue Apr 22, 2025 4:43 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to use a parameter cube in PAW MDX
- Replies: 3
- Views: 11328
Re: How to use a parameter cube in PAW MDX
To get a member from the subset try something this:
That should return the first member.
Will return the second member.
Code: Select all
{
TM1SubsetToSet([Scenario] , "Default").ITEM(0).ITEM(0)
}
Code: Select all
{
TM1SubsetToSet([Scenario] , "Default").ITEM(1).ITEM(0)
}
- Tue Apr 22, 2025 4:37 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to use a parameter cube in PAW MDX
- Replies: 3
- Views: 11328
Re: How to use a parameter cube in PAW MDX
Try Part 7 of my Introduction to MDX for more insights...
- Thu Apr 10, 2025 6:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: VBA Code for PAFE
- Replies: 5
- Views: 7055
Re: VBA Code for PAFE
HI, If you are using PAfE then the documentation I referred you to is valid. The names may say Cognos but what you need to automate PAfE is detailed in those references. This has nothing to do with Cognos Automation and it is purely confusing naming again by IBM.
- Thu Apr 10, 2025 5:07 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: VBA Code for PAFE
- Replies: 5
- Views: 7055
Re: VBA Code for PAFE
Start here - Should get you going with the prerequisites you need using the CognosOfficeAutomationExample.bas and CognosOfficeMessageSuppressor.cls files. Without these you will battle.
- Thu Apr 10, 2025 5:04 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }dimensionsecurity cube Created
- Replies: 4
- Views: 4108
Re: }dimensionsecurity cube Created
Is this not a side effect of someone attaching Performance Mangler (Modeler) to the model - sure I have seen this many times.
- Tue Apr 01, 2025 6:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Today is Special! Mathematical rules don't apply.
- Replies: 1
- Views: 2284
Today is Special! Mathematical rules don't apply.
Best to put your calculations and rules on hold until tomorrow and take the day off.
If you don't believe me, have a look at my proof using MDX with the most basic of math to test if 3 > 1 + 2
If you don't believe me, have a look at my proof using MDX with the most basic of math to test if 3 > 1 + 2
- Wed Mar 05, 2025 1:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Help on Creating a new landscape
- Replies: 7
- Views: 14295
Re: Help on Creating a new landscape
... My understanding is that in the medium term there is an expectation that PASS will become part of PAW. ... My understanding is the TM1Web, the UI to PASS will fall away and websheets will need to be embedded into PAW. To allow PAW to render these websheets, you will need PASS running as the &qu...
- Fri Feb 28, 2025 4:41 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rule Efficiency
- Replies: 8
- Views: 32376
Re: Rule Efficiency
I was pondering Declan's statement too and went back to Cubewise's 7 tips for writing faster rules , point 6. I have not had any cause to retest or dispute their 40% faster claim as I have seen similar results over the years. Are there edge cases we should know about or has something changed e.g. hi...
- Fri Feb 21, 2025 6:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic MDX for User Selection
- Replies: 13
- Views: 54409
Re: Dynamic MDX for User Selection
HI Maren, I tried this on PAW 2.0.101 with a reference to my User Preferences cube rather than an attribute on the }Clients dimension: WITH MEMBER [Scenario].[Scenario].[UserVersion] AS STRTOMEMBER("[Scenario].[Scenario].[" + [_S-User Preferences].( STRTOMEMBER("[}Clients].[" + U...
- Thu Feb 20, 2025 4:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic MDX for User Selection
- Replies: 13
- Views: 54409
Re: Dynamic MDX for User Selection
Yes, something like: WITH MEMBER [Version].[Version].[UserVersion] AS STRTOMEMBER("[}Clients].[" + USERNAME + "]").PROPERTIES("TestVersionA") MEMBER [Version].[Version].[Version Variance] AS STRTOMEMBER("[Version].[Version].[" + [Version].[Version].[UserVersio...
- Thu Feb 20, 2025 4:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic MDX for User Selection
- Replies: 13
- Views: 54409
Re: Dynamic MDX for User Selection
It is likely the nesting of the StrToMember
Try create another intermediate/calculated member to get the value of TestVersionA then use that in the outer StrToMember.
Try create another intermediate/calculated member to get the value of TestVersionA then use that in the outer StrToMember.
- Tue Feb 11, 2025 6:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to identify overfeeding
- Replies: 6
- Views: 16766
Re: How to identify overfeeding
Have a look at this article , specifically the section showing }StatsByCube. I create the calculated member Memory per Populated Cell to give an indication of whether or not reordering dimensions may help. Over 30 could prompt further review but it is not quite that simple as each dimension needs by...