Search found 1155 matches

by gtonkin
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

Re: security overlay - what am I doing wrong

stingo wrote: Wed Jun 25, 2025 4:07 pm ...what version are you running?
...
TM1 Build Number: 11.8.02800.9 (2.0.9.20 IF2)
by gtonkin
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...
by gtonkin
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).
by gtonkin
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...
by gtonkin
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...
by gtonkin
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.
by gtonkin
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...
by gtonkin
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?
by gtonkin
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:

Code: Select all

{
TM1SubsetToSet([Scenario] , "Default").ITEM(0).ITEM(0)
}
That should return the first member.

Code: Select all

{
TM1SubsetToSet([Scenario] , "Default").ITEM(1).ITEM(0)
}
Will return the second member.
by gtonkin
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...
by gtonkin
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.
by gtonkin
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.
by gtonkin
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.
by gtonkin
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
by gtonkin
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...
by gtonkin
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...
by gtonkin
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...
by gtonkin
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...
by gtonkin
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.
by gtonkin
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...