Search found 113 matches

by tm123
Tue Aug 14, 2018 6:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RPTRow with MDX Expression that Returns zero elements
Replies: 8
Views: 1080

Re: TM1RPTRow with MDX Expression that Returns zero elements

If Excel is crashing if the set is null then you could quite easily work around this by doing a Union with a dummy employee (e.g. +{[employee].[no employee]} ) at the end of your existing MDX. If you don’t have a dummy element in the dimension you could create it. You could even then apply special ...
by tm123
Tue Aug 14, 2018 1:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RPTRow with MDX Expression that Returns zero elements
Replies: 8
Views: 1080

Re: TM1RPTRow with MDX Expression that Returns zero elements

Thanks for your replies, The MDX statement is fine, it works fine if it returns at least one element. What I am doing is, I am filtering by cube Value, (STring Measure). My Cube is an Employee Details Cube and I have a few String Measures (EMployee Class, Pay Cycle etc). And users like to filter emp...
by tm123
Wed Aug 01, 2018 5:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RPTRow with MDX Expression that Returns zero elements
Replies: 8
Views: 1080

TM1RPTRow with MDX Expression that Returns zero elements

Hi, I am having an issue (seems to be a bug of TM1 10.2.2 FP7). I have a websheet where I have an Active Form and some Drop Down cells that I use to compose the MDX To be used in my TM1RPTRow. When the MDX returns no Elements, then the Active Form does not work. When I run this from Perspectives, ex...
by tm123
Fri Jun 08, 2018 1:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension subset editor in TM1 Perspectives
Replies: 9
Views: 900

Re: Dimension subset editor in TM1 Perspectives

Also another reason is Protecting the Sheet. If you procect the sheet, you have to make sure that all the cells with SUBNM formulas are unlocked, otherwise you get a VBA error when you double click and after that point, you have to re-launch Perspectives. But in TM1Web, the SUBNM will work fine even...
by tm123
Thu Jun 07, 2018 7:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension subset editor in TM1 Perspectives
Replies: 9
Views: 900

Re: Dimension subset editor in TM1 Perspectives

In my opinion, SUBNM formulas in TM1 Perspectives never work properly. I usually get Visual Basic Error when I double click on a SUBNM cell from Perspectives so I do all my testing from TM1Web
by tm123
Thu Jun 07, 2018 1:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: GetProcessErrorFileName()
Replies: 9
Views: 920

Re: GetProcessErrorFileName()

Try this: sPath = CELLGETS('Global Variables', 'Value', 'Path to Hierarchy Files'); IF(FILEEXISTS(sPath | pFileName) = 0); DATASOURCETYPE= 'NULL'; ITEMREJECT('File is missing'); PROCESSBREAK; ELSE; DATASOURCENAMEFORSERVER= sPath | pFileName; ENDIF; That doesn't work, the process still tries to open...
by tm123
Wed Jun 06, 2018 5:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Checking Element Level Security in a TI processes
Replies: 6
Views: 763

Re: Checking Element Level Security in a TI processes

This is what I have been doing also, but you can avoid the Union with ADMIN Group. You can create empty MDX-based subsets through TI by using this syntax: SUBSETCREATEBYMDX ( subName , sMDX , dimName ) ; So when you specify the third parameter, TM1 will not throw an error when MDX does not return el...
by tm123
Wed Jun 06, 2018 4:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: GetProcessErrorFileName()
Replies: 9
Views: 920

Re: GetProcessErrorFileName()

Try this:

sPath = CELLGETS('Global Variables', 'Value', 'Path to Hierarchy Files');

IF(FILEEXISTS(sPath | pFileName) = 0);
DATASOURCETYPE= 'NULL';
ITEMREJECT('File is missing');
PROCESSBREAK;
ELSE;
DATASOURCENAMEFORSERVER= sPath | pFileName;
ENDIF;
by tm123
Wed Jun 06, 2018 1:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Warning - read only users
Replies: 6
Views: 992

Re: Warning - read only users

The other problem with Read Only Users is that the Write-Back will be completely disabled for them. I know we can't complain about this, but since in my models I usually create a cube to store User Selections and use those Selections in MDX Subsets (for example to implement Cascaded Prompts), that ...
by tm123
Tue Jun 05, 2018 3:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Warning - read only users
Replies: 6
Views: 992

Re: Warning - read only users

