Skip to main content
C
CCI01
Newcomer
January 16, 2023

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

  • January 16, 2023
  • 1 reply
  • 0 views

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.

1 reply

aricgresko
aricgresko
Veteran
January 17, 2023

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.

C
CCI01Author
Newcomer
January 17, 2023

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
aricgresko
Veteran
January 18, 2023

=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). 

Terms & ConditionsAccessibility statement