Skip to main content
O
OS_Pizza
Veteran
December 6, 2022

XFCELL - Can we use member filter ?

  • December 6, 2022
  • 1 reply
  • 0 views

1.How can we use the below member filter in red colour inside XFCELL. How can we use it?

XFCell(Cb#GolfStream:E#[NA Clubs]:C#USD:S#Actual:T#2022M1:V#YTD:A#69000:F#None:O#Top:I#Top:U1#Top.base.where(Text2 contains '|WFYear|'):U2#Top:U3#Top:U4#Top:U5#None:U6#None:U7#None:U8#None)

2. How can we use GetDataCell(A#A100+A#200) inside XFCELL to calculate some expression.

 

Thank you!!!

1 reply

J
OneStream Employee
JackLacavaOneStream Employee
OneStream Employee
December 7, 2022

XFCell is only able to retrieve one cell at a time, given a precise POV; you cannot use expansions there, nor calculations. If you want to use expansions and calculations, you need a Cube View. Have a look at the section "Presenting Data With Extensible Documents" in the Design and Document Guide (or search for it in online Help) for how to embed CVs in Extensible Documents including Excel.

Terms & ConditionsAccessibility statement