Knowledge Base Webdashboard: Dashboarding made easy

Q: How do I create a dashboard?
How do I create a XML dashboard? What do I need for this?

A: A Webdashboards definition is stored in an XML file to provide optimal flexibility. The best way to create your own XML file is to use the Webdashboard Designer. You can order it through the contact page. The User Guide can be found at our Documentation page.

There is also an Excel XML generator, this is the predecessor of the Webdashboard Designer. The AdventureWorks demo can function as a reference for different possibilities.

You can download the XML generator here: Webdashboard XML generator

Q: What roles does the Webdashboard support?
What roles does the Webdashboard support?

A: The Webdashboard has the following 3 main roles:

Implementers: creates the XML dashboard definitions by using the Webdashboard Designer.

Administrators: maintains the Webdashboard through a management page. He can also upload XML definition files to create new dashboards.

Users: Log in to the system and get one or more dashboards for their use.

Q: How do I reset my Dashboard
What button do I press to reset my current Dashboard?

A: Just click on the logo of your Dashboard, you get your saved or the default dashboard.
You also have other options in the menu on the top right of your screen: Dashboards.

Q: XML Examples
Where can I download dashboard XML examples?

A: A Webdashboards definition is stored in an XML file to provide optimal flexibility. The best way to create your own XML file is to use the Webdashboard Designer. You can order it through the contact page. The User Guide can be found at our Documentation page.

You can also use the Excel XML generator, it is the predecessor of the Webdashboard Designer. The Webdashboard already has out of the box XML's ready for you.
- AdventureWorks XML + XML generator
- CRM Analytics XML + XML generator

Q: Install guide
Where can I find the Install Guide?

A: You can download the Install Guide here. For additional support please contact support@webdashboard.nl .

Click on the icon to download the Setup Guide in pdf.

Other guides can be found at our Documentation page.

Q: An unexpected error occured
After I log into the Webdashboard, it gives me "An unexpected error occured" screen. What can I do?

A: Unfortunately not all possible errors have their own specific page yet.

Please check if the OLAP user has rights to the OLAP database/cube.

More options: You can get the information out of the Event log of the Server. You have to be Administrator for this. You can also find solutions to Event log errors in this Knowledge Base.

Q: Documentation
Where can I find documentation concerning the Webdashboard and the Webdashboard Designer?

A: The user and technical guides can be found at our Documentation page.

Q: Event log: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
When I look in the Event log it tells me:
Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: ]

What can I do?

A: The current user that IIS (Internet Information Services) uses doesn't have enough priviledges on the SQL Server. Integrated security has been selected. Give the user enough priviledges.

Best practice is to make a SQL user for Webdashboard instead of using integrated security. Thsi way you don't make your Webdashboard Windows user account specific and it will be easier to roll-out.

Q: Event log: Login failed for user 'Webdashboard'. Reason: The account is disabled.
When I open Event-log it tells me:
Event log: Login failed for user 'Webdashboard'. Reason: The account is disabled.

A: In SQL Server Management Studio check if the user is enabled. Right click the user: Login properties, Status, Login: Enabled.

Q: What other programs do I need to install the Webdashboard?
What other programs do I need to install the Webdashboard?

A: The webdashboard is designed for a Windows Operating System. Because it is an OLAP reporting tool you also need Microsoft Analysis server 2000 or higher. Here is a short list with mandatory programs:
- Microsoft Windows 2000 Server SP4 or higher
- Microsoft SQL Server 2000 or higher
- Microsoft Analysis Services 2000 or higher
- IIS (Internet Information Services) 6.0 or higher.
- Office Web Components (for graphs)
- Microsoft .NET Framework 2.0 or higher

Q: How do I install the Office Web Components?
How do I install the Office Web Components?

A: The Webdashboard uses the Ofiice Web Components to create its graphs. You need to install the components on the server that is running the Webdashboard.
The Office Web Components are downloadable at the Microsoft site and are free of charge. You can find the link here:
Office Web Components

