Re: Setting UNAME and/or MEMBER_UNIQUE_NAME to the Member Key Column

From: Hanying Feng [MS] (hfeng_at_online.microsoft.com)
Date: 06/22/04

  • Next message: Hanying Feng [MS]: "Re: Setting UNAME and/or MEMBER_UNIQUE_NAME to the Member Key Column" 
    Date: Tue, 22 Jun 2004 16:37:29 -0700

    I don't think you can let UName show the key unless changing the Member Key
    pointing to Company Name. Alternatively, you can consider using dimension
    properties. In your MDX query, you can add dimension properties member_key,
    for example, select [Account].[Level 02].members dimension properties
    member_key on 0 from budget. It will show the member key for each member,
    and you can select to disaply this member key instead of UName.

    Thanks,
    Hanying 

    -- 
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"Joe Genshlea" <joegensh@yahoo.com> wrote in message
news:%23tyGGb$VEHA.3420@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I have a virtual dimension called Lender where the Member Key = Lender Id
> (integer) and the Member Name = Company Name.  NOTE: Our lender table has
> many unrelated lenders with the same name (ABC Lending), so Lender
Dimension
> is set up with LenderID as the unique member key.
>
> The Virtual Dimension only has one level called Lender Group
>
> I have the Properties set as follows (in AS manager UI)
>
> Dimension:
> Member Keys Unique: TRUE
> Member Names Unique: False
> Allow Duplicate Names: True
>
> Level:
> Member Names Unique: FALSE
>
>
>
>
> Problem: UNAME that is returned in the XML string is the Member Name, not
> the Member Key.   I really would like to have the UNAME = member key (e.g.
> the numeric Lender Id) .  How do I set this up?
>
> Joe
>
>
  • Next message: Hanying Feng [MS]: "Re: Setting UNAME and/or MEMBER_UNIQUE_NAME to the Member Key Column"

    Relevant Pages

    • Re: dimension member key case statement
      ... you want -- then load the dimension from the view. ... > I'm trying to use a Case statement for the member key and name columns for ... > The syntax is correct for a sql qry, but the key doesnt like it and doesnt ...
      (microsoft.public.sqlserver.olap)
    • Re: Need help to build a dimension with duplicate members using a parent child
      ... SQL BI Product Unit (Analysis Services) ... > I need to build a dimension that would have duplicate member under ... > parent child relationship. ... > "The dimension member key is not unique". ...
      (microsoft.public.sqlserver.olap)
    • Re: Member Name Column property
      ... No, as long as you have the ID column setup as the member key, you can ... change the member name by simply incrementally processing the dimension ... example would be if you had an employee dimension and you wanted to move ...
      (microsoft.public.sqlserver.olap)
    • Re: Default member of dimension
      ... This is a dimension ordernig issue. ... You have 2 options to fix this: ... Change the ordering to order by member key ... Change the format of your report name from MM-YYYY to YYYY-MM ensuring ...
      (microsoft.public.sqlserver.olap)
    • Setting UNAME and/or MEMBER_UNIQUE_NAME to the Member Key Column
      ... I have a virtual dimension called Lender where the Member Key = Lender Id ... The Virtual Dimension only has one level called Lender Group ... Allow Duplicate Names: True ...
      (microsoft.public.data.xmlanalysis)