TM1 Forum

Posted: **Mon Oct 14, 2013 8:38 am**

Hi everyone,

I have two cube :

Cube A: i input data start year = 2013 (type simple)
Cube B: I want filter Dimension Year and start year 2013. I am using subset dynamix -> Expression windown -> write FILTER but i can't .

({FILTER( {TM1SubsetAll( [SL_Times] )}, [SL_Times].

Code: Select all

 = DB('DienGiaiGiaDinh',!DuAn,'NamBatDauThucHien','Value'))}) 

[attachment=0]Hinh.jpg[/attachment]

How do it ????

Posted: **Mon Oct 14, 2013 1:38 pm**

You are mixing up MDX language and TM1 rules language.
Search for "MDX Primer" and this will help you out.

Posted: **Mon Oct 14, 2013 9:39 pm**

ChausBSD,

As lotsaram pointed out you are mixing two different languages. DB(..) is used in TM1 rules.

Try something like that .... [SL_Times].

Code: Select all

 = [CubeName].(StrToMember("[Dim1].[Element],[Dim1].[Element2],etc "),[Measure].[Value/String] ))}

Referencing cube values in the mdx is bit of a pain in the butt, so you may have to play around with the syntax/ read "mdx primer" to get it working the way you want it.

Do you agree lotsaram?

ET

TM1 Forum

Filter Dimension Year in cube

Filter Dimension Year in cube

Re: Filter Dimension Year in cube

Re: Filter Dimension Year in cube