ROQL report on Holiday table in report

Summary

SELECT H.Name, H.HolidayDate FROM Holiday H

Content

Hi there.

Since the Holiday table is not available for analytics by default, I'm trying to create a report on this through ROQL.
I have the query working in the Connect Object Explorer but I'm having dificulties creating a new report that soly exsists out of a ROQL query.

Initialisation

require_once(get_cfg_var('doc_root')."/ConnectPHP/Connect_init.php");
initConnectAPI();

Process

$roql_result = RightNow\Connect\v1_3\ROQL::query( "SELECT H.Name, H.HolidayDate FROM Holiday H" )->next();
while($holiday =  $roql_result->next())
{
$rows[0][0]->val = $holiday['Name'];