Search found 122 matches

by tm123
Tue Sep 15, 2020 10:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics / Cognos Analytics Dependency
Replies: 1
Views: 59

Planning Analytics / Cognos Analytics Dependency

Hi guys, We are looking to upgrade Planning Analytics to the latest version ( 2.0.9.2 ) and also upgrade PAW and PAX to the latest versions. Do we need to upgrade also Cognos Analytics? We use Security Mode 5 but we do not use Cognos BI ( Cognos Analytics ) for anything else, so I am not sure what i...
by tm123
Fri Aug 21, 2020 10:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Point Workspace Views to different TM1 Server
Replies: 1
Views: 280

Point Workspace Views to different TM1 Server

Hi, I need some help in regards to object migration from one server to another, in PAW: I have both databases ( Dev and Test) on the same server, one called FnP_Dev and the other one FnP_QA I created all the books and views in DEV and now when I try this Lifecycle Management to migrate them to QA, y...
by tm123
Fri Aug 21, 2020 10:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy your PAW book design to another TM1 server
Replies: 9
Views: 514

Re: Copy your PAW book design to another TM1 server

Hi, Thanks for sharing this. I have both databases ( Dev and Test) on the same server, one called FnP_Dev and the other one FnP_QA I created all the books and views in DEV and now when I try thing Life Cycle Management to migrate them to QA, yes the package gets created and it gets migrated, but all...
by tm123
Tue Aug 04, 2020 10:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security in Planning Analytics Workspace
Replies: 4
Views: 182

Re: Security in Planning Analytics Workspace

I don't know if it was available in 2.0.41 like you have, but recent releases of PAW definitely have user groups. https://quebit.com/askquebit/IBM/planning-analytics-workspace-security/ Thank you, yes I also came across the link you provided, and but what I cannot find anywhere is if there is a con...
by tm123
Tue Aug 04, 2020 7:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security in Planning Analytics Workspace
Replies: 4
Views: 182

Security in Planning Analytics Workspace

Hello, It looks like the Folder Security / Book Security in PAW has to be specified by user ( instead of User Groups ). Is there a way for configure PAW so that the Security Access to a certain Folder / Book in PAW can be granted for a Group instead of individual users? The version of PAW we gave is...
by tm123
Wed Jul 15, 2020 5:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error while trying to build a Named Hierarchy in a TI process
Replies: 4
Views: 459

Re: Error while trying to build a Named Hierarchy in a TI process

Hi guys, It looks like Paul Simon has experienced the same issue, and I found something online regarding this. He also provided a workaround, but before coming across his thread, I deleted the Dimension and re-created it. When i recreated the dimension, on the same time I did what Paul suggested and...
by tm123
Wed Jul 15, 2020 12:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error while trying to build a Named Hierarchy in a TI process
Replies: 4
Views: 459

Re: Error while trying to build a Named Hierarchy in a TI process

Thanks for the reply: #== Code in Prolog Tab HierName = 'By Product Category' ; IF ( HierarchyExists ( dimName, HierName ) = 0 ) ; HierarchyCreate ( dimName, HierName ) ; ELSE ; HierarchydeleteAllElements ( dimName, HierName ) ; ENDIF ; HierarchySortOrder ( dimName, HierName , 'ByInput' , 'Ascending...
by tm123
Wed Jul 15, 2020 12:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error while trying to build a Named Hierarchy in a TI process
Replies: 4
Views: 459

Error while trying to build a Named Hierarchy in a TI process

Hi, I am facing an issue while I am trying to build a new hierarchy in a TI Process. I have a dimension which has multiple ALternate Hierarchies ( what we used to call Alternate Hierarchies), and I am trying to convert them into Named Hierarchies. I am able to convert them all, without any issues, b...
by tm123
Mon Jul 13, 2020 4:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web Websheet Snapshot to Excel taking too long
Replies: 2
Views: 245

TM1Web Websheet Snapshot to Excel taking too long

Hi Guys,

We have a websheet with an Active Form ( which has a few thousand lines ). The websheet opens fine and refreshes quickly, but when user tries to Snapshot it to excel, it takes way too long, more than an hour.

We are using PA 2.0.5 so has anyone experienced this?

Thanks
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: 2302

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: 2302

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: 2302

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: 2107

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: 2107

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: 2218

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: 1757

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: 2218

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: 2004

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: 2004

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: 2620

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