Skip to main content
A
Anonymous
October 11, 2022

XFGetCell Formula Question

  • October 11, 2022
  • 2 replies
  • 0 views

When building CubeViews there is the .remove string that you can use to exclude a member from a hierarchy that you are pulling. Is there a way to replicate this with =XFGetCell formulas? Or in general, a way to include more than one member in an XFGetCell formula?

Posted by Dylan Cox

Migrated from Champions

2 replies

C
Cosimo
Contributor
October 11, 2022

Negative. The XFGetCell function can only pull one cell intersection as a time pointed by the POV you provide as parameters.

L
LeeB
Contributor
October 11, 2022

Not within a single XFGetCell but you can combine them in Excel formulas e.g.

 

LeeBown_0-1665506000131.png

 

image.png1163×235 10.1 KB

 

 
N
NicoleBruno
Veteran
October 11, 2022

To add to Lee’s suggestion, you could also pull a parent then subtract a base member or two if that’s an easier way to get to your solution.
The XFGetCell is pulling one specific intersection as opposed to the member filters used elsewhere so it’s a little more limited.

Terms & ConditionsAccessibility statement