Filter by attribute in worksheet? TM1 web

[BigG]

Hi there,

We know DBRA() function will bring back the attribute value for a element. But is there a way you can dynamically filter results based on an attribute referenced in the report? eg. a picklist of text attribute allows for the returned subset to filter based on the attribute value. Is this a MDX formula that can be built into the report ? Havent found an answer yet so just guessing...

Shoot any questions if this is not clear.

thanks in advance

G

[Andy Key]

Assuming you are using Active Forms, then your TM1RPTROW formula can use an MDX statement as the basis for its selection. This MDX statement can then contain a reference to the cell that contains your chosen attribute.