Create a list of static values in a input control

Mario De Pauw Mar 1, 2012 4:04 PM

Currently Being Moderated

Hi,

I'm pretty new to BO and I'm kind stuck right now and can't seem to find a solution.

I have got a simple WebI report which contains some charts and a crosstab. I'm working on my Universe connecting to a SQL server database. What I want my report to do is make it possible for the users to change the measure and the axisses of the charts by a Input control. (Or doing it by another way if it is possible)

I have created four variables: Measure / Measure_Prompt / Rows / Rows_Prompt.

In the 2 prompt variables I have a hardcoded value. Example: ="Net_Value". I created an input control for these variables, which is a text box and the user needs to type a value. This works and the report is adjusting depending on the value entered.

In Measure and Rows I have an IF statement. For example: If Measure_Prompt is "Net_Value" take [Invoice_Net_Value] etc..

However I would like to have a dropdown with a list of values in the input controls instead of the text box. Because I can't expect users to know what to type.

Is this possible? If it's possible how can I do this and create a dropdown with a list of given hardcoded values from which the user can choose from with either a input control or another way if suggested.

Thanks in advance,

KInd regards

Mario De Pauw

Re: Create a list of static values in a input control

Vamsee Krishna Mandlem Mar 2, 2012 9:49 AM (in response to Mario De Pauw)

Currently Being Moderated

hi,

You can define static list of values while defining Input Control on Variables.
But you should create the variable as Dimension type/Detail type instead of Measure type to make use of Combo Box.

So please change type of your variables to Dimension/Detail and proceed with below steps.

1) Input Control Tab > New
2) Select the required Variable Object > Next > Choose Control Type
3) Select Combo Box (2nd item under Single Value)
4) "All values from Report" is shown as value against List of Values option. You can retain this if it is ok. To change it with Custom Values, you can click on ellipsis button. There you can type custom values and Press enter. Your Custom values will appear on right hand side list.

5) Use restricted list of values option can be set to 'Yes'/'No' depending on your requirement.
6) Default value can be specified.
7) Click Next > Select the required block on which this input filter should work
8) Click Finish.

Regards,
Vamsee
Report Abuse

Like (0)
- Re: Create a list of static values in a input control
  
  Mario De Pauw Mar 5, 2012 10:07 AM (in response to Vamsee Krishna Mandlem)
  
  Currently Being Moderated
  
  vamsee m,
  
  Thanks for your answer.
  
  When I define a new input control I don't have the option to select combo box. The only option that is available is "entry field".
  
  I think this is because my variable is containing a single value as in ="Net Value". Which is not a link to a dimension in my query but just a string.
  
  Regards
  
  Report Abuse
  
  Like (0)
Re: Create a list of static values in a input control

Mario De Pauw Mar 7, 2012 10:11 AM (in response to Mario De Pauw)

Currently Being Moderated

Any other suggestions?

Regards
Report Abuse

Like (0)
- Re: Create a list of static values in a input control
  
  Guest Mar 7, 2012 10:41 AM (in response to Mario De Pauw)
  
  Currently Being Moderated
  
  in your dimension select the Associate lov's and assign the lovs to the dimension.
  when you open the report, select all. then create the userinput tool by selecting the column on which u want to apply.
  
  Like (0)
  - Re: Create a list of static values in a input control
    
    Mario De Pauw Mar 7, 2012 11:06 AM (in response to Guest )
    
    Currently Being Moderated
    
    Can I enter a list of values like ('Representative', 'Sales org', 'Product group', 'country', 'company') when I do not have these values in my tables or anywhere. I need to manually enter them as I cannot find this list anywhere. In the associate list of values I can only link to another dimension for example to the Country dimension and getting the values 'France', 'Spain',..
    
    Am I missing something or is this also possible there?
    
    Regards
    
    Report Abuse
    
    Like (0)
    - Re: Create a list of static values in a input control
      
      Jacqui Basheer Mar 7, 2012 12:06 PM (in response to Mario De Pauw)
      
      Currently Being Moderated
      
      Hi Mario,
      
      You could create a universe level LOV or derived table using commands from SYSDUMMY1, DUAL or whatever dummy tables your environment happens to support. Then just reference that in your report.
      
      cheers,
      
      Jacqui
      
      Report Abuse
      
      Like (0)
      - Re: Create a list of static values in a input control
        
        Mario De Pauw Mar 7, 2012 12:32 PM (in response to Jacqui Basheer)
        
        Currently Being Moderated
        
        Hi c3Jacqui,
        
        Thanks for your response. I created a derived table in my universe and created an object referring to that table.
        In my webi report I could refer to the object and now have the option to select a combo box.
        
        Thanks for your help! (+10 points to you )
        
        Regards
        
        Report Abuse
        
        Like (0)
        
        Re: Create a list of static values in a input control
        
        Jacqui Basheer Mar 8, 2012 10:18 AM (in response to Mario De Pauw)
        
        Currently Being Moderated
        
        Cheers Mario,
        
        Glad you got it working
        
        Report Abuse
        
        Like (0)

Go to original post