Pivot Tables and member properties?

  • I have Pivot Table users who have a need to access the member properties of a certain dimension. Is this possible for an end-user (without MDX) using Excel Pivot Tables?

    Here's a bit more background. There are currently two dimensions that do pretty much the same thing. [Customer Number] and [Customer Name]. [Customer Number] is used heavily in a three tier ASP/MDX application and is required. [Customer Name] however is only used by the Pivot Tables users because they prefer to see the data in this way.

    [Customer Number] has the following levels

    • Region
    • Customer Number

    • Member Property "Customer Name"

    [Customer Name] has the following levels

    • Region
    • Customer Name

    Both dimensions draw on the same dimension table.

    Having the two dimensions wastes processing time and is generally annoying to me. Furthermore looking at adding new dimensions we need to get rid of the [Customer Name] dimension.

    I need to find a way using Excel PTs and the [Customer Number] dimension to allow users who can only click and drag, to see a list of customer names.

    Any help or suggestions would be greatly appreciated.

    Thanks!

    Chris Umbaugh
    Data Warehouse / Business Intelligence Consultant
    twitter @ToledoSQL

  • This was removed by the editor as SPAM

  • You are not likely to be able to do this in excel. I have never found a way.

    Check this site on info you will need to perform the action in a ms product. Link = :

    http://www.localcubetask.com/session2.htm

    Near the top it states 'You can view the member properties in the cubes if you use the Office Web Components from Office XP or the Data Analyzer'

    If you do find out how to do so in excel, I would love to know. I am 99% certain it is not possible, though.


    ------------------------------
    The Users are always right - when I'm not wrong!

  • Hi Chris,

    Which version of Excel are you using ?

    With the XP or 2003 version there aren't problem! Just put the dimension in the pivot table schema, select a member that have property defined on it and then click "Property fields" on Pivot table menu to choose the property that you want show!

    Or may be I have not understood what you want to do ?

    Very interesting the article reported by Jonathan! Have to read it!

    Regards,

    Marco.


    "...e il mio maestro mi insegnò com'è difficile trovare l'alba dentro l'imbrunire" F.Battiato - Prospettiva Nevsky

  • Thanks. That's exactly what I was looking for. I have XP as do all of the users. Sometimes things are just right under your nose, like this one.

    Chris Umbaugh
    Data Warehouse / Business Intelligence Consultant
    twitter @ToledoSQL

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply