Free Text Parameter interacting with Present content

Len_Stockdale
4 mths ago
6replies
Answered

Hello

I have the following use case issue that I cannot resolve.

I need to place a free text numeric input field onto a present and get that to interact with a Discover to act as a filter.

I have created the Discover and have used formulate to create a free text numeric input box. I created two versions of the free text parameter, one based on the model and the other as a global formulate.

Regardless of which version of the parameter I use, I cannot get it to interact with the piece of content. Interaction manager does not allow the parameter to be selected against the Discover.

Can anyone provide an answer as to why the parameter will not interact with the Discover or how to achieve this requirement.

Thanks

Len

- David_Gordon
- 4 mths ago
- Reported - view
Hi Len,

You have created a global numeric parameter and have included it it in your discover, then you would like to use it in Present.

In Discover, assuming you have a report with sales per product category, you then click on the filter wizard

In the filter wizard, select product sub category for the filter target (red box), select "Filter Above" for the type (green box), select parameterize and select your global parameter that you created (in my case - Numeric Parameter) (blue boxes), then click apply

The filter is now fully functional in Discover

Create a Presentation and drag and drop your discovery into the presentation. Now drag and drop your parameter onto the canvas

Check in the interaction manager that there is an interaction between the parameter and the discovery.

When you run the presentation the slicer should be fully functional.

Please advise if this matches your scenario and if this works for you.

Regards

David
- Len_Stockdale
  
  4 mths ago
  
  Reported - view
  Hi Thanks for the response.
  
  The process nearly worked but the SQL generated and passed back to Netezza DW platform is not quite right. We are raising a support call to investigate the issue further.
  
  Thanks
  
  Len
- imbarmarinescubar_pyram
  
  4 mths ago
  
  Reported - view
  Hi
  
  Could you share the generated SQL and point out was is not right with it?
  
  Thanks,
  Imbar
- Len_Stockdale
  
  4 mths ago
  
  Reported - view
  Hi
  
  The code generated is
  
  SELECT COUNT("xVNETEZZAQUERYHISTORWpk2dwFfPJ"."SESSION_ID") "xCNTmzrVNETEZZAQUERYiwSJJ89uMr", "xVNETEZZAQUERYHISTORWpk2dwFfPJ"."SESSION_ID" "xVNETEZZAQUERYHISTOReCqzbosvNf"
  
  FROM "REPORTING"."V_NETEZZA_QUERY_HISTORY_PERFORMANCE_SESSION_ID" "xVNETEZZAQUERYHISTORWpk2dwFfPJ"
  
  GROUP BY "xVNETEZZAQUERYHISTORWpk2dwFfPJ"."SESSION_ID"
  
  HAVING (ROUND(COUNT("xVNETEZZAQUERYHISTORWpk2dwFfPJ"."SESSION_ID"),1) = 16013)
  
  LIMIT 10000001
  
  For what I was trying to achieve I would expect something like:
  
  Select SESSIION_ID FROM REPORTING"."V_NETEZZA_QUERY_HISTORY_PERFORMANCE_SESSION_ID" Where SESSIOND_ID = 123456
  
  Where 123456 would be the number entered in the global parameter and then passed to the Discover.
  
  Thanks
  
  Len
- imbarmarinescubar_pyram
  
  4 mths ago
  
  Reported - view
  I See. So the filter you currently have set is a numeric filter, meaning, filtering the session_id where a measure value would be equal to X.
  Instead you need to be using a text filter, where the session_id name is equal to (or contains if you prefer) to X.
  
  Instead of "Filter Above" use the "Exact" (or starts with/ends with/contains) filter option:
  
  You can then still parametrize the value to filter by using a global parameter, but note that it needs to be a text parameter (not number - but you can set the).
  
  ---
  
  Another option is to create a custom list of session_ids, with this syntax, and select it in the report instead of "all".
  
  strToMember([V_NETEZZA_QUERY_HISTORY_PERFORMANCE_SESSION_ID].[SESSION_ID], [global].#[ID_OF_PARAMETER]) // replace with the real ID
  
  With both cases you should automatically see the parameter in discovery, and have the option to interact/override it in present.
- Len_Stockdale
  
  4 mths ago
  
  Reported - view
  Hi
  
  Thanks, this has solved by issue. Most appreciated.
  
  Thanks
  
  Len