Remove Row from Table --> use Dimension as Page

I am trying to build a pie chart with our Test Executions, and I have to exclude one specific key.
When I view it as a table, I can remove the specific key without any problem. But as I want to have a nice pie chart, I need to put the Test Executions as a page, so I have only Measures and Statuses inside of my Pie Table.

Is there any way to remove one specific key from a page or do I have to select everything except this one key? or is there a formula for a calculated member I can use?

Best regards,
Anna

Hi Anna,

To remove a member from Page you can create a calculated member using Except(…) function. For example the following would remove test with ID XT-1 from Xray Test dimension

Aggregate(Except(
  [Xray Test].[Test].Members,
  [Xray Test].[Xray Tests].[XT-1]
))

Lauma / support@eazybi.com

Hi Lauma,

thank you for your reply. It is not quite working.
When I use the calculated member:

Aggregate(Except(

[Xray Test Execution].[Execution].Members,
[Xray Test Execution].[Execution].[JQM-7227]
))

I get this Error:

#ERR: mondrian.olap.fun.MondrianEvaluationException: Aggregation is not supported over a list with more than 1000 predicates (see property mondrian.rolap.maxConstraints)

I see. In case the dimension is this large, you can use more simple subtraction

[Xray Test Execution].DefaultMember - 
[Xray Test Execution].[Execution].[JQM-7227]

Lauma / support@eazybi.com

Thank you very much, this is working perfectly :slight_smile:

2 Likes