Search found 221 matches

by EP_explorer
Wed Dec 04, 2024 12:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX in one dimension based on the subset of another dimension
Replies: 6
Views: 6070

Re: MDX in one dimension based on the subset of another dimension

Elessar wrote: Tue Dec 03, 2024 6:46 am Heeey, that was one of my quiz questions! Maren could have earned another point :)
You can give me a point for the good question :lol:
by EP_explorer
Mon Dec 02, 2024 8:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX in one dimension based on the subset of another dimension
Replies: 6
Views: 6070

MDX in one dimension based on the subset of another dimension

I have 2 dimensions with the same elements (Dim1 and Dim2) First dimension Dim1 using in Setup_Cube where put some flags on some elements. Exist subset Sub1 which filter elements in Dim1 based on flags. Is it possible to create MDX subset Sub2 in Dim2 which contains the same elements as Sub1 in Dim1...
by EP_explorer
Tue Nov 26, 2024 10:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 215
Views: 519987

Re: Ultimate Long TM1 quiz

In Versions since 2020 year (may be 2019 - I don't remember exactly) ProcessError() canceles all changes that has done during the process.

In early versions it didn't cancel changes.
by EP_explorer
Mon Sep 23, 2024 8:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 215
Views: 519987

Re: Ultimate Long TM1 quiz

Yes, may be several reasons of it For example 1) there are a lot of complex rules and feeders in Cube and then you load data in it they are calculated (of course you can switch off Rules (CubeRuleDestroy), load data and switch on (RuleLoadfromFile) - it may be more faster 2) You are trying to input ...
by EP_explorer
Fri Sep 13, 2024 9:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 215
Views: 519987

Re: Ultimate Long TM1 quiz

Yes - feeders will fire
by EP_explorer
Mon Jul 15, 2024 9:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 215
Views: 519987

Re: Ultimate Long TM1 quiz

Hi, Process launches with dataadmin rights. I would say more than this, the process actually runs as the admin user. But maybe that is only the case when a process is called from a master process? For my observation - as dataadmin. In some special cases like when are made some reseravations in a cu...
by EP_explorer
Sat Jul 13, 2024 6:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 215
Views: 519987

Re: Ultimate Long TM1 quiz

28 Process copys data in the cube although user doesn't see the cube of course. Process launches with dataadmin rights. 29 1. I usually put data in text from server 1 and launch process which upload text file on server 2 (the process launches in the same process on server 1 using RunTI). It is the m...
by EP_explorer
Fri Jun 28, 2024 12:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Run in parallel, using data of another updatable cube and Wait
Replies: 5
Views: 3459

Re: Run in parallel, using data of another updatable cube and Wait

Yes. I create TaskFile in Prolog and run ExecuteCommand with rushti in Epilog With Status Wait Do you create any Subset/View in the Prolog of the process? If these Views or subsets are referenced in the processes triggered by RushTI, then this might be the reason why your process goes on Wait. You ...
by EP_explorer
Tue Jun 25, 2024 3:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Run in parallel, using data of another updatable cube and Wait
Replies: 5
Views: 3459

Re: Run in parallel, using data of another updatable cube and Wait

Yes.
I create TaskFile in Prolog
and run ExecuteCommand with rushti in Epilog
With Status Wait
by EP_explorer
Tue Jun 25, 2024 9:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Run in parallel, using data of another updatable cube and Wait
Replies: 5
Views: 3459

Run in parallel, using data of another updatable cube and Wait

I wrote a process1 which launch 6 processes in parallel (I'm using RushTI if it is important to launch parallel processes) which updates Cube1 and use during update data which calculated in Cube2. Before launch process1 I need launch process2 which updates Cube2. If I launch process2 independently o...
by EP_explorer
Mon Jun 24, 2024 10:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 215
Views: 519987

Re: Ultimate Long TM1 quiz

As I Completely forget features on exp and logarithm and don't want to refresh my memory so I have another solution Question25_1.JPG The most part of IFs has aim to avoid multiplying for zero (as a I understand we don't want to receive zero as answer although it seems it is correct answer for input ...
by EP_explorer
Fri May 31, 2024 8:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 215
Views: 519987

Re: Ultimate Long TM1 quiz

In defence of idea of Elpar I could say: The dimension of sum elements in conditions of the tasks seems is based on the dimension of sum and details elements And if you add new sum element in sum and details dimension you have to after it change dimension of sum elements and elpar continue works if ...
by EP_explorer
Fri May 31, 2024 8:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 215
Views: 519987

Re: Ultimate Long TM1 quiz

The MarenC's idea looks like
04.jpg
04.jpg (171.14 KiB) Viewed 36371 times
by EP_explorer
Fri May 24, 2024 11:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Block user in PAL
Replies: 3
Views: 6995

Re: Block user in PAL

Yes
it works thank you
by EP_explorer
Fri May 24, 2024 8:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Block user in PAL
Replies: 3
Views: 6995

Block user in PAL

Is it possible to block user in PAL (TM1)? I.e. user hasn't come in system 90 days and its account has to be blocked by security policy. I don't want to delete account because may be the user will return and I have to put his account in all his groups again. I use 5 security mode and put users from ...
by EP_explorer
Mon May 20, 2024 9:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 215
Views: 519987

Re: Ultimate Long TM1 quiz

question20.JPG
question20.JPG (71.6 KiB) Viewed 37715 times
by EP_explorer
Thu May 16, 2024 9:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 215
Views: 519987

Re: Ultimate Long TM1 quiz

Elessar wrote: Thu May 16, 2024 8:30 am Anybody else? I think it's one of the hardest questions in this quiz

@MVPs, @Admins, can you share your thoughts also?
As we have to feed ‘a’ all the time (4 is unchanged) so
add new cube with input value, or element 'c' - input all values in it (1 for example)
and
[‘c’] => [‘a’];
by EP_explorer
Fri Apr 12, 2024 11:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Button - Process Failed - with No Log
Replies: 6
Views: 5631

Re: Action Button - Process Failed - with No Log

May be user doesn't have rights for the process.

In this case I see the same behaviour
User clicks on button, see error window and nothing in log file