Calculated Member

  • This is correct

    store.currentmember.properties("Store_Manager")

    I want to obtain information of the column Store_Manager, the table Store, this is dimension, but BUT IT SHOW TO ME A MESSAGE OF ERROR: #ERR

    Do you can help me?

  • First and dummiest: single quote instead of double quote.

    _____________
    Code for TallyGenerator

  • Double quote, single quote IT SHOW TO ME A MESSAGE OF ERROR and not permit run

    See this sample, I create in MDX Sample Application:

    WITH

    MEMBER

    Measures.[Store SqFt]

    AS

    '[Store].CURRENTMEMBER.PROPERTIES("store name")'

    SELECT

    { [Measures].[Store SQFT], [Measures].[Store Cost], [Measures].[Unit Sales] }

    ON COLUMNS,

    [Store].[Store Name].MEMBERS

    ON ROWS

    FROM Sales

    The column Store SqFt, show message #ERR

  • You must change  :

    Measures.[Store SqFt]

    AS

    '[Store].CURRENTMEMBER.PROPERTIES("store name")'

    to

    Measures.[Store SqFt]

    AS

    '[Store].CURRENTMEMBER.PROPERTIES("Store SqFt")'

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

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