TM1 Forum

Pleasure - glad it worked!

How about using StrToMember to derive the members based on the text in the control cube or attribute? You can then just separate each derived member with a comma and enclose in braces to return both in a set. { StrToMember("[report_HDD_fiscalPeriodByDay].[" + [CONTROL].([Control Parameters...

Name is an intrinsic attribute and would typically return the MemberID (actual name) if you were working in a set in PAW. What may have changed is an update to MDX that impacted the Description alias as detailed here . Sounds like some changes were made that "corrected" some less strict im...

Is your alias by any chance called "Description"?

That functionality may no longer work as it will not allow me to save the process Are you working on V11/V12? Possible, but does it give an error because you are working in PAW and PAW does not recognize? You may see the red error circle but save works and TI runs, at least on my PAW 2.1.13 and PA ...

And I guess this is why many have changed over the years to a "Period" or similar continuous dimension...
Pros and Cons, but you are stuck with a major con unless you can redesign or move to a reporting cube.

Maybe someone else has a smart idea...

HI Maren, Based on the date provided 31/12/2024, I would expect you to be working with a continuous time dimension, not separate dimensions for year, period etc. I am then specifically talking about Hierarchies, not Rollups. If you were going to use rollups you would have clashes between periods and...

I would say this is an opportune use case for an alternate hierarchy. Because C level members are unique in each hierarchy, you do not need to worry about them clashing. The only gotcha is how you will be implementing. Will need PAW/PAfE and URs in PAfE to deal with the alternate hierarchies. Edit: ...

As a test, in dev, with all the usual disclaimers, you could try using this function to set whilst in the process:
The function takes a string value e.g. '8', 'ALL'
As with all undocumented functions, YMMV...

I would also like to echo my thanks to the Admins who I do know have performed many tasks behind the scenes over the years to keep this forum up and running. It will be sad to watch the life flicker out but thankful to have been part of this forum and to its members who have assisted me in learning ...

Thanks for the kind words Jim - hoping to convert everyone into MDX gurus - its the way of the future

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)

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

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

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

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

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.

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

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.