TM1 Forum

I created a number of MDX-based subsets and views constructed from those subsets.
All work fine in Architect.
But under non-Admin user (for example, User1) I have troubles in Contributor.
For example:

•Initial view opens (MDX-subset used in filters (context)). But when I try to move dimension with MDX-subset from filters to rows, I receive error message: "Operation Failed. System has encountered a problem while handling your request. Please try again…";
•When I choose some MDX-subset for dimension placed at rows it shown correctly in Subset Editor, but when I press OK button I receive the same error message;
•When initial view include dimension with MDX-subset on rows (columns) it hangs on opening ("opens" endlessly).

It seems that reason is User1 doesn’t have access to some elements (members) involved to MDX-based subset (Element Security is used). And Contributor can’t handle it correctly as opposed to Architect.
It seems that when User1 have access to all members envolved to MDX set there are no problems.
Note that all MDX expressions constructed as invariant to specific members, i.e. enumeration of concrete members is not used.
The problem appear even in trivial situatuions such as TM1SubsetAll([MyDimension]).

Does anybody have any idea how to fix this problem?
I am using Cognos Express 9.5.0. There is no such a problem in TM1 9.5.2…

Stop using MDX based subsets as approval hierarchies in CX 9.5 Planner aka TM1 9.5 Contributor as TM1 10.1 Applications (formerly known as TM1 Contributor) no longer supports MDX based subsets, see the manual IBM Cognos TM1 Installation and Configuration Guide 10.1.0 ->


http://publib.boulder.ibm.com/infocente ... ps101.html
Cognos TM1 Installation and Configuration Guide 10.1.0
Upgrading >

Upgrading Cognos TM1 Contributor to Cognos TM1 Applications

Upgrading Cognos TM1 Contributor to Cognos TM1 Applications requires a series of steps. These steps include a process to move your old application files into Cognos TM1 Applications.

Before you begin
Review the following considerations before you upgrade your application files from Cognos TM1 Contributor to Cognos TM1 Applications.

Attention: You might need to edit your old applications to make them compatible with the newer version.

* Dynamic Subsets cannot be used as the approval hierarchy in Cognos TM1 Applications.

Thanks.
But I don't use a MDX-based subsets in approval hierarchies.
My question concerned to regular dimensions. (But affected by Element Security).

CognosConnect wrote:I am using Cognos Express 9.5.0. There is no such a problem in TM1 9.5.2…

CX 9.5.0 Xcelerator is a customized version of TM1 9.5.1
The base version of CX 9.5.0 Xcelerator (no Interim Fix installed) is a customized version of TM1 9.5.1 HF9
What happens when you compare CX 9.5.0 Xcelerator to TM1 9.5.1 ?


Which version of TM1 9.5.2 did you test ?
Did you test TM1 9.5.2 FP1 ?

Because TM1 9.5.2 FP1 addresses the software defect logged as APAR PM33611:

http://www-01.ibm.com/support/docview.w ... wg1PM33611
PM33611: DYNAMIC SUBSETS DO NOT REFRESH CORRECTLY IN TM1 CONTRIBUTOR

Error description
Dynamic subset is not updated correctly when you change /deploy element of the dimension (element present in row)