Analysis

We have a decision support group here and we have built many Cubes. They
used to use SSMS then moved onto using BIDS to browse cubes. Since BIDS
isn't a really good end user tool for the general users - should we be
looking at getting them up on Excel pivot tables or Reporting Services and
using a Report Model? I see the Report Model from a cube is somewhat harder
than designing your data set with BIDS.Thanks for the comment - Proclarity does rock but we are in the $25k to $35k
for that tool - whereas we own the other tools already.
The 2007 Excel is really nice with the Pivot tables.
"BYU" <BYU@.discussions.microsoft.com> wrote in message
news:FA94F6FF-469A-40AA-A484-CA776E5FA1C8@.microsoft.com...
> BIDS is really a development tool. We are using both SSRS and Excel pivot
> table here. SSRS provides more standard/fixed format presentation of
> cubes.
> Excel sounds more suitable for your users since they are already familiar
> with dimensions and measures. Another tool, also from MS is ProClarity,
> which gives cube users much more flexibilites as well as functionalities.
> "Joe" wrote:
>> We have a decision support group here and we have built many Cubes. They
>> used to use SSMS then moved onto using BIDS to browse cubes. Since BIDS
>> isn't a really good end user tool for the general users - should we be
>> looking at getting them up on Excel pivot tables or Reporting Services
>> and
>> using a Report Model? I see the Report Model from a cube is somewhat
>> harder
>> than designing your data set with BIDS.