×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Front end tools to access MS Analysis Server cubes
2

Front end tools to access MS Analysis Server cubes

Front end tools to access MS Analysis Server cubes

(OP)
Hello.

I currently have a small data warehouse on Windows 2k/SQL 2k.
I am using Business Object's BusinessQuery MD (formerly OLAP@WORK)
This tool has been a maintenance nightmare and I need to find alternatives.

Here is the question:

Are there any other tools that will allow access to MS Analysis Server cubes?

Any recommendations would be greatly appreciated.


Thanks,

Eric

RE: Front end tools to access MS Analysis Server cubes

Look at the Proclarity product.

RE: Front end tools to access MS Analysis Server cubes

Proclarity. We are about to use the same product set.
DataWarehouse of Oracle 8.
SQL2000 OLAP tools for the datamarts/cubes
Win2k Server to run on.
Also offers thin client access as well as full / rich client.
Integrates with outlook,excel and others.

It appears to beat all the other presentation tools for our purposes hands down.

Previously use Business Objects. But this has turned out to be too cumbersome for our needs.

RE: Front end tools to access MS Analysis Server cubes

Yes,  I second the motion.  Take a serious look at Proclarity.

RE: Front end tools to access MS Analysis Server cubes

Anybody know of other places to download Proclarity software other than http://www.knosysinc.com/ ??

RE: Front end tools to access MS Analysis Server cubes

(OP)
If you can wait a bit, you can request an eval copy from proclarity. It comes snail mail in about a week.

RE: Front end tools to access MS Analysis Server cubes

(OP)
Anybody use/know anything about the Crystal Reports for OLAP tool?

RE: Front end tools to access MS Analysis Server cubes

Crystal Analysis? Brand new product for viewing MS SQL analysis server OLAP and distributing via the Crystal Enterprise web tool. I will be recieving a copy very soon to evaluate it.

In the meantime, I endorse the comments on ProClarity!

Icytrue

icytrue@hotmail.com

RE: Front end tools to access MS Analysis Server cubes

Our warehouse is in the planning stage ,We will be using HP-UX unix  and oracle 9i.Our intial projection for 3 yrs is 1.2 TB .
 I need help evaluating the ETL tools .Are oracle 9i's features for ETL good enough ,to eliminate spending on any other ETL tools.

Thanks.

RE: Front end tools to access MS Analysis Server cubes

Few questions:  Why & how do you plan to use Oracle for a terabyte sized warehouse?  Do you plan to have more than 5-10 simultaneous users?  Aren't you concerned about growth limitations & bottlenecks?  I didn't know Oracle scaled to those limits - can you advise on how you made the decision towards Oracle?  Thanks..
ETL:  How often do you plan to load data?  Monthly, weekly, daily, hourly, continuous?

RE: Front end tools to access MS Analysis Server cubes

Can someone offer an opinion on using Cognos tools
Impromptu or PowerPlay for accessing MS Analysis Services Cubes on the SQL Server ?

Alternativelly could someone comment on the advantages/dis-advantages of using Analysis Services Cubes vs. Cognos 'PowerCubes'

RE: Front end tools to access MS Analysis Server cubes

Try building an ASP solution on SQL Server 2K. Its a very cheap way of building an OLAP reporting architecture on SQL Server 2K and you can all the facilities of changing the dimensions, drill down, etc.

You can also use the Pivot tables in Excel 2000 as a front end. If price is not an issue try Cognos, Business Objects, Crystal Info.

RE: Front end tools to access MS Analysis Server cubes

Is web access important?  or are you building custom clients?  I have worked with a tool called alphablox before for doing custom web front-ends.  You might check them out.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close