01-16-2023 06:11 PM - last edited on 05-24-2023 12:28 PM by JackLacava
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.
01-17-2023 07:51 AM
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.
01-17-2023 01:14 PM
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?
01-18-2023 08:05 AM
=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).