Element Linking and Hide/Show help in webi

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hi Satish,

I think I was not able to make you understand my issue.

I have 2 characteristic one is Year and second is Division, requirement is to create 2 charts.

one showing Year-Div wise Sales value:

2009: D1: $5000

2009: D2: $3400

2010: D1: $6000

2011: D2: $2000

Another chart where I have Top 20 Customers of 2011 and his sales:

What I want is when user clicks on first chart's 2009: D1

second chart should show Top 20 Customers of 2009 year and D1 division

when user clicks on 2011: D2

second chart should show Top 20 Customers of 2011 year and D2 division

when user clicks on 2010: D1

second chart should show Top 20 Customers of 2010 year and D1 division

I have 3 queries for each year and merged the required object. Created first and second chart but not getting what formula should I create so that required linking works.

Thanks,

Ankit

[Former Member · Accepted solution]

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

[former_member191852]

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

[Former Member]

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

Thanks,

Ankit

[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