In dotnet you can create a new Guid by using the static Guid class like this (c# syntax) Guid g = Guid.NewGuid(); And you can create an empty guid like this Guid g = Guid.Empty; In SQL Server you can … Continue reading
If your SSRS report viewer’s “Loading” popup message never goes away (the report never renders) then chances are you have a reference to an image that does not exist in your report. I got this because I have a report … Continue reading
Connecting to SQL Server Analysis Services from a remote domain / login When connecting to SSAS from a different remote domain / login using Excel 2010 where you have set up a windows user at the SSAS server, provided adequate … Continue reading
If you get this error when you are trying to expand the MSDB section in SSIS and your target SQL Server is clustered then this is probably because the default reference to an instance of SQL Server in the SSIS … Continue reading
I use Team Foundation Server (TFS) for source control of my current data warehouse project with SSIS, SSRS and SSAS but my requirements documents which are mostly word but also Excel, Visio and xMind (Excellent mind mapping diagram software) were … Continue reading
This gallery contains 1 photo.
Have you got missing cubes in your Excel Data Connection Wizard? A customer noticed this yesterday and had spent all afternoon looking for the issue, rebuilding, deploying, processing, deleting and recreating on the server etc. all to no avail. He … Continue reading
Tagged Analysis Services, Cannot find cube on server, Data Connection Wizard, Deployment, Excel, Excel Data Connection Wizard missing cube, Management studio, Measure, missing cube, SSAS, Visible