Archive for the ‘MS Office’ Category.
April 13, 2010, 8:15 am
The 6.3 Desktop Professional install will in some cases loop on the Microsoft Windows Installer 3.1 v2 and Microsoft XML 6.0, which are prerequisites for the install, when attempting to install on Windows 7. You get a continuous loop with the message
One or more of the installations required a reboot. Would you like to reboot now?
No matter how many times you reboot, it does not want to install.
The trick is to run the setup.exe program from the following installation location
Proclarity 6.3 setup.exe location
Hope this helps.
October 27, 2009, 6:43 pm
There’s a great resource for those people whose company can’t (or won’t) pay for training in these cash-strapped times
How Do I BI?
Check them out!
October 20, 2009, 10:15 am
Microsoft announced yesterday that the “Gemini” capabilities of Office 2010 / SQL Server 2008 R2 will be released under the brand, PowerPivot for Excel 2010… There’s a new site up and running dedicated to the product with little data as yet, however the Public Beta will be available in November.
PowerPivot
September 22, 2009, 2:11 pm
More of a placeholder for me because I keep forgetting. You know (probably) the scenario where you have enabled more than the default 1,000 drill-through rows in your SSAS Cube but Excel is still stubbornly limiting the drill-through to 1,000 rows.
You need to edit the data connection in Excel as per the picture below to increase the default.
September 3, 2009, 1:31 pm
I had yet another “incident” today that left me a little flustered whilst trying to do what i would regard as simple stuff with PerformancePoint Dashboard Designer – trying to display an SSRS report on a dashboard page when the report server is in Sharepoint Integrated mode. Fairly simple once you have it worked out but certainly not intuitive and there’s precious little documentation surrounding it.
Anyway… on to the issue & resolution.
To display an SSRS report in a dashboard page, first we need to add a new report, choosing SQL Server Report as the type (see left hand pic below)
Now we can move on to selecting the report server location and the report we want to display. This is not as easy as it sounds – for example in BIDS, we would normally apply our integrated Sharepoint site as the TargetServerURL as per right hand picture above. Note how we use essentially the same URL for the report destination location as we do the TargetServerURL, in my case the is in the format http://myportal.mydomain.local…
So, now we get to PPS and I was expecting things to be pretty similar when faced with the following configuration panel – but no. Actually what we have to
do is to enter the actual reportserver virtual directory URL as opposed to your Sharepoint Portal root site (as you would in BIDS). Notice how the Report Server URL in PPS is in the format
http://reporting.mydomain.local/reportserver
whereas in BIDs for Sharepoint integrated mode it was
http://myportal.mydomain.local
So let’s hope that this is some functionality that becomes more consistent as the disparate platforms (PPS/MOSS/SQL etc) get developed further, as it sure is frustrating to try to second guess these issues when jumping between the different dev environments. So if you are trying to deploy SSRS reports within PPS dashboards to a portal where SSRS is running in Sharepoint Integrated mode and keep getting error messages like the one below – now you know what the issue might be…
Hope this helps…
August 11, 2009, 9:52 pm
I was able (thanks to some friends at Microsoft) to download and install the SQL 2008 R2 August CTP and Microsoft Office 2010 “Gemini” add-in…
Gemini is effectively an Excel Add-in…. and appears as an additional tab on the Ribbon…
First I tried to just get some simple stuff together by getting some data from the Access Northwind database..I was taken through a neat little import wizard, selected all the Northwind tables and the result was a report on what had been imported
On returning the data to Gemini (note that we’re not really in Excel here – still in Gemini) we can view existing and (if necessary) create new table relationships within Gemini… This is useful where you start to drag in related data from multiple sources.
I like it…. in no time at all I’d got together a basic sales Pivot Table with a couple of slicers
