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

Which OLAP tools allow attributes as row headers

Which OLAP tools allow attributes as row headers

Which OLAP tools allow attributes as row headers

Most OLAP tools produce tables with dimensions on the x and y axis and measures in the body. If I have a star schema, my outrigger tables generally hold an id, a short name, a long name, and various attributes such as groups, pack sizes, colour.
Most tools let me filter on attributes but don't allow them as part of the table.
In 'The Data Warehouse Toolkit' by Ralph Kimball he talks about using attributes as row headers.

So far I have got Business Objects to do it. Any others?

RE: Which OLAP tools allow attributes as row headers

Buddy, Have I got good news for you.
If you think about multidimensional databases and OLAP what you have is a bunch of dimensions or qualitative attributes. These dimensions define your crossings in the MDDB (MultiDimensional DataBase). Generally these attributes are of character or date data types. Further, there may be a hierarchy associated with a group of these attributes e.g. day, month, quarter, year. or employee, team, section, department, division, company

Then you have the quanititative attributes or measures which as you have probably guessed are of a numeric data type. Now I dont want to complicate things too much at this stage, but I have to mention that some of these numeric measures may be what is known as "additive" and some may not not. Ask me if you want to know more ( loginjames@extra.co.nz)

When it comes to viewers for slicing and dicing this type of info ( we're not just talking about text here, we're talking about graphs, charts, maps, org charts and tables) where traffic lighting, drilldown, expansion, subsetting by dimension and many other customisations are available there are few if any vendors that can compete with SAS Institute in this regard. See www.sas.com. Sorry did I forget to mention that this functionality is also WEB enabled?

RE: Which OLAP tools allow attributes as row headers

Can I take it that you like SAS ;-)

I've been thinking about my question and have further thoughts...

If I want to have something as a row header then it needs to be either a dimension or a hierarchy of a dimension. Therefore, products that allow me to have qualitative attributes (e.g. Oracle Express), but don't treat them as hierarchies, can only filter on them - this is because they haven't rolled-up the data on that attribute.

if the normal rollup is....

SELECT d1.Name, d2.Name, count(*)
FROM Fact_table f, Dim1 d1, Dim2 d2
GROUP BY d1.Name, d2.Name

(2 dimensions)

to use an attribute of PackSize as a row header the tool has to generate...

SELECT d1.Name, d1.PackSize, d2.Name, d1.PackSize, count(*)
FROM Fact_table f, Dim1 d1, Dim2 d2
GROUP BY d1.Name, d1.PackSize, d2.Name, d1.PackSize

(4 dimensions)

I expect that MOLAP tools such as Oracle Express aren't keen on me adding 2 dimensions to the rollup query as they carry out one rollup operation with all the dimensions. Adding 2 dimensions makes it becomes a much larger query.

ROLAP tools such as Business Objects carry out many rollups on demand. The user will only be asking for the dimensions that they want and may also limit the rollup with a WHERE clause, making the result set and calculation manageable.

This is why Business Objects allowed me to use the attributes as row headers and Oracle Express didn't. It's a MOLAP/ROLAP thing...

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