/* */


Aug 13 2013

Dynamic Variable using Input Control

Category: Business ObjectsTauseef @ 3:25 pm

Applies to:

SAP Business Objects BI 4.0

Summary:

Recently one of my colleagues asked me if there was a way we could manipulate value being used in the formula of a variable using input controls because similar thing can be accomplished using Tableau. My first thought to this is why do you want to use input control when you can achieve this by modifying the universe for which he said the users don’t have access to modify the universe and also cannot write their own queries .

Below is what was to be accomplished

Variable name : Threshold

Variable Definiton : =IF([Object] >=100000;Good Business) the user wanted to vary the value ‘100000’ and have a different definition of ‘Good Business’ with the help of input controls.

 * For example currently Good Business implies any sales greater than or equal to 100000 but down the line as the business grew the user may say Good Business implies any sales greater than or equal to 200000

 Universe used:

efashion

Readmore

Tags: , , ,

Leave a Reply

You must be logged in to post a comment. Login now.