I can execute that the broadcaster sends a query immeadiately via email. By putting in the query details and pressing Execute.
However I cannot get the system to schedule a query via email. I schedule for Date/Time and absolutely nothing happens. The scheduled time comes and goes.
What am I missing?
We are on BI7 NW2004s.
Also when I do receieve the query (having executed it immeadiately) it doesnt pick up the cost centre security / variables - which work when I test run the quesry via RSECADMIN. I see data for all cost centres rather than it being restricted to one.