Input Control for choosing indicator/variable

[Former Member]

Hi all,

I'm trying to build a requirement I think it's not technically possible with BO.

Nowadays users are running a report in another system not SAP neither BO, but this report is being migrated to BO.

In this report, they have the possibility of choosing what kind of percentage is shown in the last column: percentage over quantity, percentage over net value, % over price, etc.  They choose it in the selection screen selecting the variable.  And, besides that, report shows only the 80% total with a descending sorting.

What have I done?

As I don't think it's possible to put that in the selection screen, in my BEx query (my BO report is built over a BEx query) I've created variables with those percentages, in the way users can drag and drop them in the last column depending to what they want to see.

My questions are:

- Is it possible to create some filter in the selection screen? And, if not, is it possible to create some input control in the way user just click the variable they want to see instead of dragging and dropping (this would avoid authorizations issues)?

- Is it possible to have a pre-defined sorting independently the variable and, each time we change variable, the sort changes?  And, besides that, is it possible to create a condition that only shows lines where the accumulative percentage is lower than 80%?

Really tricky, I know. I'm afraid it's not possible anything of that.

Thanks

[Former Member · Accepted solution]

Hi Alberto,

at least I can tell you that it is possible to change the percentage accorting an input control:

Therefore

(1) create a dimension "Type of percentage" (="1")

(2) create an input control "Percantage selector" and choose eg combo box with "List of Values" = Custom.

Add 3 entries like % o. quantity, ... in the custom list of values

Select a default value

(3) create one keyfigure for all percentage with an if-statement like:

=If([Percantage selector]="% o. quantity") Then
[% over quantity]
Elseif ([Percantage selector]="..")
[% ..]
else
[%..]

(4) use the created keyfigure instead of the percentage keyfigures itself.

that should do your first reqiurement

I haven't try yet, but i guess if you sort your table by this new keyfigure it should change the sort every time you change your selection.

Same for the last point: Try to create a ranking on this keyfigure...

best regards,

Andreas

[Former Member · Accepted solution]

Hi Andreas,

That was awesome! Thanks so much.

With it I almost got the 100% of the requirement, really, really appreciated.

[Former Member]

Hi Alberto,

Please refer below post which gets exact same output using universe. You can apply the same concept on BEX as well:

http://www.bobidw.com/2013/09/webi-dynamic-measure-selection.html

http://blog.davidg.com.au/2011/07/dynamic-measures-in-webi-using-derived.html