Dynamic subset not work during process TI

[Maxime]

Hi all !

It's my first post here, and i like this forum for help me in TM1 !

I have an error with dynamic subset who use cube's data.
When a TI run, the dynamic subset is empty but he must have element.
Is good other time.

This is an exemple of dynamic subset :

Code: Select all

{TM1SORT({ FILTER( {TM1SUBSETALL( [INV_DI] )}, [INV_DI].[RELAI] = [INV_RELAI].CurrentMember.Name AND [INV_DATA].([INV_VERSION].[Version Courante],[INV_ANNEE].[INFO],[INV_MOIS].[M1],[INV_Relai].CurrentMember,[INV_DATA].[StatutNum])>0 AND [INV_DATA].([INV_VERSION].[Version Courante],[INV_ANNEE].[INFO],[INV_MOIS].[M1],[INV_Relai].CurrentMember,[INV_DATA].[StatutNum])<13)}, ASC)}

The server is CX 10.1 with windows 2008 R2.

Thank you all !

Ans sorry for my english.

[tomok]

I've never tried to use a dynamic subset in a TI process that employed the CurrentMember property. My guess is that the data source in the TI is missing the context to be able to evaluate that function. When you use that property in a subset that's part of a cube view then it can evaluate the CurrentMember property and it works. My guess is that you're going to have to remove the CurrentMember function and replace it with an actual element name.

[Maxime]

I misspoke.

This dynamix subset is use in view in TM1Web and works good.

But if a TI run in the server, then this dynamic susbet is empty.
The TI doesn't run on the same cube what the view.

I don't inderstand why the dynamic subset don't work in this case.

[tomok]

The TI doesn't run on the same cube what the view.

Then what does it run on? As I explained to you, the CurrentMember property, for the dimensions being referenced OTHER than INV_DI, need to have context to be able to resolve to an actual element of that dimension. Without that, the >0 comparison will always be FALSE, thus no elements for INV_DI. Comprende?

[Maxime]

The dynamic subset is not use in the TI.

I explain much.

I have a view who is use in TM1Web with this dynamic subset.
The view is good and the subset work.

But, if a TI lambda work on the server, the subset doesn't work in the view.

When the TI lambda finish, the subset work in the view.

So the dynamic subset work in the view except if a TI run.

[tomok]

Well then if what you are saying is true, that the dynamic subset works in a view when you view it in the Cube Viewer, but does not when you use THE EXACT SAME VIEW in a TI process, then you can't use the CurrentMember property and will need to replace all those with actual element names.