Cube Browser limitation in SQL Server 2005 Analysis Services -
08-12-2005
, 08:43 PM
Hi Folks,
Was wondering if anyone had encountered / overcome an apparent limitation in
the cube browser in SQL 2005 (June CTP) whereby only the first 500 measures
(calculations) are shown in the cube browser. In the measures folder in the
cube browser, we receive an error measure 'more measures exist than can be
shown'. Whilst this is a big number of measures, we have decided to add a
number of time based variations of each of our many base measures as
calculations and hence the number is achieved quite easily, but they are
managed nicely using the new display folder property of the calculation. We
can still query those measures not visible in the UI programmatially (via
MDX), but we arent able to query the cube using the browser which is
obviously a problem.
Any assistance greatly appreciated.
regards
ROB ZALISZ |