If I’m double posting, I apologize. Could not find answer to this question:
In a webi report I used merged dimensions and created variables of the dimensions I want in the report. On these variables I put a calculation (count).
In webi all works fine, and gives correct output. When I schedule the report it runs but output for the same variables is zero
In webi:
customer|calls|tickets
1 |2 |
2 |1 |1
3 |2 |1
Scheduled instance:
customer|calls|tickets
1 |0 |0
2 |0 |0
3 |0 |0
Calls is a Measure, count of [call_id], which is a detail of merged dimension [customer].
Tickets is a Measure,count of [ticket_id], which is a detail of merged dimension [customer].
[Call_id] and [ticket_id] are from 2 queries on different universes.
Any help would be appreciated.
thanks,
Kooz
Kooz (BOB member since 2008-09-27)