Re: Data mining tools



Seriously though, if you're looking for a graphical query builder, then
there are a few around that insulate you from most of the complexities
of SQL. However, people may still need to have some level of
understanding of your database structure, or perhaps the views you
provide.

Once a cube is built, it is very easy for users to work with them.
They love the ability to drill down through data and look at their way.

Thanks, Kevin. So, two questions:

1 - Given my example, do you have an opinion on the direction to go
(graphical query builder vs. cube)?

2 - I've never gone down the OLAP cube road. Do you have a particular
favorite where there are examples available and where the learning curve to
build the cube is not a vertical line?

js


.



Relevant Pages

  • Re: Strange processing error.
    ... I've a sneaking suspicion that this may be down to memory, ... Analysis Services previously (especially when trying to share a box w/ a SQL ... There are around 7-10 dimension connected / measure group. ... cube Analysis Services Execute DDL Task ...
    (microsoft.public.sqlserver.olap)
  • Re: Impact on cube availibility while Processsing one of the parti
    ... The cube will go into an unprocessed state until you reprocess ... SQL BI Product Unit ... This posting is provided "AS IS" with no warranties, and confers no rights. ... >> SQL BI Product Unit (Analysis Services) ...
    (microsoft.public.sqlserver.olap)
  • Re: 2000 vs. 2005 OLAP hierarchies question
    ... Services technical drilldown white paper. ... SQL BI Product Unit ... suggestions for best practices in dimensional model, ETL, cube and ...
    (microsoft.public.sqlserver.olap)
  • VS 2005 is trying to deploy WRONG database... help!
    ... All was well and good until this latest change to the cube - all I did ... Errors in the metadata manager. ... \SX Sql Extract EC Flat.20.det.xml'. ... another dev went and compressed the entire Program Files --> SQL ...
    (microsoft.public.sqlserver.olap)
  • Re: LIMIT OF FACT TABLE DATA
    ... SQL BI Product Unit ... > There is no limit on the size of the fact table in Analysis Services. ... >> My Warehouse Data is basically in Oracle and I am using SQL Server DTS ... > ETL and SQL Server Analysis Services for viewing the cube. ...
    (microsoft.public.sqlserver.datawarehouse)