i need to install the PTS 8.0 in some machines, and i got the message that the target language is not supported for upgrade, the machines that i want to upgrade have windows 2000 proffesional, office 2000, both programs in spanish ... i got sql server in spanish and english, and both said the same error ... does anyone know how to fix it?
thanx
Luis.Hi Luis,
I'm running into the same problem here, did you manage to solve it?
Regards,
Klaus
Originally posted by jlmc1612
i need to install the PTS 8.0 in some machines, and i got the message that the target language is not supported for upgrade, the machines that i want to upgrade have windows 2000 proffesional, office 2000, both programs in spanish ... i got sql server in spanish and english, and both said the same error ... does anyone know how to fix it?
thanx
Luis.
Showing posts with label pts. Show all posts
Showing posts with label pts. Show all posts
Monday, February 20, 2012
PTS sp4 causes Distinct Count error
I have Analyisis Sevices service pack 3a. Office xp has been installed on the client machines and the server, which has installed PTS service pack 4. This has resulted in one of the calculated members showing as #1NF in Proclarity. It works perfectly well from client machines still running with PTS service pack 3. The calculated member in question uses a distinct count which is now always returning 0.
Does anyone have any suggestions? Thanks.
If the cube where it happens is a virtual cube - then it is a known regression in SP4 w.r.t. DistinctCount MDX function. There is a hotfix avaialable - please contact product support in order to obtain it.|||Hello,
Yes it is a virtual cube. Is the hotfix for Analysis services sp4? The server is still on Analysis services sp3a but PTS got upgraded when office xp was installed.
Thanks for your help.
|||Yes, the hotfix is on top of SP4 and should be applied to PTS.PTS sp4 causes Distinct Count error
I have Analyisis Sevices service pack 3a. Office xp has been installed on the client machines and the server, which has installed PTS service pack 4. This has resulted in one of the calculated members showing as #1NF in Proclarity. It works perfectly well from client machines still running with PTS service pack 3. The calculated member in question uses a distinct count which is now always returning 0.
Does anyone have any suggestions? Thanks.
If the cube where it happens is a virtual cube - then it is a known regression in SP4 w.r.t. DistinctCount MDX function. There is a hotfix avaialable - please contact product support in order to obtain it.|||Hello,
Yes it is a virtual cube. Is the hotfix for Analysis services sp4? The server is still on Analysis services sp3a but PTS got upgraded when office xp was installed.
Thanks for your help.
|||Yes, the hotfix is on top of SP4 and should be applied to PTS.PTS 9 redistributable location in RTM release?
Hi,
For some reason, I am unable to find the PTS installer for Analysis Services 9.0 OLE DB Provider in the RTM release.
Where can I find this? I need to provide this driver to my Excel users.
When I try to use the pts9 driver I have got from Sept CTP, I get this error when trying to refresh the Excel cube:
Errors n Network layers. Error Code 0xc10D00008 External Code 0x0000000
Thanks,
Philippe
PTS is no longer included with the release - you need to get it here:
http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
|||
Look here:
http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
PTS9 is one of the new "feature" packs posted a few weeks ago.
_-_-_ Dave
|||Is there any limitations with PTS with regards to displaying members of a parent while in a page field?|||I know there are a couple of limitations in SQL2000.
I did not try with SQL2005 however, watch for things like no more than something like 14000 members or so will be displayed in a page field.
This is annoying because if your list is let say 15000, you will just not see the last 1000 members.
I am sure there are also others limitations like the number of members that can be displayed in the Row area and the numbers of dimensions you can show in the row area.
It would be nice to have someone from Microsoft letting us know what are the exact limitatons when using PTS9 and Excel 2003. It would also be nice to have a list of features available in a local pivot table and not available in a PTS version of a pivot.
It would also be nice to know what are the limitations of the "Offline cube" wizard. I was never able to get anything useful out of this wizard nor able to script it. It is not letting you define complex offline cubes.
Philippe
|||Let's not confuse PTS with Excel Pivot Tables - they're not the same thing! To quote from the link given earlier in this thread:
PivotTable Services 8.0 is the OLE DB provider for SQL Server 2000 Analysis Services and is used to connect with an Analysis Services 2000 server. PivotTable Services does not work with SQL Server 2005 Analysis Services. Therefore, client applications that need connect to Analysis Services in both SQL Server 2000 and SQL Sever 2005 will need to install both PivotTable Services 8.0 and Analysis Services 9.0 OLE DB Provider in a side-by-side configuration.
But to get to the point, I'm not sure if the size limitations of Excel pivot tables are documented anywhere but the limitations of local cubes are (up to a point). In SQL2000 Books Online the topic "local cubes, compatibility issues" gives a good overview; I can't find an equivalent in SQL2005 BOL but although AS2005 local cubes have more functionality, there are still restrictions such as no support for partitioning, pro-active caching, stored procedures.
HTH,
Chris
PTS 9 redistributable location in RTM release?
Hi,
For some reason, I am unable to find the PTS installer for Analysis Services 9.0 OLE DB Provider in the RTM release.
Where can I find this? I need to provide this driver to my Excel users.
When I try to use the pts9 driver I have got from Sept CTP, I get this error when trying to refresh the Excel cube:
Errors n Network layers. Error Code 0xc10D00008 External Code 0x0000000
Thanks,
Philippe
PTS is no longer included with the release - you need to get it here:
http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
|||
Look here:
http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
PTS9 is one of the new "feature" packs posted a few weeks ago.
_-_-_ Dave
|||Is there any limitations with PTS with regards to displaying members of a parent while in a page field?|||I know there are a couple of limitations in SQL2000.
I did not try with SQL2005 however, watch for things like no more than something like 14000 members or so will be displayed in a page field.
This is annoying because if your list is let say 15000, you will just not see the last 1000 members.
I am sure there are also others limitations like the number of members that can be displayed in the Row area and the numbers of dimensions you can show in the row area.
It would be nice to have someone from Microsoft letting us know what are the exact limitatons when using PTS9 and Excel 2003. It would also be nice to have a list of features available in a local pivot table and not available in a PTS version of a pivot.
It would also be nice to know what are the limitations of the "Offline cube" wizard. I was never able to get anything useful out of this wizard nor able to script it. It is not letting you define complex offline cubes.
Philippe
|||Let's not confuse PTS with Excel Pivot Tables - they're not the same thing! To quote from the link given earlier in this thread:
PivotTable Services 8.0 is the OLE DB provider for SQL Server 2000 Analysis Services and is used to connect with an Analysis Services 2000 server. PivotTable Services does not work with SQL Server 2005 Analysis Services. Therefore, client applications that need connect to Analysis Services in both SQL Server 2000 and SQL Sever 2005 will need to install both PivotTable Services 8.0 and Analysis Services 9.0 OLE DB Provider in a side-by-side configuration.
But to get to the point, I'm not sure if the size limitations of Excel pivot tables are documented anywhere but the limitations of local cubes are (up to a point). In SQL2000 Books Online the topic "local cubes, compatibility issues" gives a good overview; I can't find an equivalent in SQL2005 BOL but although AS2005 local cubes have more functionality, there are still restrictions such as no support for partitioning, pro-active caching, stored procedures.
HTH,
Chris
Subscribe to:
Posts (Atom)