Skip to Content

Lumira Discovery 2.0 - How to create Cascading Input Controls ?

Dear all,

I want to setup Cascading Input Controls in Lumira Discovery 2.0.

1. In the first Input Control : Select Country, eg France

2. The second Input Control should contain only the cities of France (and not all cities found in the source) :

I have defined a Custom Hierarchy : Country - City

How could you obtain that the values of the second Input Control depend on the selected value in the first Input Control ?

Apparently a custom hierarchy does not result in the expected behavior.

Thanks for sharing your ideas.

Hans

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Nov 06, 2017 at 03:22 PM

    Hans Segers - please see this SAP Note: https://launchpad.support.sap.com/#/notes/2462202

    ") Filters and Input Controls

    Cascading filters and Indirect filters are not yet available."

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 22, 2017 at 02:24 PM

    Hi,

    I think the way this can done is using Lumira 2.0 interoperability feature. After you have designed the dashboard in discovery it would be available in designer for you to add the cascading feature using inbuilt functions. Once you have successfully implemented the cascading logic in designer and saved, the same would be available in discovery for use.

    NOTE: I dont have access to the tool currently but have read the above in the sap community blog.

    The below link would get you started

    https://www.youtube.com/watch?v=ZZu7dvIozlc

    Best Regards

    Madhusudan

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 06, 2017 at 03:06 PM

    Hi Tammy,

    Indeed according to https://blogs.sap.com/2015/12/21/did-you-know-how-to-use-input-controls-in-lumira/, the cascading behavior could be obtained by adding a hierarchy.

    That does not work in my case (source : Excel, Lumira Discovery 2.0 SP02 Patch 1)

    Thanks

    Hans

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 06, 2017 at 02:28 PM

    So this doesn't work for you - see Edwards Lumira 1.x blog - https://blogs.sap.com/2015/12/21/did-you-know-how-to-use-input-controls-in-lumira/ - maybe you could report it as a bug to SAP Support?

    Have you considered using Lumira Designer for this feature? See https://blogs.sap.com/2017/09/25/cascading-filter-in-sap-design-studiolumira-designer-2.0-with-universe-source-using-crosstabs/

    Add comment
    10|10000 characters needed characters exceeded