Was there ever so good a cube browser as the Holos Worksheet?

I spent a bit of time working with the now defunct Holos product. (Crystal Decisions did a Computer Associates on it but that’s a story for another day).

For those who do not know about Holos, it was the bees knees of OLAP products and based on my exposure to competitor products since, I would say it is still up there. It’s problem was that it did not have a sexy front end but I digress. (I’ll leave that story for another day too)

It had a Native Windows and Macintosh GUI front end that would allow a user to browse the contents of a cube. You could change views by dragging and dropping the dimension names.

A lot of products rely on Excel as a client. This has it’s place but you cannot get in and quickly slice and dice. The Excel clients are very easy to stuff up. The Holos Worksheet was impossible to stuff up – well, if you tried to read a 25 dimension cube and embed 20 of them you could. The nice thing was that you could drag and drop but you couldn’t have non-sensical combinations like you could in, say Cognos Powerplay.

Please could someone tell me if there is such a tool out there that can browse Essbase cubes or Analysis Services cubes in a similarly elegant fashion.

Advertisements

6 thoughts on “Was there ever so good a cube browser as the Holos Worksheet?

  1. Hi,

    I don’t suppose you know an easy (or not so easy come to that matter) way of extracting data en masse from Holos do you? I need to migrate the data to an SSAS environment but am not even sure how to get started in connecting and extracting data.

    regards

    Colin

  2. Hi,

    I don’t suppose you know an easy way (or not so easy way come to that matter) of extracting data en masse from a Holos cube? I need to migrate a legacy Holos cube to SSAS and am unsure where to begin.

    regards

    Colin

  3. You can export to a flat file or a relational database using the LOADBLOCK.

    You should be able to find examples of this in the Help.

    Where are you located?

  4. Try this for a flat file:

    LOAD WRITE
    FORMAT “column directed”
    COLUMN LOCATION = 1, WIDTH = 2, TYPE = TEXT
    COLUMN LOCATION = 5, WIDTH = 1, TYPE = TEXT
    COLUMN LOCATION = 10, WIDTH = 2, TYPE = NUMBER
    DIMENSION products ITERATE products COLUMN 1
    DIMENSION weekly ITERATE * COLUMN 2
    VALUE COLUMN 3
    WRITE HOSTFILE “source.txt”
    END LOAD

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s