Showing results for 
Search instead for 
Did you mean: 

Variable rows in the Bex query

Former Member
0 Kudos

Hello BW Experts,

I have 12 versions of sales amount in the cube. Is it possible to have a Bex query, where the user can select mulitple versions to compare.


case 1: if the user wishes to compare version 01, 03, 05

case 2: if the user wishes to compare all the 12 versions

The users selects how many version he wants to compare. each version should be displayed in the query.

Suggestions highly appreciated.



Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos

Hi BWer,

You can have a multiple selection option variable on Version, and in your query design place Version in the Columns, above the Sales Amount Key Figure.

Hope this helps...