Filter a key figure based on a dynamic list of values

building reports webintelligence
1

Hi all,
i have the requirement in a webi report to filter a kf using another dimension.
Let me explain: i have [Key figure1] and [Dimension1] in [Query1] and in another [Query2] i also have [Dimension1]; what i need is to do something like this:

[Key figure1] Where ([Query1].[Dimension1] InList([Query2].[Dimension1]))

Do you think is possible?

Thanks

Stefano S :it: (BOB member since 2008-10-09)

2

This can be done if Query 2 can be a subquery of Query 1. That means they are from the same universe.

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

3

No they’re are not form the same universe :frowning:
I’m working with Sap BW has source of data so can’t use subqueries anyway

Thanks
Stefano

Stefano S :it: (BOB member since 2008-10-09)

4

What is the result if you use the formula as you wrote??


=[Key Fig] Where([Dim1].[Qry1] InList or EqualTo [Dim1].[Qy2])

Thanks

BOCP (BOB member since 2007-07-02)