TM1 Forum

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?

To get a member from the subset try something this: That should return the first member.
Will return the second member.

Try Part 7 of my Introduction to MDX for more insights...

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.

Start here - Should get you going with the prerequisites you need using the CognosOfficeAutomationExample.bas and CognosOfficeMessageSuppressor.cls files. Without these you will battle.

Is this not a side effect of someone attaching Performance Mangler (Modeler) to the model - sure I have seen this many times.

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

... 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...

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...

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...

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...

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.

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...

Thanks for sharing Wim!

Good overview Burnstripe - On the requirements, besides a recent version of PAfE, your TM1 server should be recent too >2.0.9.18 and your PASS/TM1Web would likely need to be around 2.0.99 or newer, iirc...

Currently chores need to be opened to see the time at which they are scheduled. In most cases an administrator needs to look at a review of all chores to see when they are scheduled to run i.e. a table of Chore Name, Active Indicator, Frequency, Scheduled Time, Commit mode etc. The user should be ab...

Going to echo Maren here - I think I largely follow what Bedrock is doing by coincidence and because it makes sense to have p for parameters etc. I also used to be really excited to put everything in a variable, sCube=this and sCube=that etc. just in case you need to update it later. Never happens a...

Try Kathryn's article for insights on making asymmetrical views.

Can you maybe post a spreadsheet example or some screenshots of what you have and what you expect, may be easier to assist.

...you should avoid IFs in TM1... Sentiment is valid. Avoid IFs where possible. Here is a "nice" feeder example I saw in a previous model: #--Feed XYZ Measure ['XYZ Amount','Actual'] => DB( IF( ATTRS('Period',!Period,'Planning')@='Y' & DB('Cube', !Dim1, ..., !DimN-1, 'XYZ Amount')<>0,...