Hello,
Analysis Services sp3.
Our clients uses Excel pivot table Services to access the cubes.
Problem is that they may have pts 8 sp2 and this will return errors like
"This provider does not support hidden totals" when some advanced features
are used in the cubes.
What I am after is a way to automatically detect the version of pts on the
client and redirect them to an update page where they can download the
ptsfull.exe 8 sp3.
This should be a VBA code embedded in the Excel pivot cube template they
download from our Intranet.
I already have a auto_open procedure in my Excel templates that
automatically switch between network and Intranet connection strings,
according to the client network config and domain logon.
I miss the piece that would detect the pts version.
Any idea?
I was not sure if this should have been posted to Excel.Programming. Let me
know if I should post this there.
Thanks
Philippe