Search found 6 matches

by tm1dev
Tue Apr 22, 2025 3:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1User() variable in Rules
Replies: 3
Views: 5395

Re: TM1User() variable in Rules

Thank you for the quick replies!
by tm1dev
Mon Apr 21, 2025 9:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1User() variable in Rules
Replies: 3
Views: 5395

TM1User() variable in Rules

I am experimenting with TM1User() in a rule in a development environment. I'm implementing Element security using the Department dimension. I'm assigning users to a group called 'D200' where they can see all data for Department D200 including Salary. However, I want to restrict some users assigned t...
by tm1dev
Mon Nov 21, 2022 4:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Returning attribute value for MDX statement
Replies: 2
Views: 1786

Re: Returning attribute value for MDX statement

Thank you declanr, that worked! I am using the Rest API to return data with this MDx statement.
by tm1dev
Mon Nov 21, 2022 3:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Returning attribute value for MDX statement
Replies: 2
Views: 1786

Returning attribute value for MDX statement

Hello. I am trying to return my Time dimension's "Month Status" attribute value in the results of this MDX statement: SELECT non empty {[Scenario].[Scenario].[Budget]} on 0, non empty {TM1FILTERBYLEVEL(TM1SUBSETALL([Supplements].[Supplements]) , 0)} * {TM1FILTERBYLEVEL(TM1SUBSETALL([Time]....
by tm1dev
Wed Apr 27, 2022 4:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RETURNVIEWHANDLE using a MDX view
Replies: 5
Views: 1949

Re: RETURNVIEWHANDLE using a MDX view

Thank you, I just voted. However there are only 13 votes :(.
by tm1dev
Wed Apr 27, 2022 4:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RETURNVIEWHANDLE using a MDX view
Replies: 5
Views: 1949

RETURNVIEWHANDLE using a MDX view

Hello. It appears that views created via ViewCreateByMDX do not play nice with drill through-processes. The view passed in to the RETURNVIEWHANDLE function is not recognized. Is this expected behavior? Thank you in advance!