TM1 Forum

I have IBM Cognos TM1 10.1.1 (fp1).
I made cube view with subset based on MDX expression. This expression consist of the filter based on the value of other dimension (measure) of this cube.
In the Architect and TM1Web all works fine. But when I try use this cube view in Performance Modeler or Cognos Insight I have got no elements in dimension baseed on MDX expression and error in tm1server.log "TM1.Mdx.Interface "<cube name>" : object not found (rte 77)".
I can't understand what is wrong. Can anybody help me?

Given that Performance Modeller and Cognos Insight are

a) basic, wizardised TM1 interface, and
b) new products

I think that it is possibly not (yet) supported behaviour. For example, there is no scope to code MDX in creating a Subset in Performance Modeller.

...there is no scope to code MDX in creating a Subset in Performance Modeller.

In Performance Modeller I can cteate Subsets based on MDX expressions. And there is interface to create such subsets.

hi

did you try setting UseLocalCopiesforPublicDynamicSubsets to F?
We had some problems with dynamic subsets in 10.1 and setting this to F resolved our issues. But to tell the truth, we expereinced those bugs in Architect too. Maybe it's worth giving a try. After changing the config file and rebooting your tm1 server, recreate your subset and view.

matyas

I just tried it out for myself, the only difference is that my expression consist of a filter based on the value in another cube.
My view appears empty in PM, tm1server.log says: TM1.Mdx.Interface Syntax error at or near:...
The Java error thrown by PM when I changed the subset to a default static then back to this dynamic is: java.util.NoSuchElementException

It works fine with Architect, no syntax errors.

As I see, you can edit an existing dynamic subset in PM but you can create a static only. How can you create a dynamic subset in PM?

please skip my last comment, I found how to attach an expression to a subset

Thank you for your discussion.
I can add more...
I can't select this (dynamic) subset for the cube view in PM. I did it in architect only successfuly. And only after that i tried to open this cube view in PM and Cognos Insight. In architect all works fine, but I can't see the same result in PM.
This is very important subset, which is used for dinamic filtering timescale in almost all cubes of my project. The timescale is not persistent and must be rebuilt in dependance of number conditions (including choosed of title dimensions elements).

is it a public subset?
it seems that no private subsets and views appear in PM

yes, I have no private objects in my model.

No one has idea

Can you post the MDX expression you are using.

You can use dynamic subsets in Performance Modeler. If you click on a subset in the tree and look at the properties there is an expression property. If it's got an expression in the subset is dynamic. If you click in the expression property field a button will appear which you can click on to edit the expression. Dynamic subsets also have a slightly different icon with a little arrow on.

So dynamic subsets do work in Performance Modeler but this one obviously doesn't so there must be something in the expression itself that Performance Modeler can't cope with. The error message you are getting is in the tm1server.log which means the expression is getting to the server. The server can deal with dynamic expressions, something must be getting lost in translation between Performance Modeler and the server. This is why I'd like you to post the MDX expression, I'd like to take a look and see if I can find out what.

I have also a dynamic subset which filters dimension elements based on value in another cube. It works fine in Architect but shows nothing in Cognos Insight (I did not test it in Performance Modeller). After corresponding with the ILC Support, they said the the product team logged this as a bug (Ticket #GMTH0ATE - Cognos Insight: Problem with Dynamic Subset)

@Andre Lie

Could you send me example of expression for "dynamic subset based on value in another cube" please?

Thanks

Mark

Mark H wrote:Could you send me example of expression for "dynamic subset based on value in another cube" please?

Relevant material is here and here.