Link: http://www.microsoft.com/downloads/details.aspx?
FamilyId=7287252C-402E-4F72-97A5-E0FD290D4B76&displaylang=en

Q: How do I set the right privileges on the File System?
How do I set the right privileges on the File System?

A: Open the Windows Explorer and navigate to the right directory. Right click the folder and click 'Properties'. In the tab security you will find the options to set the rights. Depending on your Operating System this could differ, the setup will tell you what permissions to set.

Q: How do I access the install page?
After install the files have been copied on to the system. But how do I access the install page?

A: After installation a shortcut will be put on your desktop. If this doesn't work, please go to: http://localhost/. The is set in the setup fase. You can also use IIS to locate the right URL.

Q: Unable to execute MDX
The Webdashboard tells me that it is unable to execute the MDX. What can I do?

A: The problem can lie in a couple of things. Please check if:
- OLAP ServerName in XML is correct;
- DatabaseName in XML is correct;
- User has enough rights on OLAP database/cube;

You can find the XML of different dashboards in the specified directory during install. Here you can also find log files.

Q: 64 bit servers: IIS to 32 bit
Is it possible to install the Webdashboard on a 64-bit server? And how do I do this?

A: 64 bit server configuration has been tested. If IIS is in 32 bit mode, it shouldn't be a problem. The next article discusses how to get IIS to run in 32 bit mode:

