0 Replies Latest reply on Dec 4, 2013 5:02 AM by Özgür Cetin

    Condition for Parameter input

    Özgür Cetin

      Hi friends,

       

      is it possible to restrict the content in parameter or give a condition?

       

      My example with Tableau Desktop 8.0.5 and Sample- Superstore Sales:

      Para_1.PNG.png

       

       

      Parameter "Search"

      Para_2.PNG.png

       

      "Customer" Filter with Condition "By Formula =  CONTAINS([Customer],[Search])"

      Para_3.PNG.png

      Result of this, I can search for strings like "bi" in the dimension Customer.

      Para_4.PNG.png

       

      I need a condition for the Search area like "The Searchstring hast to be min. length of two letters!"

      In this Example with Samlpe-Superstore Sales, i can use the Function "LEN". It is in the Filter -> Condition -> "By Fomula"

       

      Para_5.PNG.png

       

      My Problem is ,I use a Cube from "MS Analysis Services" and i don't have the Function "LEN" in the Conditions of Filter.

       

      Does anyone have an idea how to realise this?

       

      Thanks and kindly regards to all,

      Özgür

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      Parameter "Search" is