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

Clickstream: ROLAP or MOLAP?

Clickstream: ROLAP or MOLAP?

Clickstream: ROLAP or MOLAP?

We like Cognos, but we're not sure that a MOLAP solution can handle the volumes and dimensionality that will come with clickstream data. We like Microstrategy, but not sure if the slower response times will be an issue with our users.

Has anyone done clickstream analysis with either of these tools?


RE: Clickstream: ROLAP or MOLAP?

I've had experience with ROLAP, MOLAP and HOLAP but not in clickstream analysis.

The ROLAP was Oracle Express which tended to have a practical maximum of 6 dimensions, and a large volume of data starts making builds take longer than the period between updates!

The MOLAP was Business Objects which performed very well with high dimensionality (my record is a 114 dimension cube!) and coped with around 250k records.

The HOLAP is WhiteLight which is a bit more of a heavyweight (in price as well) but combines the best of both worlds.

The important variables are dimensionality, frequency of update, up-to-the-minute picture requirements, volume of data (and how much money you've got!).

As a matter of interest, what sort of data volumes are we talking about for a clickstream database?

RE: Clickstream: ROLAP or MOLAP?

We may be looking at as little as 10M rows of clickstream per month and maybe as much as 20M rows per month. We'll also expand the warehouse to include other "stars" in addition to the clickstream.

Cognos claims that they can handle the volumes and the dimensionality and the multiple star schemas, but I just really wanted to see if anyone else had used their tools specifically for clickstream.


RE: Clickstream: ROLAP or MOLAP?

    Sorry, bit of a break between your reply and this one.

    Is that 10-20 million rows you are talking about? , and I take it that you are talking about Cognos Powerplay.
Anyone who says that a MOLAP is useful for 10-20 million rows added per month has not told you how long it will take to build the cubes!

I'm a big fan of Whitelight when it comes to larger quantities and if the models are need to be more complicated (calculated measures, dependencies, etc.). I would say that the answer to your question is "neither, use HOLAP".

my home

RE: Clickstream: ROLAP or MOLAP?

 I know that Cognos and MicroStrategy are a ROLAP solution, for example Oracle Express and Hyperion Solutions are MOLAP way, everything dependes what do you want to do ?

  In your case I will use Oracle Express as MOLAP solution and as DOLAP solution Business Objects, with this scenario you can get very well results.

       Good luck


RE: Clickstream: ROLAP or MOLAP?

Look at hyperion they are comming out with click stream applications on top of Essbase a MOLAP databasse. If you can summerize your data a little it should work fine. The new attribute dimensions would allow even greater analysis of you individual users data.

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