Filter a bunch of issues

Questions & Answers
1

Hi,
I have an account with 5 projects. The requirement is to filter the report with around 100 Issues from one specific report. How can I do that without a Bookmark?

I was thinking to use an Aggregate function and add the specific Ids, but it didn’t work.

Aggregate(
{
[Issue].[Issue].[ABC-1],
[Issue].[Issue].[ABC-2],
[Issue].[Issue].[ABC-3],
[Issue].[Issue].[ABC-4]
}
)

Note: Numbers are not consecutive.

Any suggestions?

2

Hi,

The aggregated members can refer to the member key with the following syntax:

Aggregate(
{
[Issue].[Issue].&[ABC-1],
[Issue].[Issue].&[ABC-2],
[Issue].[Issue].&[ABC-3],
[Issue].[Issue].&[ABC-4]
}
)

Kindly,
Janis eazyBI support

1 Like