Forum Discussion

CCI01's avatar
CCI01
New Contributor
3 years ago

Excluding a base member when running an XFGet at a Top member

Hi,

 

I have a saved report setup with XFGets. One of the dimensions on the report points to the member "Top." Is there a way to have the XFGet show Top of the dimension and exclude a base member?

Thanks.

Excel Add In

3 Replies

Sort By
  • aricgresko's avatar
    aricgresko
    Contributor III
    3 years ago

    My recommendation would be to create an alternate hierarchy that excludes the particular base member so this can be directly pulled in the XFGet.  The downfall to this is having to maintain additional hierarchies.

    If it's just a one-off request, you could subtract two XFGet's within the same cell to exclude that base member.

    • CCI01's avatar
      CCI01
      New Contributor
      3 years ago

      Thanks for the recommendation on the alternate hierarchy. I will be skip that since this is more like a one off request.

       

      I’m still new to XFGets. How would you write a subtraction of an XFGet within the same cell to exclude the base member?

      • aricgresko's avatar
        aricgresko
        Contributor III
        3 years ago

        =XFGetCell(xxx,xxx,xxx,xxx,"Top",xxx,xxx,xxx)-XFGetCell(xxx,xxx,xxx,xxx,"Base",xxx,xxx,xxx)

        The key thing to note is that you need to full XFGetCell strings... you cannot subtract members within the same dimension inside 1 XFGetCell.  You can do that in Quick Views, however, using a GetDataCell (examples found under Samples in the Member Filter Builder).