Article ID: 894435 How to switch between the 32-bit versions of ASP.NET 1.1 and the 64-bit version of ASP.NET 2.0 on a 64-bit version of Windows (http://support.microsoft.com/kb/894435/en-us)

The steps in short:

Go to the command prompt

Enable 32 bits by typing: "Cscript.exe C:\inetpub\adminscripts\adsutil.vbs set W3SVC/AppPools/Enable32BitAppOnWin64 1"

Install 32 bits ASP.NET 2.0 by typing: "C:\windows\\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i"

Make sure if ASP.NET verion 2.0.50727 (32-bits) is Allowed in IIS. (inetmgr)

Q: Setting the Windows Integrated Security (Active Directory)
How can I let Windows Integrated Security (Active Directory) handle the logins?

A: Instead of logging in and letting the Webdashboard software do your password management, you can also choose to use Windows integrated security. For this you have to do the following steps:

Windows Integrated Security (Active Directory) is linked to the "login name". Set the login name to: DOMAINNAME\loginname for various users.

Open the web.config (default location: C:\Program Files\Webdashboard\Web.config) and enable the Authenticaion to Windows, like so:

<authentication mode="Windows"></authentication>


As final step just save the web.config.

If you have set the windows authentication you will now be able to automatically log in to the Webdashboard. If the authentication doesn't match you will still be able to log in with username and password.

Q: No license was found, you must install a new license file
After install, the Webdashboard doesn't start up and tells me to install a new license file, what to do?

A: Please look at the eventvwr. If it states:
"Message: There is no explicit mapping for the categories 'Licensing'. The log entry was: " then you need to reinstall .NET framework 2.0. How to do this:

Execute "aspnet_regiis.exe /u" and then "aspnet_regiis.exe /i" under the
v2 framework directory (i.e. : C:\Windows\Microsoft.NET\Framework\v2.0.50727 or C:\dotnet\Win\Microsoft.NET\Framework\URTInstallPath), then restore the APP pool from ASP.NET 2.0 back to Classic App Pool subset.
If this doesn't work please reinstall IIS and/or the .NET framework.

Make sure you run the command as an Administrator.

Q: Eventlog doesn't register Webdashboard errors
Why don't I see the errors I get in my Internet Explorer in the Eventlog??

A: You need enough Windows permissions to write to the error log. The following article displays this:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=324053&SiteID=1

A fragment of this article:

Permissions for the Event log are driven through the registry. Each event log has an entry in the registry under the following key:
HKEY_LOCAL_MACHINE\System\\CurrentControlSet\Services\EventLog

To allow the ASP.NET account access to create an event source, you need to have read permission on this and all sub keys, and write permission on the event to which you want to create the event source. Part of your error message says " Inaccessible logs: Security.". Note that "Virtual Server" seems to be another common inaccessible log. This means that for the Security log, the ASP.NET account (MachineName\ASPNET or MachineName\NETWORK SERVICE) does not have read access to that key.

For reasons that I can't explain, the EventLog.CreateEventSource() method attempts to search Event Sources under all event logs, not just the event log for which you want to create the source. There are two solutions to this. The first, easiest, and most insecure, is just to give read/write access to all event logs for the ASP.NET account. To do this, follow these steps:

1. Start -> Run -> regedit.exe

2. Navigate to My Computer > HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\EventLog

3. Right click this key, select Permissions, and grant the ASPNET account read/write permissions as described above. Note that for the "inaccessible" logs (ie. Security, Virtual Server), you'll also need to grant read access, as permissions have been set to not inherity from the parent key.

4. Restart IIS (start -> Run -> iisreset)

5. Cause the code line that creates the event source to be executed (EventLog.CreateEventSource())

Q: Windows 2000 problem: cannot impersonate account
When I try to connect to OLAP my user credentials aren't impersonated by Windows 2000, what can I do?

A: Unfortunately Windows has changed it's "impersonation settings" in the last years. If you are running Windows 2000 you need to change the setting so that Windows can use impersonation to connect to your OLAP environment.

More information can be found on the Microsoft site:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;180548

Q: What is a systemcode?
What is a systemcode and where can I find it?

A: The systemcode is provided by the install of the Webdashboard.

Example Systemcode:
985958D259B680EBCE814606F468D16186D442F3E01587C8
1E45C2381527DF34A20AC5BFFCE1964818315D21A14A5BDC

Q: What options are there in the XML?
What options are there in the XML? Is there an overview somewhere to set the XML?

A: There is a special XSD available which tells you what the different options are in the XML. Click here to view this XSD.

Q: OLAP CONNECTION TEST TERMINATED
CONNECTION TEST TERMINATED

Unexpected problem while testing the connection:
Could not load file or assembly 'Microsoft.AnalysisServices.AdomdClient, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

CONNECTION TEST FAILED

A: Please install ADOMD.NET: http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en#filelist

You need this program to be able to `talk` to other servers.

Q: Event log: System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown
How do I resolve this Eventlog message?

Message: System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {0002E55D-0000-0000-C000-000000000046} failed due to the following error: 80040154.
at InSumma.Webdashboard.Engine4.ChartBuilder.OWCChartSpace(DataTable data, Boolean showLegend) in D:\Projects\In Summa\Webdashboard\Dev\Webdashboard.NET\Engine4\ChartBuilder.cs:line 23
at InSumma.Webdashboard.Engine4.ChartGenerator.GenerateChart(DataTable dtChart, Dashboard webdashboard, Int32 viewIndex) in D:\Projects\In Summa\Webdashboard\Dev\Webdashboard.NET\Engine4\ChartGenerator.cs:line 134
at HtmlTableGenerator.RenderChart(DataTable dtGegevens, Dashboard dashboard, Int32 viewIndex) in D:\Projects\In Summa\Webdashboard\Dev\Webdashboard.NET\\Engine4\HtmlGenerator.cs:line 658
at InSumma.Webdashboard.Web.ChartView.pnlChart_DataBinding(Object sender, EventArgs e) in D:\Projects\In Summa\Webdashboard\\Dev\Webdashboard.NET\Web\Core Controls\ChartView.ascx.cs:line 140

A: This is an Office Web Component error, please reinstall the Office Web Components and everything should be fixed.

Contact information

CALL

E-MAIL

VISIT