Re: AS 2005 SP1 Cube Corruption and HY008 Errors

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Akshai,

Thanks for replying.

Processing each dimension individually works because it is not a full
processing. When I hit the limit that the problem occurs then I get
the errors on full processing. I will try processing just the
structure and then the data and see if this has any effect. I think
that this is an SP1 problem and am trying to find a work around.
Dropping SP1 is not an option because SP1 fixed an aggregation problem
(undocumented by Microsoft) so I can't go backwards (as inviting as it
sounds).

I still miss the virtual cubes. I find that linked measure groups are
very nice but don't really replace virtual cubes. I'd rather have two
separate cubes that I can query as one. We are using ProClarity and I
can't query two separate cubes with it. I'm stuck with merging the
data into a single cube unless someone has some idea of an alternative
that would work in this application space.

- Grant

.

Relevant Pages

  • Re: AS 2005 SP1 Cube Corruption and HY008 Errors
    ... You can make dimension processing also do a ... I definitely will not recommend going backwards from SP1 to RTM:) And I ... you can create two cubes with the physical measure groups in them. ...
    (microsoft.public.sqlserver.olap)
  • Re: DISCOVER_XML_METADATA
    ... unprocessed cubes and it doesn't show processing status information about ... A DBSCHEMA_CATALOGS query will get you a list of all the databases ... the database list to the list of cubes for a selected database. ... The XML fresult is too long and I don't need eveything (e.g. dimension ...
    (microsoft.public.sqlserver.olap)
  • AS2K and OWC 10 scalability issues
    ... optimized and can generally produce query results in a decent amount of ... The cubes are relatively big ... simple query against one of my larger cubes, ... I know the commandtext property works, ...
    (microsoft.public.sqlserver.olap)
  • Re: DISCOVER_XML_METADATA
    ... unprocessed cubes and it doesn't show processing status information about ... A DBSCHEMA_CATALOGS query will get you a list of all the databases ... the database list to the list of cubes for a selected database. ... The XML fresult is too long and I don't need eveything (e.g. dimension ...
    (microsoft.public.sqlserver.olap)
  • Fairly Large Cube-Performance Improvement recommendations
    ... I'm having problems with very poor response time when users query our ... We have tried warming up the cubes by executing MDX of the common ...
    (microsoft.public.sqlserver.olap)