Burst report using render variable from different query

[jkramsey42]

Hello all,

I've been searching the web for ways to handle my problem but have come up with no complete solutions thus far, and I'm hoping someone will have an idea or two!

This issue involves a page with a combination chart containing a variable number of bars on the primary axis. This is a satisfaction survey, the chart displays the "top 5" items that a breakout group receives satisfaction percentages on. (Item A is 98%, item H is 96%, item Q is 97%, etc.) However, there are situations where there may be more than 5 items receiving ties-- i.e. a breakout group with a small n and MANY ties of 100%, so the graph would include a bar for each.

Because the bars will get scrunched together if there are too many, I have set up the chart in a conditional block; the block variable looks at the number of bars, and renders one version with chart height X if (bar count) <= 10, and chart height Y if (bar count > 10.

That's fine and dandy in the "standard" report, but we also have a burst version of the report, and this doesn't work. The page with said chart, unsurprisingly, needs to be associated with the burst query (which contains breakout group and number of respondents). The count of tied items/bars comes from a DIFFERENT query (let's call it "chart query," containing individual responses and item labels), and since the page with the chart must be associated with the burst query, I can't use a variable from "chart query" to control a conditional block-- or even a block/page render option-- to render different charts like I do in the nonburst query.

Is somehow getting (count of bars) into the burst query my only option, since I can only use one query per page for render variables?

Thanks in advance!

[MFGF]

Hello all,

I've been searching the web for ways to handle my problem but have come up with no complete solutions thus far, and I'm hoping someone will have an idea or two!

This issue involves a page with a combination chart containing a variable number of bars on the primary axis. This is a satisfaction survey, the chart displays the "top 5" items that a breakout group receives satisfaction percentages on. (Item A is 98%, item H is 96%, item Q is 97%, etc.) However, there are situations where there may be more than 5 items receiving ties-- i.e. a breakout group with a small n and MANY ties of 100%, so the graph would include a bar for each.

Because the bars will get scrunched together if there are too many, I have set up the chart in a conditional block; the block variable looks at the number of bars, and renders one version with chart height X if (bar count) <= 10, and chart height Y if (bar count > 10.

That's fine and dandy in the "standard" report, but we also have a burst version of the report, and this doesn't work. The page with said chart, unsurprisingly, needs to be associated with the burst query (which contains breakout group and number of respondents). The count of tied items/bars comes from a DIFFERENT query (let's call it "chart query," containing individual responses and item labels), and since the page with the chart must be associated with the burst query, I can't use a variable from "chart query" to control a conditional block-- or even a block/page render option-- to render different charts like I do in the nonburst query.

Is somehow getting (count of bars) into the burst query my only option, since I can only use one query per page for render variables?

Thanks in advance!

Is there any reason you can't use the same query for the chart and the burst? That would seem to be the simplest option?

Cheers!

MF.

[jkramsey42]

The list of breakout groups that need to be burst come out of one spot in framework manager ([Burst Table].[Section Number]), and the responses that are aggregated for the chart come from another spot ([Questionnaire Data].[Item Response]).

When I try to join them, I get the error message..

Cross joins (between query subjects: Top 5 responses, [Database View].[ODS_Report_Burst]) are not permitted for the user who has the identity '*'.

Since I have full admin rights, I was told that this is a system limitation and said cross-DB joins just don't work, so I assumed one is limited to a single table from a single database.

[MFGF]

The list of breakout groups that need to be burst come out of one spot in framework manager ([Burst Table].[Section Number]), and the responses that are aggregated for the chart come from another spot ([Questionnaire Data].[Item Response]).

When I try to join them, I get the error message..

Cross joins (between query subjects: Top 5 responses, [Database View].[ODS_Report_Burst]) are not permitted for the user who has the identity '*'.

Since I have full admin rights, I was told that this is a system limitation and said cross-DB joins just don't work, so I assumed one is limited to a single table from a single database.

When you say you are trying to join them, do you mean using separate queries and a join operator in the query explorer? Or do you just mean you are trying to drag the items into the same single query?

If it's the latter, what happens if you select your query and set the "Cross Product Allowed" property to "Allow"? Does this get you past the issue?

MF.