SQL Server Performance

One Cube partition is showing double the value - urgent

Discussion in 'SQL Server 2005 Analysis Services' started by Arunesh, Nov 14, 2007.

  1. Arunesh New Member

    Hi,
    I am currently working Analysis services 2005
    For one partitcular partition alone the data is showing double the value when compared with the backend(view for this partition), were the rest of the partitions are not affected. Since the reports are maped to this cube via webservice the users are looking at wrong figures.
    Please can you advise me on this. How the data will be doubled in the cube alone when the partition view is showing the correct figures.
    Cube - AS 2005
    Database - SQL 2000
    Thanks
    Arunesh
  2. satya Moderator

    Are you using MDX or TSQL to obtain the data?
    Also what is the service pack levels on SQL instance?

Share This Page