Skip to Content

Crosstab "Filter and Drill Down by" on value select

Hi.

I would like to achieve a "Filter and Drill Down by [free characteristic from the query]" using the Design Studio crosstab component.

Ideally, this would happen on selection (tap) of the table row.

I'm on Design Studio 1.5.

Example: Initially, all divisions are displayed. I tap a division and the crosstab is drilled down to the materials in this division, which are being shown instead of the division in the first column.

I could also use a hierarchy. However, I want to exclusively jump to the next level, hiding the other values.

The crosstab itself doesn't need much more features than this drill-down, as this functionality is intended for a slim mobile app.

The "navigate back" function should be realizable through a separate button.

(How) is this possible? Can I access the selected values in the crosstab's "On Select" event? I dont see the "Data Selection"-functionality for the crosstab.

Maybe it needs to be done on data source level?

Any ideas appreciated – Thanks!

Best,

Moritz

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Nov 19, 2015 at 02:30 AM

    Hi Moritz,

    The blog post Enable "Drill" navigation behaviour like in WebI should address your requirement.

    Regards,

    Mustafa.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 19, 2015 at 07:50 AM

    Hi Moritz,


    YES u can achieve this functionality . First in your Crosstab properties set Selection Type to Single and Selectable Area to Rows. Now suppose your CROSSTAB is like below.



    Division Material Net Sales D1 A 100 D1 B 200 D1 C 300 D2 E 400 D2 F 500 D3 G 600 D3 H 700


    ON THE ONSELECT of your Crosstab.just write the below code.

    DS.removeDimension("Division");

    DS.setFilter("Division", CROSSTAB.getSelectedMember("Division"));


    Now if u had selected D1 from your Crosstab. You would get the below result in your Crosstab.


    Material Net Sales A 100 B 200 C 300


    For back functionality add a BUTTON and write the appropriate code.

    Note : Multiple select will not work for Non desktop application.


    Thanks,

    Tanush


    Add a comment
    10|10000 characters needed characters exceeded

    • Tanush,

      Thanks! Your proposal was missing the "swapping" of the dimensions. However, I managed to get it right:

      I set the Crosstab to Selection Type: Single, Selectable Area: Rows and added the following code "on Select":

      DS1.setFilter("Division", CROSSTAB_1.getSelectedMember("Division"));
      DS1.moveDimensionToRows("Material"); // If more dimensions should be managed, DS1.moveDimensionBefore() can be used for correct ordering
      DS1.removeDimension("Division");

      The "Go back" button has the following code:

      DS1.clearFilter("Division");
      DS1.moveDimensionToRows("Division");
      DS1.removeDimension("Material");

      It performs quite well. Thanks again!

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.