+ Reply to Thread
Results 1 to 3 of 3

Cell reference in CubeMember function

  1. #1
    Registered User
    Join Date
    10-30-2008
    Location
    Denmark
    Posts
    1

    Cell reference in CubeMember function

    Hi,
    I would like to include cell references into the CubeMember function.

    When I use the “Convert to formulas” function in a pivot table linked via Analysis Services I get a CubeMember function like:

    CUBEMEMBER("globl0720 KPI DW KPI";{"[KPI].[KPI].[KPI].&[64]"\"[Location].[Blade Type].&[ES-PON]&[1]"})

    Since “ES-PON” represents my factory location and I want to fetch the CubeMember from a (dynamic) list of locations such as ES-PON, ES-GAL, DK-VIN etc. I would like to make a cell reference instead.

    Example using the data in cell A1:

    ="CUBEMEMBER("&"""globl0720 KPI DW KPI"&""";{"&{"""[KPI].[KPI].[KPI].&[64]""\""[Location].[Blade Type].&["}&$A$1&"]&[1]""})"

    Even building the formula string inside the “Indirect Formula” does not work but returns the result #REF!

    I appreciate your help

  2. #2
    Registered User
    Join Date
    03-01-2010
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Cell reference in CubeMember function

    Hi

    When you use internet explorer, pls pay attention to sidebar. You can see articles related, pdf or ppt file…you can find out your info.

    Best regards

  3. #3
    Registered User
    Join Date
    03-01-2010
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Cell reference in CubeMember function

    Hi

    When you use internet explorer, pls pay attention to sidebar. You can see articles related, pdf or ppt file…you can find out your info.

    Apart from that, you also can ref more at: key performance indicators examples

    Best regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1