Skip to Content
avatar image
Former Member

Element Linking and Hide/Show help in webi

Hi,

I have a webi report which have 2 query one for 2009 and second is for 2010 year data. Report have Division, Year and Customer as characteristic and cust_sales as key figure.

Requirement is to create 2 chart. One where we have division, year and cust_sales and second chart have Customer and cust_sales.

In second chart I want to show only Top 20 customer every time and did element linking from first to second chart. I want when user click 2009 and division "D1" second chart should show Top 20 Customer and cust_sales of same division and year and when user click on 2010 division "D1" or "D2" second chart show data accordingly. Second chart should show Top 20 cust_sales every time.

cust_sales is available as cust_sales2009 and cust_sales2010 since it is coming from two different queries.

Can it be done, if yes please guide.

Thanks,

Ankit

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 16, 2015 at 09:37 AM

    Ankit,

    First you have to merge the dimensions from both providers

    1. Create the chart 1 division in category axis and sales in value axis

    2.create the chart 2 provide customer in category axis and sales in value axis

    3. create a variable provide the Rank(Measure; top; (Division));

    4. create a link between these 2 charts,chart 1 add element and select the dimension.

    Assign the report elements(chart 2)

    5. provide a filter in chart 2 to show the top 10(Rank <=10)

    Thanks,

    Sathish

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Ok, issue is resolved.

      Created one variable and used it as rank in input control linking it with chart 2.

      Since chart 1 is linked to chart 2

      variable formula is

      = if year = "2009" and division = "D1" then rank([sales2009];Top where division  = "D1") elseif year = "2009" and division = "D2" then rank([sales2009];Top where division  = "D2") elseif year = "2010" and division = "D1" then rank([sales2010];Top where division  = "D1") elseif year = "2010" and division = "D2" then rank([sales2010];Top where division  = "D2")

      elseif year = "2011" and division = "D1" then rank([sales2011];Top where division  = "D1") elseif year = "2011" and division = "D2" then rank([sales2011];Top where division  = "D2")


      Thanks,

      Ankit

  • avatar image
    Former Member
    Jan 15, 2015 at 11:00 AM

    Please reply any one, m in dilemma whether it is feasible or not.

    Thanks,

    Ankit

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      YEs it is. The first thing I think you should do is merge both queries so you can work with both years together.

      Cheers,

      ROgerio

  • avatar image
    Former Member
    Jan 16, 2015 at 01:24 AM

    Ankit,

    If i am correct, you are trying to link 2 different charts. for that the best way of linking is having the second chart on a different report . pass the Year as the click parameter and use the rank on the second report chart to get the top 20 or so.

    Thanks,

    Mouli

    Add comment
    10|10000 characters needed characters exceeded