Skip to Content
0
Former Member
Nov 01, 2012 at 10:42 AM

What can be used instead of 3 structures within a bex query?

61 Views

Hi,

The users what to add in ‘groupings’ to a pre-existing bex query. Within this query there is already a key figures structure. To provide the groupings I created another structure which provided all of the options within ‘Group 1’ like figure 1.

Figure 1:

Group 1

Key Figure

Jan-12

Feb-12

Mar-12

Apr-12

May-12

Jun-12

All Countries

Actuals

2900

3100

3450

2800

3200

3350

Top 15 Countries

Actuals

1900

2000

2300

1800

1900

2300

Top 40 Countries

Actuals

2300

2300

3000

2300

2300

3000

Company

Actuals

2300

1200

  1. 1552.5

1200

1485

1200

Key Competitors

Actuals

1100

1300

1100

1300

1100

1300

Others

Actuals

900

1100

1300

900

1100

1300

However they want to be able to compare the groups. For example how is the company doing in the top 15 countries compared to the key competitors. The report needs to look like figure 2.

Figure 2:

Group 1

Group 2

Key Figure

Jan-12

Feb-12

Mar-12

Apr-12

May-12

Jun-12

All Countries

Company

Actuals

1000

1100

1150

1000

1100

1150

Key Competitors

Actuals

900

1100

1300

900

1100

1300

Others

Actuals

1000

900

1000

900

1000

900

Top 15 Countries

Company

Actuals

100

110

115

100

110

115

Key Competitors

Actuals

90

110

130

90

110

130

Others

Actuals

100

90

100

90

100

90

Top 40 Countries

Company

Actuals

250

275

  1. 287.5

250

275

  1. 287.5

Key Competitors

Actuals

225

275

325

225

275

325

Others

Actuals

250

225

250

225

250

225

It is not possible to add in another structure and hierarchies are not an option either. Anyone have any suggestions has to how two groups can be provided?

Thanks

Sara