Skip to Content
0

Alternate to Conditions in BEx Query Designer

May 11, 2017 at 10:57 AM

136

avatar image

Hi Experts,

I have a SD BEx query for inventory management. I am using this query to develop a dashboard for Trend of inventory over the past 5 years.

The requirement is to sort top 10 values for each fiscal year. I tried using Conditions to fulfill the requirement but later realized that Conditions are not supported when reporting through BEx to BO 4.0.

What would be the best alternative to sort the top 10 values and get them to use in Dashboards?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Koen Hesters May 11, 2017 at 12:45 PM
0

Hi,

note that Conditions are supported in SAP BusinessObjects Design Studio.

Grtz

Koen

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 11, 2017 at 12:50 PM
0
Share
10 |10000 characters needed characters left characters exceeded
John Hawk May 11, 2017 at 08:49 PM
0

Hi Faheem

What are you using for a Dashboard? Is it flexible enough to display multiple query results

Consider creating five queries with with dynamic filers:

1) Top 10 where Fiscal Year = Current

2) Top 10 where Fiscal Year = Current -1 offset

3) Top 10 where Fiscal Year = Current - 2 offset

4) Top 10 where Fiscal Year = Current - 3 offset

5) Top 10 where Fiscal Year = Current - 4 offset

Use your presentation tool to post the results side-by-side.

Let me know if this helps,

John Hawk

Share
10 |10000 characters needed characters left characters exceeded