markodonovan (12/17/2012)
Hi YSLGuru,You should be able to do this with QlikView.
In the past I have created dashboards on the SSRS reportserver database in QlikView to check the performance on the
reports being run by users and what types of reports were being run.
Mark
I've downloaded the PE edition and am trying to do what I would call a simple dashboard (using a SQL Query in my SQL Server database that returns a few fields ) and I can't find any way that you can use this thing without Excel as the source. I get why the Wizard might be hard coded to pull from xls files only but no where in the menu can I find where you create/setup some kind of connection to an ODBC compliant source like SQL Server. is this a limitation of the free pe edition, that you can only use Excel files as the data source? The reference manual mentions using ODBC connections but darned if I can see where within QlikView you do this.
Is there any kind of demo that deosn't use an Excel file? I can see the appeal of using Excel as the data storage but if I am going to do that then I could use Excel to shuffle and report on the data without QlikView.
What am I missing?
Kindest Regards,
Just say No to Facebook!