cancel
Showing results for 
Search instead for 
Did you mean: 

How to use Filtered by Control Query in Broadcasting

Former Member
0 Kudos

Dear Experts,

I have one question when using broadcasting via control query

I want to send a query as below output

Source query output:

Country Year/month GSV

AU         2014.01     1000

CN         2014.01     100

CN         2014.02      500

Control query output:

Country Year/month

AU         2014.01

CN         2014.01

But when I run the broadcasting in HTML format with attached zip file

The Source query is still no change not changed to only 2014.01

Would you kindly let me know what's the best process to use this one?

Best regards

Alex yang

Accepted Solutions (0)

Answers (2)

Answers (2)

gleo_SRAM
Active Contributor
0 Kudos

How is the date derived in your control query Alex?

Is it only the Country you want to pass to your Output query from you Control Query?

Former Member
0 Kudos

Hi Leo,

I want to pass the country value & week value to the output query

In my case, I want to pass AU&CN as country filter and 2014.01 as year/month fitler to the output query

But it always shows below error message

Control query does not contain any data cells. Precalculation is not possible

If I removed fitler week and only left AU in my control query, it still shows same error message

Best regards

Alex yang

gleo_SRAM
Active Contributor
0 Kudos

Hi Alex,

If you run the Control Query manually in BEx, are you manually entering Year/Month as a variable?

With regards

Gill

Former Member
0 Kudos

Hi Gill,

There is no any variable in the control query.

I hard coded the setting int he filter area

Best regards

Alex yang

gleo_SRAM
Active Contributor
0 Kudos

OK Alex,

On your Source Query - which characteristic have you the variable to call the Control Query?

With regards

Gill

Former Member
0 Kudos

Hi Experts,

Any suggestion from your side?

Best regards

Alex yang