Toggle or Indicator option:

building reports webintelligence
1

Version: XIR2SP4

Is there a way to create on Webi document something to click “Yes” --> “No” and “No” --> “Yes” to toggle how a measure would behave. Essentially end user would leverage this toggle to change how a derived measure would behave. End user would click the Toggle then it would flip to the opposite value.

For example,
When
Toggle is “No”, then derived measure would be calculated as (a / b)
Else If
Toggle is “Yes” then derived measure would be calculated as (a / b * c ).

The toggle wouldn’t be an attribute in the data as it wouldn’t make sense and the concept we could leverage in multiple ways to expand on user functionality.

The only current option I can think of is using custom SQL union query to make up an attribute with yes no values, but I’d only use that technique if all else fails as custom SQL is considered worst practice here. Also the drill filter option, everyone hates the “All Values” option for something like this where a value has to be chosen.

987bobj (BOB member since 2008-09-19)

2

You could do something with prompts. In XI 3.2, some new functionality has been introduced which I reckon would do pretty much exactly what you want.

Nick Daniels :uk: (BOB member since 2002-08-15)

3

Thanks for the response. To make this even more challenging, reports will be scheduled for the end user and they will only have access to the instance and will not be able to drill out of scope either.

Prompts are not an option. Datasource is too slow and DBAs don’t want same queries run against the database by multiple users. Another faster datasource is not an option either.

987bobj (BOB member since 2008-09-19)

4

Then consider upgrading to XI R3 SP2 :smiley:

Andreas :de: (BOB member since 2002-06-20)

5

Although an upgrade is planned, its still 9 months out for completion, so for our current version is there a solution? We can’t upgrade at the drop of a hat like our SAP support always suggests like it is not a big deal.

987bobj (BOB member since 2008-09-19)