The other problem with Read Only Users is that the Write-Back will be completely disabled for them. I know we can't complain about this, but since in my models I usually create a cube to store User Selections and use those Selections in MDX Subsets (for example to implement Cascaded Prompts), that b...
by tm123
Thu May 31, 2018 1:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Making a Cascaded Filter(Filter depends on another filter) in TM1
Replies: 5
Views: 1262

Re: Making a Cascaded Filter(Filter depends on another filter) in TM1

Are you trying to achieve this in a CubeView or in a Websheet? You need to have some attribute (or to build a cube that holds your dimensions relationships). Then build MDX Statement to filter only Areas of your Selected Department. You can store the Selected Department in a cube with a DBSS. (I us...
by tm123
Wed May 30, 2018 5:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Making a Cascaded Filter(Filter depends on another filter) in TM1
Replies: 5
Views: 1262

Re: Making a Cascaded Filter(Filter depends on another filter) in TM1

Are you trying to achieve this in a CubeView or in a Websheet? You need to have some attribute (or to build a cube that holds your dimensions relationships). Then build MDX Statement to filter only Areas of your Selected Department. You can store the Selected Department in a cube with a DBSS. (I usu...
by tm123
Wed May 16, 2018 4:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security Access Flag not being Deployed
Replies: 6
Views: 1070

Re: Security Access Flag not being Deployed

The only line that changes is the encrypted line i posted in my prior post, but that line changes even if you save without making any change to the process ( i mean you dont change any thing in the TI, and you dont change the security access setting.) But my issue is why do you have to save the TI w...
by tm123
Wed May 16, 2018 2:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security Access Flag not being Deployed
Replies: 6
Views: 1070

Re: Security Access Flag not being Deployed

Not sure if this has changed at some point but I've always had to do this since this bit of logic was introduced. Not sure where the security access state of a TI is stored, I would have though there ought to a }Process_Properties cube somewhere but I've never spotted where. AFAIK the security stat...
by tm123
Wed May 16, 2018 12:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: show recently added elements in subset.
Replies: 5
Views: 704

Re: show recently added elements in subset.

Why don't you add an attribute to the dimension and use it for Filtering or SOrting? You cannot rely on the Element Index since it changes How attribute will identify the new element? it is not necessary in source data that new elements will come at last if i assign attribute as incremental numbers...
by tm123
Wed May 16, 2018 12:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: show recently added elements in subset.
Replies: 5
Views: 704

Re: show recently added elements in subset.

Why don't you add an attribute to the dimension and use it for Filtering or SOrting? You cannot rely on the Element Index since it changes
by tm123
Wed May 16, 2018 12:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security Access Flag not being Deployed
Replies: 6
Views: 1070

Security Access Flag not being Deployed

Hi guys, I am facing a strange issue. I have a few TI Processes that update some dimensions with ElementSecurity (}ElementSecurity bubes being populated by Rules). The TIs are also refreshing security, and since the user who runs the TIs is not an admin, I enabled the Flag "Security Access" on each ...
by tm123
Wed May 02, 2018 1:32 pm
Forum: Enhancements
Topic: Determine whether a TI process exists
Replies: 10
Views: 5633

Re: Determine whether a TI process exists

Follow up: ProcessExists has been added recently to the TI functions. Thank you IBM. It would be nice if they also added a TI Function to delete a TI Process (such as ProcessDestroy or ProcessDelete). I have some TI Processes that their names start with } (like control objects) and they cannot be d...
by tm123
Mon Apr 09, 2018 4:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help on Rule in }ElementSecurity_Dimension
Replies: 2
Views: 490

Re: Help on Rule in }ElementSecurity_Dimension

You can try something like below. I try to hardcode element names in Rules so you might have to use some mapping cube or dimension attributes to map Regions to User Groups [ 'Group_Name' ] = S: IF ( ELISANC('DimName', !DimName, 'Benelux') = 1 % ELISANC('DimName', 'Benelux', !DimName ) = 1 % !DimName...
by tm123
Tue Apr 03, 2018 2:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Get all SQL from TI processes
Replies: 4
Views: 910

Re: Get all SQL from TI processes

That's why externalizing the SQL Code is a good practice. For all our processes, we have a Control Cube where we keep the Data Source Type and also the Data SOurce Query (which will be SQL Query for processes with ODBC Data Type, MDX Statement or a saved subset name for Processes using a Dimension a...