Clarity

  • 1.  Drill down from a two dimensional grid portlet

    Posted Dec 08, 2016 04:44 PM

    Hi

    Is it possible to create a link to a drill down portlet from a two dimensional grid portlet (not chart portlet) passing to the drill down portlet the metric x and y values that were clicked?

    I know about the piggy-back method, but even that doesn't work in a grid portlet when I pass a metric with both x and y values concatenated - I mean, It doesn't even let me choose the link that I created in the query.

    The only way is if I pass a value from one of the dimensions, (which then loses context in the drill down portlet because we either lose the y value that was clicked or the x value).

     

    For example, if we want to see Actuals/Allocation per month per project, so I created a portlet with the columns as months and rows as projects and the metric which is shown is the calculation of Actuals/Allocation for that project and month. And when I drill down I want to see the actuals and allocation of all the project team for that project, for that month.

     

    So you can't pass only the project ID, and you can't only pass the month key, so using an attribute from one of the dimensions is not an option.

    But when I choose to pass some string concatenation of the project ID and month key, which is a metric, I don't see the link available to choose in the first portlet.

     

    Any ideas?

    Thank you

    Amir



  • 2.  Re: Drill down from a two dimensional grid portlet

    Posted Dec 09, 2016 03:42 PM

    I've never try it.. and from you said, it does not look like possible. Could you share code? we may get some possible "idea"..



  • 3.  Re: Drill down from a two dimensional grid portlet

    Posted Dec 17, 2016 07:01 AM

    I agree with your findings ; when I was trying to do something similar could only pass-down the details about the "row" and not the "column" - could not even place the link on the "intersection" fields, only on the row "description" field(s).